Length
1 Day
Experience Needed
Access 2016 Intermediate, or applicable experience
Summary
This class builds on a reasonable level of database design experience that may have been gained from the Introduction and/or Intermediate courses.
Who Should Attend
People who intend to design databases at an advanced level or improve existing Access databases. Also advanced conversion of databases made in other applications and spreadsheet (flat file) databases.
Course Content
Managing Relational Databases
- Database Concepts
- Database Design
- Normalization
- Database Integrity
- Types of Relationship
- Creating Table Links
- Referential Integrity
Optimizing and Administering Access
- Optimizing Performance
- The Performance Analyzer
- The Add in Manager
- Compacting Your Database
- The Database Documenter
- The Database Splitter
- Recovering Damaged Databases
- Importing and Linking Tables
Advanced Forms Customizing
- List and Combo Boxes
- Check Boxes, Option & Toggle Buttons.
- Option Groups
- Command Buttons
- Calculated Fields
- Using Form’s Input Values
- Create a Form with Multiple Pages or Tabs
- Tab Order
- Inserting Graphics in Forms or Reports
- AutoFormat
August 5, 2021 8:00 am
Register Now
September 16, 2021 8:00 am
Register Now
October 14, 2021 8:00 am
Register Now
