MS Access Level 3

Course: 9003

This course is the third part of a three-course series that covers the skills needed to perform basic database design and development in Access 2019.

Download PDF
  • Duration: 2 days
  • Price: $895.00
Get This Course $895.00
December 12 - 13

9:00 AM – 4:00 PM CST

January 16 - 17

9:00 AM – 4:00 PM CST

February 13 - 14

9:00 AM – 4:00 PM CST

March 13 - 14

9:00 AM – 4:00 PM CST

Scroll to view additional course dates

Reserve Your Seat

  • Virtual instructor Led Training
  • Complete Hands-on Labs
  • Softcopy of Courseware
  • Learning Labs
  • Virtual instructor Led Training
  • Complete Hands-on Labs
  • Softcopy of Courseware
  • Learning Labs
  • You can use your Purchase Card and checkout
  • The GSA Contract Number: 47QTCA20D000D
  • Call 800-453-5961 for details
  • Customize your class
  • Delivery Onsite or Online for your organization
  • Choice of Dates when and where you want
  • Guidance in choosing and customizing your class

Question About this Course?

Access 2019 Level 3 – Advanced

Access 2019 Level 3 – Advanced. Versions 2013, 2016, 2019, Office 365, & Online are also available. This course is the third part of a three-course series that covers the skills needed to perform basic database design and development in Access 2019.

Advanced Access 2019 course is for students who are planning to design databases at an advanced level and want to enhance existing Access 2019 or Access 365 databases.

Course Outline

Lesson 1 – Working with Macros

  • Creating a Macro
  • Adding Additional Macro Actions
  • Running a Macro Step-By-Step
  • Assigning a Macro to a Command Button
  • Creating a Macro Group
  • Using a Macro Group
  • Using Macro Conditions
  • the Autoexec Macro
  • Creating an Autokeys Macro
  • Creating a Data Macro
  • Adding a Macro to the Quick Access Toolbar

Lesson 2 – Action Queries

  • About Action Queries
  • Creating a Make-Table Query
  • Creating an Append Query
  • How to create an Update Query
  • Creating a Delete Query
  • Creating a Sql Query

Lesson 3 – Importing and Exporting Data

  • Importing Data from a Text File
  • Importing Data from Excel
  • Import Data from Another Access Database
  • Linking Data
  • Exporting Data to Other Formats
  • Exporting Data to a PDF File
  • Export Data to Another Access Database
  • Exporting Data to Excel
  • Exporting Data to Microsoft Word
  • Transfer Data to a Microsoft Word Mail Merge

Lesson 4 – Creating a Menu System

  • Creating a Switchboard
  • Adding Switchboard Items
  • Using the Switchboard
  • Editing a Switchboard
  • Setting Startup Options
  • Creating a Navigation Form

Lesson 5 – Working with Forms and Reports

  • Adding a SubForm Using the SubForm/SubReport Tool
  • Modifying a SubForm
  • Aligning Controls to Each Other
  • Creating an Option Group
  • Edit Sorting and Grouping Levels in a Report
  • Inserting Total Fields in a Report
  • Using Rectangles, Lines and Borders

Lesson 6 – Database Tools and Maintenance

  • Using Compact and Repair
  • Changing Database Properties
  • Documenting a Database
  • Analyzing a Database
  • Viewing Object Dependencies
  • Backing Up a Database
  • Splitting a Database
  • Setting a Database Password

Question About this Course?

Need help picking the right course?

Contact Us

Call Now

Call Now800-453-5961