Business Services Organisation
Access (2019) Introduction
Access is an easy-to-use tool for creating business applications, from templates or from scratch. With its rich and intuitive design tools, Access can help you create appealing and highly functional applications in a minimal amount of time.
Learning Outcomes
- Database concepts and first steps in designing a database
- Creating tables
- Creating select queries
- Working with forms
- Working with reports
- Printing
Access (2019) Intermediate
Learning Outcomes
- Tables
- Queries
- Forms
- Reports
Access (2019) Advanced
Learning Outcomes
Queries
- Queries that perform actions
- Queries that perform calculations
- Queries displayed as crosstabs
- Explanation of the different types of query joins
Forms
- Using functions to automatically complete a form control
- Apply conditional formatting to a form control
- Add subforms to a main form
- Create a switchboard (Main menu)
- Create Macros for buttons