Advanced Microsoft Access
Overview
This Advanced Access training class is for students who intend to design databases
at an advanced level and/or want to improve existing Access databases.
Who Should Attend
Students who have basic skills with Microsoft Access who want to learn advanced-level skills
or students who want to learn the topics covered in this course in the Microsoft Access interface.
Course Objectives
-
Learn about database relationships.
-
Learn to work with table relationships.
-
Learn to work with queries at an advanced level.
-
Learn to work with forms at an advanced level.
-
Learn to work with reports at an advanced level.
-
Learn to work with macros.
-
Learn to complete the desktop application with the navigation form.
Class Prerequisites
Experience in the following is required for this Microsoft Access class:
-
Introductory-level knowledge and skills working with Microsoft Access.
Certifications
-
Microsoft Office Access 2016
Course Overview
1 Relationships
-
Review
-
Referential Integrity
-
Relationships
-
Data Types and Relationships
-
Formalize the Relationship between Tables
-
A Few Words about Naming Conventions
-
Creating Relationships
2 Queries
-
Query Design View
-
Review of Select Queries
-
Review of Select Queries with Criteria
-
Logical Operators
-
Parameter Queries
-
Action Queries
-
Make Table Queries
-
Append Queries
-
Update Queries
-
Delete Queries
-
Creating Crosstab Queries
-
Delete a Query
-
Rename a Query
-
Creating Select and Action Queries
-
Creating a Parameter Query
3 Table Functions
-
Importing Data
-
Linking Tables from External Sources
-
Import Tables from other Databases
-
Tables from Templates and Application Parts
-
Importing Data from Excel
-
Exporting Data to Excel
4 Forms
-
Design View
-
Form Sections
-
Adding a Header and Footer
-
Adding a Logo to the Header
-
Adding a Title to the Header
-
Adding Fields to a Form
-
Arranging Fields on a Form
-
Spacing Objects on a Form
-
Formatting
-
Tab Order
-
Setting Properties on a Form
-
Controls
-
Create Forms with Application Parts
-
Creating a Subform
-
Creating Forms
-
Alter a Form
-
Delete Forms
-
Remove Form Controls
-
Format a Form
5 Reports
-
Design View
-
Report Sections
-
Report Header
-
Page Header
-
Group Header
-
Detail
-
Group Footer
-
Page Footer
-
Report Footer
-
Adding a Report Header/Footer
-
Adding a Logo to the Report Header
-
Adding a Title to the Report Header
-
Adding Fields to a Report
-
Add Calculated Fields
-
Arranging Fields on a Report
-
Resizing the Detail Section
-
Eliminating Repeating Headings
-
Set Margins
-
Grouping and Sorting
-
Setting Properties on a Report
-
Report Property Sheet
-
Section Property Sheet
-
Object Property Sheet
-
Adding Record Counts
-
Special Report Fields
-
Dates
-
Page Numbering
-
Controls
-
Printing a Report
-
Subreports
-
Application Parts
-
Deleting a Report
-
Formatting a Report
-
Adding a Background and Images and Applying a Theme
-
Creating Reports
6 Macros
-
Macro Basics
-
Open a Table, Form, and Report
-
Run a Query
-
Print a Report
-
Running a Macro
-
Creating Simple Macros
7 Completing the Desktop Application
-
The Navigation Form
-
Running Macros from a Navigation Form
-
Setting the Navigation Form as the Default Form
-
Creating a Navigation Form
-
Splitting the Database
-
Encrypt with a Password
-
Distributing the Front-End Database
-
Database Maintenance
-
Compact and Repair
-
Backup/Recover a Database
-
Maintain Backward Compatibility