IG047 Microsoft Access® II Designing and Troubleshooting Databases

By jimubc on June 18, 2014

Microsoft Access Logo
New session starting Tuesday July 8th. Seats available.

Overview

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

Objectives

Theoretical

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

Practical

  • 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

Prerequisites

Academic

We will be relying on material covered in the prerequisite course so you must have completed the following: Access® Introduction

Practical

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.

Posted in Access, Courses | Tagged with ,