Microsoft Office Access – supporting your business development
John worked closely with the office team at Red Hill Christian Centre… as our needs have grown and changed he has trained us to adapt this at each stage.
Read Full Testimonial
Basic Day 2 Access Training Course
Our Basic Access Day 2 training course can be carried out in the following versions: 2010, 2013, 2016 and 365.
All of our courses are full day courses, typically running from 9:30am to 4pm with two coffee breaks and a lunch break throughout to break up the course. Timings can be slightly flexible though to fit in with your needs. We can also bespoke the content alongside the first day course content to make it a 1 day course, just with less content on each of the topics. Just ask, we’d be happy to help.
Course Objectives
The objective of this course is to enable the trainee to use Forms design and to create macros and reports from an existing database. It complements the first day of our 2 basic Access day courses and is best followed on from attending that course as it will give a good all round knowledge of Access for attendees to create and use their own databases.
Key Content
The key content that is covered in the course can be found below:
- Introduction to the Form Design workplace
- Form Design without wizard
- Changing Form properties
- Adding Controls
- Adding fields from a Table
- Adding Headers/Footers
- Combo and List Boxes. Command Buttons
- Adding A Custom Control and performing data entry into the Form
- Creating Calculated Controls
- Controls to perform an Action
- Creating a Macro
- Creating a Switchboard
- Adding A Subform to a Form
- CrossTab Queries
- Creating Reports
- Exporting into Word & Excel