Microsoft Access 365 / 2019 / 2016 Level 3
Make more informed decisions by effectively tracking, reporting, and sharing information with Microsoft Access.
With our extensive knowledge of the different software currently on the market, including all Microsoft and Adobe applications, ON-TRACK Corporate Training Ltd. has a diverse and flexible schedule that can be customized to your needs – we offer group course (both public and corporate), one-on-one training, and on-site training options. We also have easily accessible on-line training videos available.
Duration: 1 Day
Objectives
To build on a reasonable level of database design experience that may have been gained from the Microsoft Access 2016 Level 2 course.
Prerequisites
- Microsoft Access 365 / 2019 / 2016 Level 2 or equivalent experience
Outline
- Managing Relational Databases
- Database Concepts
- Database Design
- Normalisation
- Database Integrity
- Types of Relationship
- Creating Table Links
- Referential Integrity
- Advanced Forms Customising
- 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
- Optimising and Administering Access
- Optimising Performance
- The Performance Analyzer
- The Add in Manager
- Compacting Your Database
- The Database Documentor
- The Database Splitter
- Recovering Damaged Databases
- Importing and Linking Tables