Microsoft Access 2019 Advanced

COURSE DESCRIPTION

This course enables the participant to operate effectively at more than a basic level of competence and be able to realize much of the potential of the database application. The participant shall be able to use the database to organize, extract, view and report on data using what are deemed to be advanced data management skills. The participant shall understand the variety of ways that data can be related and organized. In addition, the candidate shall be able to run and record simple macros and to import, export and link data.

COURSE OUTLINE

Module 1. Designing Advanced Queries

• Setting Top Values in a Query
• Creating a Calculated Field
• Formatting a Calculated Field
• Displaying a Totals Row in a Query
• Creating a Function Query
• Creating a Parameter Query
• Using Multivalued Fields
• Creating a Concatenation in a Query
• Filtering a Query
• Labs

Module 2. Creating Action Queries

• Creating a Make-table Query
• Creating an Update Query
• Creating an Append Query
• Creating a Delete Query
• Labs

Module 3. Using Advanced Query Wizards

• Using the Crosstab Query Wizard
• Using the Find Duplicates Query Wizard
• Using the Find Unmatched Query Wizard
• Labs

Please contact us for the full course outline, schedules and for booking a private class.

Inquire Now