Microsoft Access 365 / 2019 / 2016 Level 2
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 some existing database design and/or user experience that may have been gained from the Microsoft Access 365 / 2019 / 2016 Level 1 course.
Prerequisites
- Microsoft Access 365 / 2019 / 2016 Level 1 or equivalent experience
Outline
- Action Queries
- Types Of Query
- The Crosstab Query
- The Make Table Query
- The Append Query
- The Delete Query
- The Update Query
- Customising Forms
- Manipulating Data in the Form
- Creating A New Form
- Using the Form Wizard
- Creating a Form With a Subform
- Modifying and Redesigning the Form
- 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
- Protecting desktop databases with backup and restore processes
- 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