Course duration

(we will customise to your learning requirements and timeframe)

Target audience

This course is designed for those who need to devleop the skills to create a new database, design data tables, design forms and reports, and create simple queries.

Download the PDF Course Outline.

Course Objectives

At the end of the course participants will be able to:

• Understand the fundamental properties of a database
• Understand the major components of Microsoft Access
• Use the Database Wizard to create a database
• Create, edit and add data to tables
• Search for data
• Design customised forms and reports
• Create Query Tables using a variety of methods
• Understand and create Relationships between tables
• Create Applied Queries

Fundamentals

• Databases
• Tables
• Database management systems
• Starting & exiting Access
• Creating a Database
• Rules governing database filenames
• Opening an existing Database
• The Database Wizard & the table Wizard

Tables

• Designing a Table
• Fields and field data types
• Rules governing field names
• The Primary key
• Datasheet and design View
• Table design guidelines
• Entering data into a Table
• Managing Objects

Finding Data

• Finding by record number
• Finding by value
• Wildcards
• Find and replace
• Filtering records
• Filter by selection and form

Introductory Forms

• Creating a Form
• Opening an existing Form
• Filtering records

Form Design

• Form design & design View
• Mouse Modes
• Selecting, resizing and moving controls
• Grids
• Aligning and spacing controls
• Editing Labels
• Deleting Controls
• Basic design tools
• Formatting toolbar

Introductory Reports

• Creating a Report
• AutoReport
• The Report Wizard

Report Designing

• Design View
• Formatting
• Aligning Controls

Field Properties

• Field Properties and Size
• Validation Rule and Text
• LookUp Field Properties

Relationships

• Relational Databases
• Foreign Keys
• Relationship Window
• Adding Tables
• Creating One to Many Relationships
• Saving the Relationships Window Layout
• Subdatasheets
• Main/Subforms

Building Simple Queries

• Creating a Query
• Design View
• Adding Fields
• Datasheet View
• The QBE Grid
• Sorting
• Criteria
• Logical Operators
• Relational Operators

Applied Queries

• Multi-Table Queries
• Parameter Queries
• Applications in Forms and Reports
• Action, Update and Delete Query