IG047F14A Microsoft Access® II Designing and Troubleshooting Databases

Microsoft Access Logo
New session starting Monday November 24th. Seats available.


You have been working with Access for at least 6 months or are responsible for working with and fixing an existing Access database.

Course Description

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



  • Considering Client/Server modes in Access
  • Rethinking your database design
  • Better
    • Tables
    • Queries
    • Forms
    • Reports


  • Table Design
  • Query Design
  • Form Design
  • Report Design
  • Importing and Linking to External Data
  • Dealing with
    • duplicate records
    • orphaned records
    • compound data in columns
    • archiving old records
  • Macros in Access – an introduction



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.

Instructional Methods

  • Hands-on labs
  • Discussion
  • Online collaboration
  • Lecture

Course Materials

  • 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.


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s