You have been working with Access for at least 6 months or are responsible for working with and fixing an existing Access database.
Starting with data in various forms including ASCII text files, Excel spreadsheets, and existing Access databases, you will examine typical problems that arise when dealing with data that is not appropriately formatted. You will examine advanced topics relating to table maintenance, queries, forms, reports, relationships between tables, and exports to different file types. Along the way, we will address issues and problems that are relevant to more experienced Access users (SELECT, UPDATE, DELETE, queries and Macros for more multi-step procedures).
Duration: 12 hours
Register for this course: Access® II Designing and Troubleshooting Access Databases
We will be relying on material covered in the prerequisite course so you must have completed the following: Access® Introduction
A minimum of 6 months experience with Access is highly recommended.
Lab Equipment and Devices
The sessions are conducted in a computer lab and you will have a lab computer for you to use.
You are welcome to bring your own computer to the lab sessions if you prefer to use that. Wireless access is available in the lab.
At times you will be doing a fair bit of typing and you will want to have a large enough screen and separate physical keyboard so that you can view content and type at the same time.
Lab exercises are based on using the lab computers.
If it appears that you are having challenges with your own device, we will ask you to use the lab computer.
- Hands-on labs
- Online collaboration
- Web site
- Course notes
- Printed copies of on-screen lecture notes available on request during lectures
No Recording or Pictures in the Lab
Please note: Taking pictures or video during the course sessions is not permitted. All the course materials and lecture notes are available in physical form and on the web.