Tailored Courses for IT and Business Professionals

MS Access 2003 Familiarisation


	The copyright on these mind maps has been protected. However we are very happy to provide unprotected versions to anyone who sends an email, stating their reason for interest.

Objectives

This course will enable Microsoft Access users to construct basic relational databases in Microsoft Access 2003.

Duration

One Day

Delegates will learn ...

How to navigate around the Microsoft Access 2003 application environment.
How to create Microsoft Access 2003 Databases
How to create Tables
How to make Tables do useful work for you
How to use Select Queries
How to create calculated values and join related data in Queries
How to create and use Microsoft Access Forms
How to create and use Microsoft Access Reports
How to copy Tables, Queries, Forms and Reports between databases
Database concepts that help to consolidate the experience gained.

Who Should Attend

This course is suitable for fairly new users to MS Access 2003 and users who have had no formal training but have been using MS Access for a few of months.

Prerequisites

No prior knowledge of Microsoft Access 2003 is required, although a good level of familiarity with standard interaction with the Windows environment is recommended.

Topics covered

Theory of Database Construction

How to construct a data model to be useful, effectient and consistent with a real-world situation
Entity-relationship modelling
Normalisation and de-normalisation
Types of Relationships between tables
The examples of the application of these principals to real scenarios either provided by delegates or course leader

Creating and Modifying Tables

Creating a table using design view
Setting primary keys
Setting field properties
Adding and deleting fields in design view
Creating indexes on fields within tables

Working with tables

Finding and replacing data
Filtering data by the currently selected item
Sorting data by alpha and numeric keys

Using Select Queries

Creating queries using the query design view
Running the query and viewing the results
Using a wildcard operator and the comparison operators
Combining conditions in queries by using an And and Or
Selecting records with null values
Including calculated values into queries

Advanced Query Techniques

Creating parameter queries
Joining tables and working with join properties
Agregating data - sum, average, and other statistical agregation functions
Crosstabs
Ways to speed up your queries
Discussion of the power of indexes to improve query efficiency and performance

Creating a Front End Form

Creating a form in design view
Adding in controls to user forms
Adding command buttons to user forms, and assigning actions to them
Customising what happens when a user opens a database
Hiding and unhiding the database window