Microsoft Access Training CoursesThis Microsoft Access 2016 Advanced Training Course one-day course builds on the skills and concepts taught in Access 2016: Intermediate. Students will learn how to query with SQL; create crosstab, parameter, and action queries; create macros; import, export, and link database objects; work with XML documents; work with Windows SharePoint Services; optimize databases; password-protect and encrypt databases; set Access options and properties; create hyperlink fields; and use Outlook 2016 to update data.

 

Course objectives

After completing this course, students will know how to:

  1. Use SQL statements and examine them in Access, create aliases for fields, write SQL statements to create queries, and attach an SQL statement to a command button.
  2. Create crosstab queries to summarise grouped data, create parameter queries to view results based on specified criteria, and create action queries to add, delete, and modify data in tables and to make new tables.
  3. Create and run macros to automate tasks and attach macros to the events of database objects.
  4. Create data validation and data-entry macros, create macros that run parameter queries, create the AutoKeys and AutoExec macros, and create macros to import and export database objects.
  5. Save to previous versions. Split, compact, repair, and back up a database. Encrypt and password-protect database files. Configure Access Options and populate database file properties.
  6. Create, populate, and modify a hyperlink field. Collect data via e-mail by using Outlook 2016.

Course contents

Querying with SQL 
Topic A: SQL and Access 
Topic B: Writing SQL statements 
Topic C: Attaching SQL queries to controls

Advanced queries 
Topic A: Creating crosstab queries 
Topic B: Creating parameter queries 
Topic C: Using action queries

Macros 
Topic A: Creating, running, and modifying macros 
Topic B: Attaching macros to the events of database objects

Advanced macros 
Topic A: Creating macros to provide user interaction 
Topic B: Creating macros that require user input 
Topic C: Creating AutoKeys and AutoExec macros 
Topic D: Creating macros for data transfer

Importing, exporting, and linking objects 
Topic A: Importing objects 
Topic B: Exporting objects 
Topic C: Working with XML documents 
Topic D: Linking Access objects 
Topic E: Using hyperlink fields

Database management 
Topic A: Optimising resources 
Topic B: Protecting databases 
Topic C: Setting options and properties 

Prerequisites

Before taking this course, you should be familiar with personal computers and the use of a keyboard and a mouse. Furthermore, this course assumes that you've completed the following courses or have equivalent experience: Windows : Basic and Access 2016: Basic and Access 2016: Intermediate.

Target Audience

Youshould be comfortable using a personal computer and Microsoft Windows. You should also have some experience using Access 2016. You will get the most out of this course if your goal is to become proficient using more advanced Access features and functions, such as querying with SQL, using crosstab, parameter, and action queries, creating and running macros, importing, exporting, and linking database objects, optimizing a database, and basic database security.

Certification Track

For comprehensive training, you should complete all of the following courses: Access 2016: Basic, Access 2016: Intermediate, and Access 2016: Advanced