Length
1 Day
Experience Needed
Access 2016 Introduction, or applicable experience
Summary
This class builds on a reasonable level of database design experience that may have been gained from the Introduction course.
Who Should Attend
People who intend to design databases at an advanced level or improve existing Access databases. Also conversion of databases made in other applications and spreadsheet (flat file) databases.
Course Content
Action Queries
- Types of Query
- The Crosstab Query
- The Make Table Query
- The Append Query
- The Delete Query
- The Update Query
Reports
- The Report Wizard
- Creating a Report with Summary Totals
- Using the Label Wizard
- Modifying and Redesigning the Report.
- Publishing Access Data on the Web
Customizing Forms
- Manipulating Data in the Form
- Creating A New Form
- Using the Form Wizard
- Creating a Form with a Sub form
- Modifying and Redesigning the Form
Protecting Desktop Databases with Backup and Restore Process
- Why do I need a backup?
- Creating a database backup
- Creating a Split Database
- Backing up back-end database and front-end database
- Restoring a database
August 10, 2021 8:00 am - 1:00 pm
Register Now
September 15, 2021 8:00 am
Register Now
October 13, 2021 8:00 am
Register Now
October 28, 2021 8:00 am
Register Now
