ACCESS Introduction
Learning Outcomes: Course Outline Access Introduction (1 day)
At the completion of this course participants will be able to:
- Understand how Access is used and how to navigate around it
- Design a database with lookup tables
- Create a database structure using Access
- Modify the structure of an existing table
- Add records to a new table
- Add transactional records to a lookup database
- Work with the records in a database table
- Sort and filter records in a table
- Create simple and effective queries
- Create meaningful reports from tables
- create and use a variety of forms
-
ACCESS INTERMEDIATE
Learning Outcomes: Course Outline: Access Intermediate (1 day)
At the completion of this course participants will be able to:
- Use various data validation features in Access to protect data
- Format the data in a table
- Perform more advanced queries using a variety of querying techniques
- Create and use parameter queries
- Create calculated queries
- Modify and adapt an existing form according to specific needs
- Create and use macros in Access
- Work with a number of macro techniques
- Create macros on forms
.
ACCESS advanced
Learning Outcomes: Course Outline:Access Advanced (1 day)
At the completion of this course participants will be able to:
- Design a relational database project
- Create a relational database file with multiple tables
- Set table relationships and join tables together
- Create queries based on one or more tables
- Create and work with aggregation queries
- Create and use a series of action queries
- Work with a number of macro techniques
- Create some simple programming code using VBA