1 - day course
Print this page
Course Code: D191Aen
Who should attend?
This course is intended for new Microsoft Access 2019 users.
Windows 10 or equivalent
Course Objectives
Upon completion of the course, participants will be able to accomplish the following:
  • Identify the components of a database, and work with those components.
  • Open a table, find information stored there, and enter data.
  • Create several query types, edit and run queries, and use action and calculation queries.
  • Create several report types, enhance reports, create charts, and print preview reports.
  • Preview and print database objects, and change the page setup options.
Course Content  
    The Basics
    Database Concepts ; Getting Started ; Creating a Database ; Converting Access 2016 Files ; Working with Objects ;
    Table Data
    Table Concepts ; Viewing Data in a Table ; Changing the Datasheet Appearance ; Entering and Editing Data ; Applying Filters ;
    Using the Query Wizard ; Creating a Query in Design View ; Selecting and Sorting in a Query ; Calculations ; Action Queries ; Parameter Queries ;
    Creating Reports ; Using the Report Wizard ; Previewing Reports ; Creating Reports in Design View ; Changing Report Design ; Control Operations ; Control Attributes ; Creating Charts ;
    Printing Objects ; Print Preview ;