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 Access Day 2 Training Course
Our Basic Access Day 2 training course can be carried out in all versions of Microsoft.
All of our Microsoft Access training 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.
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
Course Objectives
The objective of this Microsoft Access training 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 day 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.
FAQs
Does the training cover the latest Microsoft Office 365 updates?
Yes it does. The content of our Access training courses transfers across and is compatible with any future updates of Microsoft 365. We also regularly review all of our Access 365 training courses to ensure any new features and tools are not missed out.
How is the Basic Access Day 2 training course structured?
Our Access training is split up into a 2 day course. The second day covers how to create forms and reports from a database that has been created. This builds on and complements knowledge learnt on the day 1 course. There are 2 short breaks, one mid morning and one mid afternoon, and lunch break planned in to break up the whole day course.
How do I know if this is the right level course for my Access training needs?
Day 2 is the complementary course to our day 1 Access course. You will need to have the knowledge of how to create databases from the day 1 course, before you can attend and complete this day 2 course. Day 1 is a pre-requisite for this course as you need the knowledge of how to create a database before you can create forms and reports from a database.
How can Microsoft Access training benefit my business?
Access can be the package that is the answer to a businesses problem. It is often used to create a database to hold data in it and then producing reports and forms from that data. It isn’t always a package easy to pick up with no existing training in it, so a course on it will benefit any member of staff greatly. It can strengthen confidence and ability in creating and using these databases as well as developing existing data analysis skills further, helping your business stand out in any industry.