Microsoft Access – Introduction
Overview:
The skills and knowledge covered in this course are sufficient to be able to create database systems, enter, edit and delete data in database files, produce information in forms and reports and generate queries on the data. The course covers the following:
- Getting to know Microsoft Access
- Designing a lookup database
- Creating a lookup database
- Modifying table structure
- Adding records to a table
- Adding transactional records
- Working with records
- Sorting and filtering
- Creating queries
- Creating and using reports
- Creating and using forms
Course Details:
Target Audience:
This training is primarily designed for people who need to know how to use Microsoft Access to create databases. It is ideal for people who work in a variety of tasks and occupations where the assembly and collection of data is important.
Level:
This course covers Microsoft Access at the Introduction level.
Related Course:
Learning Outcomes:
At the completion of this courseparticipants shouldbe 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
Introduction to Microsoft Access – Introduction – Online Training
Online Training – Online Private Workshops
You can book private, customised, online training for your team. To do this, please click on the Book Online Training button on this page.
The Introduction to Microsoft Access – Introduction Online Workshops are presented by a CTO Facilitator, in a live virtual classroom.
Prices:
| Trainees | Price | |
|---|---|---|
| 1-3 trainees | $1,650 | per day |
| 4-8 trainees | $1,980 | per day |
| Each additional trainee | $154 | per day |
