If you are looking for Microsoft Access classes that go beyond the basics, BOTI’s two-day Microsoft Access Advanced course teaches advanced queries, data import and export, database maintenance, and better forms and reports. It is part of BOTI’s range of Microsoft Office and computer skills training courses. You can take it in-house, at BOTI’s venue in Johannesburg or live online.
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 Advanced Training Course
This course builds on Microsoft Office Access basic and intermediate knowledge. It covers the more advanced features of Access: writing advanced queries, changing existing data in bulk, maintaining a database, and improving reports and forms so that other people can use the database with confidence.
The course suits people who already build or look after an Access database at work and now need it to do more. That might mean pulling answers out of thousands of records, bringing data in from other systems, or giving colleagues a simple front end that protects the data underneath.
Outline: Microsoft Access Advanced Training Course
Training runs in-house at your premises, at BOTI’s venue in Sunningdale, Johannesburg, or live online.
Key outcomes of the course include:
- Data export and import
- Making your database more user-friendly
- Managing a project database
- Access customisation
- Writing advanced queries and manipulating existing data
- Maintaining a database and enhancing reports and forms
What advanced Microsoft Access skills look like at work
Most people learn Access by building a few tables and a simple form. The advanced level is about making the database reliable, fast and easy for others to use. In practice, it usually involves the skills below.
Advanced queries
Select queries answer simple questions. Advanced users also work with other types of query:
- Parameter queries ask the user for a value, such as a date range or region.
- Crosstab queries summarise data in a grid, much like a pivot table.
- Action queries update, append, delete or create records in one step.
Action queries save hours of manual editing. They also need care, because they change data permanently.
Importing and exporting data
Data seldom starts or ends in Access. Typical tasks include importing spreadsheets and text files, linking to tables held elsewhere, and exporting results to Excel or other formats for reporting. Getting data types and field mapping right at this stage prevents errors later.
User-friendly forms and reports
A well-designed form guides the user, checks entries and hides the tables underneath. Subforms, combo boxes, command buttons and a navigation or start-up form make a database feel like a simple application. Reports can be grouped, totalled and formatted so that managers get the information without opening a table.
Maintenance and customisation
As a database grows, it needs regular care:
- Compacting and repairing the file.
- Checking relationships and referential integrity.
- Backing up.
- Splitting the database into a back end (data) and a front end (forms and reports) when several people share it.
Customising the interface and automating routine steps with macros helps the database fit the way your team works.
Because each organisation uses Access differently, ask BOTI to confirm the detailed outline and to tailor examples to your own data when the course runs in-house.
Course duration and format: Microsoft Access Advanced Training Course
This is a two-day course. Delegates apply what they learn in practical exercises, so they can improve the databases they use at work straight away.
Contact BOTI for a quote, or request a quote online.
Recommended Prior Experience and Knowledge: Microsoft Access Advanced Training Course
The Microsoft Access Advanced Training Course is designed for delegates whose jobs include general database maintenance and creating reports, queries and forms.
Before you attend, you should have training or experience equivalent to Microsoft Office Access basic and intermediate level.
Choosing the right Microsoft Access class level
Choosing the right level saves time and keeps a group working at the same pace.
- New to Access? Start with Microsoft Access Beginners. It covers tables, simple queries, forms and reports.
- Comfortable with the basics? Read our overview of Microsoft Access intermediate training to check that you are ready for advanced work.
- Building or maintaining databases for others? The advanced course is the right fit.
If your work also involves spreadsheets or larger databases, these related BOTI courses may help:
- Writing Excel Macros with VBA
- Getting Started with Microsoft SQL Server: SQL Querying
- Mastering Data and Records Management
See the related public courses below.
Frequently asked questions
What do Microsoft Access classes at advanced level cover?
BOTI’s Microsoft Access Advanced course covers advanced queries, manipulating existing data, data import and export, maintaining a database, making a database more user-friendly, managing a project database, Access customisation, and enhancing reports and forms.
Do I need to know the basics of Access before the advanced course?
Yes. You should have training or experience equivalent to Microsoft Office Access basic and intermediate level. If you are new to Access, start with the Microsoft Access Beginners course.
How long is the Microsoft Access advanced training?
The Microsoft Access Advanced course runs over two days, with practical exercises so that delegates can apply the skills to their own databases.
Is the Microsoft Office Access training accredited?
No. The Microsoft Access Advanced course is a professional skills programme, and delegates receive a BOTI certificate of attendance.
Can Microsoft Access training be run in-house for our team?
Yes. BOTI runs the course in-house at your premises, at its venue in Sunningdale, Johannesburg, or live online. In-house groups can ask BOTI to use examples based on their own work.
To book or get a quote, see the Microsoft Access Advanced course page. Call BOTI on 011 882 8853 or email [email protected]. Training runs in-house at your premises, at BOTI’s venue in Sunningdale, Johannesburg, or live online. 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
We also run customised courses for teams. Use the buttons below to book this course, get a proposal or browse all our courses.
Book This Course Or Obtain Quote – Now
Please Phone Us Now To Speak to One of Our Consultants
OR
FOR CELL PHONES CLICK TO CALL
Please Fill in the Enquiry Form
