September 11th, 2021
- Basics
- Intermediate
- Advanced
Access – Basics
Detailed Content
This is a 1-day hands-on, face-to-face session and participants will learn how to:
- Describe the Access screen layout.
- Plan a database.
- State meanings of database terms – primary key, fields, relational.
- Add fields to create a database.
- Create simple forms.
- Enter data to create records.
- Import data from other programs.
- Find, sort and navigate data.
- Create and format simple reports.
- Create simple queries to extract data.
- Create reports based on queries.
- Link tables together.
- Create queries to combine tables.
Flexible Options
Courses are delivered in our training rooms, or can be conducted in your training room onsite, or as live, online sessions. And content/outcomes can be customised/tailor-made to your requirements.
See Benefits to the right for a list of services provided to all participants (depending on the course).
For more details or to inquire about a closed corporate or online program, use our inquiry form here or phone us on (02) 6041 2711.
Prerequisites
No experience in using Access is required nor assumed. Participants are expected to have some knowledge of and experience with a Windows PC.
Upcoming Dates
No courses scheduled. Please inquire via phone (02) 6041 2711 or use our Contact Us page
Access – Intermediate
Detailed Content
This is a 1-day hands-on, face-to-face session and participants will learn how to:
- Revise the basics and shortcuts in using an Access database.
- Create more tables and link them.
- Use queries to combine tables.
- Create calculation queries.
- Change the design of forms and reports.
- Create forms and subforms.
- Add calculations to forms and reports.
- Format and validate data.
- Add Windows features to forms (drop downs, check boxes).
- Create a main menu system.
- Implement simple security features.
Flexible Options
Courses are delivered in our training rooms, or can be conducted in your training room onsite, or as live, online sessions. And content/outcomes can be customised/tailor-made to your requirements.
See Benefits to the right for a list of services provided to all participants (depending on the course).
For more details or to inquire about a closed corporate or online program, use our inquiry form here or phone us on (02) 6041 2711.
Prerequisites
CLASS Training’s Access Basics course or proven experience with Access.
Upcoming Dates
No courses scheduled. Please inquire via phone (02) 6041 2711 or use our Contact Us page
Access – Advanced
Detailed Content
This is a 1-day hands-on, face-to-face session and participants will learn how to:
- Create mail merges with MS Word
- Assign detailed controls to forms
- Create automatic field population controls
- Use report dialogue forms
- Apply maintenance and security measures
- Integrate databases with Web pages
- Create and format macros
- Use Visual Basic modules
- Deploy databases to users without Access
Flexible Options
Courses are delivered in our training rooms, or can be conducted in your training room onsite, or as live, online sessions. And content/outcomes can be customised/tailor-made to your requirements.
See Benefits to the right for a list of services provided to all participants (depending on the course).
For more details or to inquire about a closed corporate or online program, use our inquiry form here or phone us on (02) 6041 2711.
Prerequisites
CLASS Training’s Access Intermediate Course or proven experience with Access.
Upcoming Dates
No courses scheduled. Please inquire via phone (02) 6041 2711 or use our Contact Us page
Recent Reviews – Access Courses
I'm going to save LOTS of time now! (Access - Basics)
What impressed me most about the course was simply – that I can work it out better!
This training is as good as it gets!
I can safely say my productivity is going to jump! (Access - Basics)
Loved the interaction and hands-on learning.
What initially ‘grabbed’ me was a desire to learn more about data systems and how to utilize them. I certainly got that!
My productivity will really jump from this training! (Access - Basics)
What initially ‘grabbed’ me about this course was a desire to learn more about data systems and how to utilize them. I loved the interaction and hands-on learning very much! Thank you.
I will save so much time now ! (Access - Basics)
The one big thing I learnt was the ability Access has to do everything from tables to forms to charts thanks to the knowledge of the Trainer!
I did the CLASS Training Excel course and that was of a great quality, hence why this course grabbed my attention.
