Access 2007 Level 2

Course Overview

This course is aimed at those who have used access from a self-taught basis or have been on the level one course, but now need to know about the more detailed aspects of access. This course will develop further the advantages of multiple table relational databases.

Prerequisites

• This course assumes knowledge of how to create a table, a form based on a table, a simple query and a report using the wizard.
• Delegates should have created a simple one-table database as a minimum, although some knowledge of relationships would be an advantage.
• Attendance on Access 2007 Level 1 is not a requirement but is recommended.

Objectives

Delegates will be able to :

• Identify the many different ways of extracting information from the database, using the variety of queries available.
• Understand the principles around database design and why it is important to plan and prepare a database before entering any information.
• Create forms and reports without having to rely on the wizards.
• Use queries not only to select requisite information from the database but also to make en masse changes to the data.

Follow on Courses

• Access 2007 Level 3

Training Options

• Bespoke course (a course written to your specific needs) at your company office throughout the UK, at our training venue or at an independent location, convenient to you
• Private course at your company office throughout the UK, at our training room or at an independent location, convenient to you
• Scheduled public course at one of our training venues

Whats Included

• 12 Months telephone and email support
• Comprehensive colour course manual and exercises
• Use of a Modern Training suite with 19 inch flat screen monitors
• 1 delegate per computer
• Lunch (When at our training venue)
• Refreshments (When at our training venue)
• Relaxed refreshment area at our training room

Course Content
Database theory

• Database normalisation: Designing tables in an efficient manner to avoid data replication, and ensure good database design
• What is a relational database?
• The benefits of multiple tables

Tables

• Importing data from Excel, Access and text files
• Converting an Access 2007 database to a previous version
• Customising input masks using the input mask character code
• Using lookups when designing fields in a table
• Formatting using format codes
• Helping ensure consistent data entry
• Indexes, speeding up a database (pros and cons)
• Multiple primary keys, setting more than one field as a primary key
• Relationships between tables
• Adding and deleting a relationship
• Printing a relationship

Queries

• Using more than one table to feed a query
• Selecting all fields
• Changing the join type of a relationship between tables of a query
• Parameter queries - supplying the criteria for a query when running a query
• Cross tab query
• Displaying data in a tabular summary format

Action queries

• Make Table query: Making a table from the results of a query
• Update query: Updating values in a table using a query
• Append query: Adding the results of a query to a table
• Delete query: Deleting all the records in a table that are displayed by the query

Forms

• Creating and modifying forms without the wizard
• Tab order: Changing the order boxes are selected when the tab key is pressed
• Adding information into the form header and footer area
• Adding text i.e. Labels and text boxes
• The Form toolbox
• Adding drop list boxes and list boxes
• Adding option boxes and yes/no boxes
• Adding pictures and charts
• Adding buttons using the wizard
• Adding a close button or a next record button

Sub forms

• Displaying related information on one screen using sub forms
• Creating a sub form and inserting it into a main form
• Using tabs to group information and sub forms
• Using the property sheet to change the properties of a form
• Changing the format properties

Reports

• Creating reports from scratch
• Modifying the display properties of a form
• Grouping information together on a report e.g. Grouping sales data by company
• Adding new fields to carry out calculations on a report
• Creating sub reports
• Inserting sub reports into main (parent) reports