Access 2019 Level 3 – Advanced. Versions 2013, 2016 Office 365, & Online are available.

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.

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