An intermediate Microsoft Access course takes you past entering data. You learn to link tables with relationships, keep data accurate, and build the queries, forms and reports that turn a database into a working business tool. BOTI does not run a separate course called Access Intermediate. The closest match, and the next step after Microsoft Access Beginners, is the two-day Microsoft Access Advanced course, part of BOTI’s Microsoft Office and computer skills courses.
The current course runs at your offices anywhere in South Africa, live online or at a BOTI venue. The course page has the up-to-date outline and group prices.
See the current courseGet a quote for your teamSee all Microsoft Office and Computer Skills courses
Learning on your own? Self-paced e-learning from R595 (excl. VAT) · Ask your employer to pay
Introduction: Microsoft Access Intermediate Training Course
At intermediate level, delegates who already know their way around a Microsoft Office Access database learn to work confidently with reports, forms, queries and relationships. They also learn to customise database components and to share data with other applications, such as importing from and exporting to Excel.
Outline: Microsoft Access Intermediate Training Course
Key outcomes of intermediate Access training include:
- Maintaining data integrity
- Creating and customising forms
- Creating queries
- Creating and customising reports
Table design and data integrity
A reliable database starts with well-designed tables. At this level you set the correct data type for each field and choose a primary key. You then use validation rules, input masks and required fields to stop bad data getting in. Relationships between tables, with referential integrity switched on, prevent orphan records. An example of an orphan record is an order linked to a customer who no longer exists.
Queries
Queries answer business questions from your data. Intermediate users build select queries with criteria across related tables, add calculated fields and use totals to group and summarise. Parameter queries prompt the user for a value, such as a date range or a region. Action queries update, append or delete records in bulk, and you learn when to use them with care.
Forms
Forms make data capture faster and safer for colleagues who should not work directly in tables. You learn to design forms in Layout and Design view and to add combo boxes and list boxes that limit choices. You also use subforms to show related records, for example a customer with all their orders.
Reports
Reports present data for managers and clients. You learn to group and sort records, add totals and subtotals, format reports for printing or PDF, and base a report on a query so that it always shows current figures.
Working with other applications
Access rarely works alone. Intermediate users import data from Excel and text files, link to external tables and export query results to Excel for further analysis. Many teams pair Access with Excel skills such as Excel Pivot Tables, Dashboards and Power Pivot.
Course duration
The training runs over two days and is practical throughout. Delegates apply each skill to realistic business data so that they can use it at work straight away. For a team booking, you can request a quote or contact BOTI.
Recommended Prior Experience and Knowledge: Microsoft Access Intermediate Training Course
This training is designed for delegates who want to operate Microsoft Office Access at an intermediate level.
It is advisable to have knowledge equivalent to BOTI’s Microsoft Access Beginners course. This means you can open a database, find your way around tables, enter and edit records, and run a simple query. If you are new to computers, start with Introduction to Computers and Microsoft Office Basics.
Who should attend
- Administrators and coordinators who keep client, stock, asset or training records in Access
- Staff who have inherited an Access database and need to maintain or extend it
- Analysts who outgrow Excel lists and need related tables and repeatable reports
- Team leaders who need reliable reports from data their team captures
Choosing the right Access level
If you have never built a database, start with Microsoft Access Beginners (1 day). If you can already create tables and simple queries and now need relationships, stronger queries, data-entry forms and grouped reports, Microsoft Access Advanced (2 days) is the closest match. If your organisation is moving its data to a server database, Getting Started with Microsoft SQL Server: SQL Querying builds on the query skills you use in Access. Ask BOTI to help you assess your team’s current level before you book.
Upcoming Public Courses
Please click on a link below for related public courses:
Frequently asked questions
What does an intermediate Microsoft Access course cover?
Intermediate Access covers table relationships and data integrity, select, parameter and action queries, data-entry forms with combo boxes and subforms, grouped reports with totals, and importing and exporting data with Excel.
Does BOTI run a Microsoft Access Intermediate course?
BOTI does not run a separate course called Access Intermediate. The closest match is Microsoft Access Advanced, a two-day course that follows Microsoft Access Beginners.
Do I need to do an Access beginners course first?
It is advisable. You should be able to open a database, work in tables, enter and edit records and run a simple query. If you cannot yet do this, start with Microsoft Access Beginners.
Where can I write A+ certification in Gauteng?
BOTI does not run CompTIA A+ training or exam sessions. BOTI’s computer training focuses on workplace software skills such as Microsoft Access, Excel, Word and Outlook, from Introduction to Computers through to advanced levels.
Can Microsoft Access training run online or at our offices?
Yes. BOTI runs Access training in-house at your premises, at BOTI’s venue in Sunningdale, Johannesburg, or live online.
To build intermediate and higher Access skills, book Microsoft Access Advanced (2 days). Training runs in-house at your premises, at BOTI’s venue in Sunningdale, Johannesburg, or live online. Call BOTI on 011 882 8853 or email [email protected]. This course is not accredited. It is delivered as a professional skills programme, and delegates receive a BOTI certificate of attendance.
Book Now or Obtain a Quote
BOTI also runs this training in-house for teams. Use the button below to book the course or obtain a quote:
Book This Course Or Obtain Quote – Now
OR
FOR CELL PHONES CLICK TO CALL
Please Fill in the Form
