Access Essential Skills
This course is designed for new users of Microsoft Access (referred to in this course as Access).
Our aim is to provide you with the basic skills necessary to retrieve information from an existing Access database and present that data in a report.
It is important that you use your new skills as soon as possible on completion of this training course. We encourage you to take your own notes and to review this Course Guide once you are back at your workplace.
This course in conjunction with Access: Data Analysis and Reporting and Access: Creating Applications covers the material examined in the Microsoft Office Specialist Access exam.
New users of Microsoft Access who want to gain the skills to retrieve information from an existing Access database and present that data in a report.
Personal computer skills, Microsoft Windows and file handling skills. Excellent knowledge of Excel or Word fundamentals. (Excel is preferred)
Our aim is to provide you with the skills necessary to use an existing Access database. We will look at maintaining records and accessing their information to generate reports.
- Relational Databases
- The Access Window
- Navigating Data
- Entering Data
- Editing Data
- Finding Data
- Select Queries
- Parameters in Queries
- Summary Totals Queries
- Using Reports
- Access and Other Applications