DT006 - Access 2003 Level 1

In this two-day instructor-led course, you will be introduced to the concept of the relational database and the Microsoft Office Access 2003 relational database application, and information management tools. Also, you will learn how to design and create a new Access database through group and individual instruction, hands-on practical exercises, visual aids, and comprehensive training manuals and materials.

After completing this course participants will be able to design and create a new Access database; improve queries, forms, and reports; and integrate Access with other applications. This course is also designed for students pursuing the Microsoft Office Specialist Certification for Access 2003.

Part 1

Microsoft Access & Viewing Databases
• Opening a Database
• The Microsoft Access Screen Layout
• The Database Window
• Closing a Database
• Storing Databases
• Displaying the Favorites List

Designing a Database
• Database Terminology
• Determining the Purpose of the Database
• Determining the Fields for a Database
• Determining the Tables Needed
• Normalisation
• Establishing Table Links
• About Primary Keys

Creating Database Files and Tables
• Creating a New Database File
• Creating a Table
• Using Columns in an Access Table
• The Table Design View
• The Table Design Toolbar
• Creating a Field in a Table
• About Field Properties
• Defining a Field Property
• Defining the Primary Key
• Creating a Table Using Datasheet View
• Naming Fields

Working with Table Properties
• Using the Field Builder
• Defining the Field Properties
• The Field Size Property
• The Format Property
• Creating a Custom Format
• Creating Custom Date Formats
• The Decimal Place Property
• The Input Mask Property
• Input Mask Structure
• The Caption Property
• The Default Value Property
• The Validation Rule and Validation Text
• Properties
• The Required Property
• The Indexed Property

Working with the Datasheet
• The Table Datasheet Toolbar
• Displaying a Table in Datasheet View
• Entering Data into a Table
• Modifying the Datasheet Layout
• Working with Fields
• Freezing and Unfreezing Fields
• Saving the Datasheet Layout

Working with Data
• Deleting Records
• Using Undo
• Searching for Data in a Table
• Finding and Replacing Data
• Sorting Records in a Table

Working with Queries
• Types of Queries
• The Query Design Toolbar
• Working with Query Results
• Creating a Query
• Viewing the Results of a Query
• Selecting Specific Records
• Entering an Expression
• Specifying Criteria for Different Field Types
• Criteria Operators
• Using Multiple Criteria
• Sorting Query Data
• Hiding Criteria Fields in the Query
• Recordset
• Using the Query Wizards

Customising Queries
• Using Wildcard Characters
• Using Wildcard Characters in Expressions
• Specifying Multiple Criteria in One Field
• Specifying Multiple ‘Or’ Criteria in a Number of Fields
• Creating Calculated Fields in Queries
• Combining Text Using Calculated Fields

Table Relationships
• Multi-Table Queries
• Creating a Simple Multi-Table Query
• Creating Relationships between Tables
• Creating Queries Based on Other Queries

Working with Forms
• Using Forms
• Viewing a Form
• About the Form View Toolbar
• Designing a Form
• Using the Form Wizard

Part 2

Customising Forms
• Working in Form Design View
• Displaying a Form in Design View
• The Form Design Toolbar
• Form Controls
• Selecting a Control
• Moving and Re- Sizing Controls
• Deleting Controls
• The Field List
• Displaying the Field List
• Adding a Field to a Form Using the Field List
• Control Properties
• Displaying the Property Sheet
• Changing the Properties
• The Formatting (Form/Report) Toolbar
• Using Autoformat

Using Controls in Forms
• The Toolbox
• Creating Calculated Controls on a Form
• Drawing Rectangles and Lines
• Using Combo Boxes in Forms
• Creating a Combo Box
• Hiding Columns
• Creating a Combo Box Using the Control Wizards

Working with Reports
• Previewing Reports
• Printing the Report
• Report Types
• Columnar Reports
• Tabular Reports
• Label Wizard
• Creating a Report Using the Report Wizards

Designing and Creating Group Reports
• The Report Design View
• The Report Design Toolbar
• Designing a Group Report
• Creating a Grouped Report
• Adding the Report Header and Footer Sections
• Adding Controls to a Report
• Placing a Label Control on a Report
• Adding a Calculated Control to a Report
• Using Summary Functions

Using Database Wizards
• What is a Database Wizard?
• Creating an Access Database Using the Wizards

Using Select Queries
• Using the Expression Builder
• About Joins
• Types of Joins
• Calculating Totals in a Query
• Creating Parameter Queries
• Returning Top Values in a Query

Using Crosstab Queries and Charts
• About Crosstab Queries and Charts
• Creating a Crosstab Query in Design View
• Using the Crosstab Query Wizard
• Creating a Chart

Using Action Queries
• Action Query Types
• Creating an Update Query
• Running an Action Query
• Creating an Append Query

This course is designed for students who wish to learn the basic and intermediate-level operations of the Microsoft Access Database program to perform their day to day responsibilities, and to understand the advantages that using a relational database program can bring to their business processes.

The first day addresses job responsibilities that include working with tables to create and maintain records, locate records, and produce reports based on the information in the database. It also provides the fundamental knowledge and techniques needed to advance to more technical Access responsibilities, such as creating and maintaining new databases and using programming techniques that enhance Access applications.

The second day addresses job responsibilities that include creating new databases, tables, and relationships, as well as working with and revising intermediate-level queries, forms, and reports. It also introduces integrating Access data with other Microsoft applications.

Attendance at an Introduction to PCs course or equivalent experience.