October 9th, 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 or sessions scheduled. 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 or sessions scheduled. 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 or sessions scheduled. Inquire via phone (02) 6041 2711 or use our Contact Us page.
Recent Reviews – Access Courses
There are no reviews yet. Be the first one to write one.
