Microsoft Access 2016

$495.00

SKU: GC1917 Categories: ,

Microsoft Access 2016

Our Microsoft Access 2016 training materials provides you with a fully-customizable package of courseware content for delivering Microsoft Office training to your employees and/or students. Everything you need to run the course is included, just add trainer!

All courseware print licences are perpetual – buy once and use forever!

  • Complete. Two part course.
  • Fully customizable. Sold on a site licence basis, you can tailor ALL content to meet specific learning or corporate requirements.
  • Digital download. Content is available to download after purchase.
  • Proven. Our course materials are used in hundreds of training centres around the world. Every course is fully beta tested and validated in the classroom before undergoing a full production release.
  • Simple… No need to invest in expensive DTP applications – all files are easily editable in any word processor.
  • Print on demand. You only need to print exactly what you need, when you need it.
  • Totally flexible. Courses can be modified to meet specific requirements. Sections can be removed. New content added. One or more titles can be combined. Whatever your training requirements, our courseware can help you meet that need.
  • Unlimited users. Content is sold on a site licence basis. You can train as many staff or employees at that location as you like. Forever!
  • Buy once. Use forever! You’re buying a perpetual licence. One payment gives you an unlimited site licence for use as long as you need it.
  • No limits! Unlike some content providers, our licence enables you to reprint the courseware as many times as you like. 1 student or 100,000. No limits…

Student manual

Fully customisable. May be opened in any word processor and changed to meet your exact needs.

Student workbook

Fully customisable. Additional book includes series of practical tasks and review questions.

Student workbook exercises

Sample exercises to accompany the student workbook.

Trainer manual

Fully customisable with additional information for trainers.

Timetable and lesson plans

Detailed timetable and plans ensure you deliver the best possible course

PowerPoint presentations

PowerPoint presentations. Fully customisable. Complete set of PowerPoint slides for use by the trainer.

Course contents: Part One

  • Orientation to Microsoft Access • Microsoft Access 2016 • Access Files • Opening Databases • Access Web Apps • The Access 2016 Application Window • Tables • Forms and Views • Queries • Reports • The Ribbon Interface
  • Create a Simple Access Database • Database Templates • Web App Templates • Save Options • Field Definition • Methods to Create a Form • Form Object Views • Form Sections • Modifying Existing Forms • Saving Forms • Deleting Forms • Access Web App Views
  • Get Help in Microsoft Access • Using Tell Me • Accessing Advanced Help Options
  • Modify Table Data • AutoCorrect • Commit, Save, and Undo • Quick Search • The Find and Replace Dialog Box • Datasheet Totals
  • Work with Records • Adding New Records • Updating Records with a Query • Append Queries • Navigating Through Records • Printing Records
  • Sort and Filter Records • The Sort Feature • The Filter Feature • Filter Commands • The Group Feature
  • Create Lookups • Lookup Fields • The Property Sheet Pane • Review Questions
  • Join Data from Different Tables in a Query • Query Views • The Simple Query Wizard • Types of Queries • The Run Command • Query Design • Saving Queries • Deleting Queries • Renaming Queries
  • Sort and Filter Data in a Query • Query Criteria • Comparison Operators • Logical Operators • Sorting Query Results • Grouping Query Results • Formatting Query Fields • The Zoom Dialog Box
  • Perform Calculations in a Query • Arithmetic Operators • Adding Calculated Fields • Adding Conditional Logic • Review Questions
  • Create Parameter Queries • Parameter Queries • Wildcards in a Parameter Query • The Ampersand Operator
  • Create Action Queries • Action Queries • Types of Action Queries
  • Create Find Duplicate and Find Unmatched Queries • The Find Duplicates Query Wizard • The Find Unmatched Query Wizard
  • Summarize Data • Crosstab Queries • Multiple Table Queries
  • Create a Report • Report Creation Tools • Using Application Parts to Create Reports • Report Views • The Report Wizard • Saving a Report • Modifying an Existing Report • Deleting a Report
  • Add Controls to a Report • Report Sections • Adding Controls • Modifying Control Properties • Managing Labels • Inserting Images
  • Enhance the Appearance of a Report • Galleries • Themes
  • Prepare a Report for Print • Adding a Header or Footer • Inserting Page Numbers • Page Setup Options • The Print Preview Tab • Review Questions
  • The Access Options Dialog Box • Access Options • Review Questions
  • Relational Database Design • Relational Databases • The Relational Database Design Process • The Statement of Purpose • Existing Data • Guidelines for Determining Fields • Business Rules • Guidelines for Grouping Fields into Tables • Primary Keys • Foreign Keys • Composite Keys • Table Relationships
  • Create a Table • Table Creation Options • Importing Tables from Other Databases • Creating Tables with Templates • Table Views • Data Types • Inserting Fields • Quick Start Fields • Deleting Fields • Calendar for Picking Dates • The Lookup Wizard • The Table Properties Dialog Box
  • Modify a Table and Fields • Renaming a Table • Changing Field Captions • Changing Field Sizes • Configuring Fields to Auto-Increment • Setting the Default Value for a Field
  • Create Table Relationships • The Relationships Window • Referential Integrity • Guidelines for Enforcing Referential Integrity • The Edit Relationships Dialog Box • Join Lines • Relationship Report
  • Create Query Joins • Query Joins • Inner Joins • Outer Joins • The Join Properties Dialog Box
  • Join Tables That Have No Common Fields • Joining Tables with No Common Fields
  • Relate Data within a Table • Self-Joins • The Alias Property
  • Work with Subdatasheets • Subdatasheets
  • Create Subqueries • Subqueries • Review Questions
  • Data Normalization • First Normal Form • Second Normal Form • Third Normal Form • Denormalization • The Table Analyzer Wizard
  • Create a Junction Table • Many-to-Many Relationships • Junction Tables • Review Questions
  • Import Data into Access • Data Importing • The Get External Data Wizard • Delimiters
  • Export Data to Text File Formats • Data Exporting
  • Export Access Data to Excel • Exporting Access Data to Excel
  • Create a Mail Merge • The Microsoft Word Mail Merge Wizard • Merge Fields • The Mail Merge Task Pane • Review Questions
  • Organize Report Information • Report Design Elements • Report Design Tools • The Group, Sort, and Total Pane • The Field List Pane • Adding a Background Image to a Report
  • Format Reports • Report Format Tools • Report Control Properties • Report Pagination
  • Include Charts in a Report • Data Bars • Charts
  • Add a Calculated Field to a Report • Calculated Fields
  • Add a Subreport to an Existing Report • Subreports • Review Questions
  • Create a Mailing Label Report • The Label Wizard
  • Publish a Report as PDF • Publishing a Report as PDF • Review Questions
  • Post-Course Assessment
  • Appendices • Keyboard Shortcut Quick Reference Sheet • Glossary • Index

Course contents: Part Two

  • Add Controls to Forms • Types of Controls • Command Buttons • Quick Start Fields • Calendar/Datepicker Control • Form Layouts • Quick Styles • Tab Order • The Anchoring Tool
  • Set Form Controls • Move Form Controls • Add Form Controls • Remove Form Controls • Modify Data Sources • Set Form Control Properties • Manage Labels
  • Create Subforms • Subforms
  • Organize Information with Tab Pages • Tab Pages
  • Enhance Navigation with Forms • Navigation Control and Navigation Forms • Setting Navigation Options • Creating a Navigation Form • Using a Navigation Form
  • Format a Form • Insert Headers And Footers • Insert Images • Auto-Order Forms • Sort Records • Apply Themes • Insert Backgrounds • Change Margins
  • Apply Conditional Formatting • Conditional Formatting • Review Questions
  • Field Validation • Field Properties • Input Masks • The Input Mask Wizard • Input Mask Characters • Lookup Lists • Expression Builder
  • Form and Record Validation • Form Validation • Control Wizards • The Combo Box Control • The List Box Control • The Option Group Control •
    Record Validation • Review Questions
  • Create a Macro • Macros • The Macro Builder Window • Macro Actions • Types of Macro Actions • Action Arguments • Object Events • Macros in Access Web Apps
  • Restrict Records Using a Condition • Macro Conditions • The Where Condition
  • Validate Data Using a Macro • Event Properties for Data Validation • Macro Actions for Data Validation • Embedded Macros
  • Automate Data Entry Using a Macro • Event Properties for Automating Data Entry • Macro Actions for Automating Data Entry
  • Convert a Macro to VBA • Macros and VBA • Review Questions
  • Link Tables to External Data Sources • External Data Sources • The Linked Table Manager
  • Manage a Database • Exclusive Mode • Database Access Modes • Database Backup • The Compact and Repair Database Option
  • Determine Object Dependency • Object Dependency
  • Document a Database • The Database Documenter
  • Analyze the Performance of a Database • Performance Analyzer • Review Questions
  • Split a Database for Multiple User Access • Splitting a Database • Merging a Database
  • Implement Security • Security Strategies in Access 2016 • The Message Bar • The Trust Center Dialog Box • Trusted Locations
  • Set Passwords • Password Protection Guidelines
  • Convert an Access Database to an ACCDE File • The ACCDE File Format • User Templates • Saving Databases as Templates
  • Package a Database with a Digital Signature • Digital Signatures • Digital Certificates • The Package and Sign Feature • Review Questions
  • Create a Database Switchboard • Switchboards • Switchboard Manager
  • Modify a Database Switchboard • Switchboard Modification
  • Set Startup Options • Database Startup Options • Review Questions
  • Appendices • Keyboard Shortcut Quick Reference Sheet • Glossary • Index