Access 2016 , Level 3 - Advanced
Versions 2013, 2016, 2019, Office 365, & Online are also available.
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
- Creating 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
- Importing Data from Another Access Database
- Linking Data
- Exporting Data to Other Formats
- Exporting Data to a PDF File
- Exporting Data to Another Access Database
- Exporting Data to Excel
- Exporting Data to Microsoft Word
- Exporting 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