Duration

2 days

Aim

The skills and knowledge acquired in Microsoft Access 2003 Level One and Two are sufficient to be able to use and operate the software at a very efficient level. Starting with the design of a database through to the execution of a fully functioning database. Exploring, designing and creating Tables, Queries, Forms, Reports, Macros and Modules.

Target Audience

Microsoft Access 2003 Level One and Two is designed for users who have no experience or have had no formal training within Microsoft Access 2003 class.

Prerequisites

Microsoft Access 2003 Level One and Two assumes little or no knowledge of the software. However, it would be beneficial to have a general understanding of personal computers and the Windows operating system environment.

Course Content

• Access 2003 Orientation
• Database Theory
• Database Design
• Creating a New Database
• Managing Table Data
• Calculated Fields
• Formatting Table Data
• Sorting & Filtering Table Data
• Setting Table Relationships
• Table & Query Relationships
• Creating Relational Databases
• Adding Relational Records
• Relational Queries
• Relational Select Queries
• Select Queries
• Action Queries
• Crosstab Queries
• Aggregate Queries
• Parameter Queries
• Forms
• Working With Forms
• Creating A Form In Design View
• Reports
• Working With Reports
• Printing In Access
• Exporting Records
• Exporting To HTML
• Calculated Reports
• Importing Records
• Working With Records
• Data Validation
• Creating Forms
• Creating Reports
• Charting
• Using The Switchboard
• Database Security
• Macro Basics
• Macro Techniques
• Macros On Forms
• Option Groups And Macros
• VBA Introduction
• Splitting A Database
• Database Replication
• Data Access Page Techniques
• Data Access Pages
• Database Protection
• Display Controls

Course Objectives

At the completion of Microsoft Access 2003 Level One and Two you should be able to:

• start and exit from Access and understand what a database object is
• understand some elementary database theory.
• design relational databases
• design and create a new database file in Access
• make changes to data in a table
• add calculated fields to queries
• format data in tables
• sort and filter data in a table
• set table relationships in a database
• understand table and query relationships and how they affect the integrity of your data
• create relational databases
• add records to a relational database
• create simple queries using more than one table
• create select queries for a relational database
• create and use queries to locate and display data
• create action queries to make tables, and update, append, and delete records
• create a Crosstab query to analyse data in a table or query
• create aggregated queries
• add parameters to queries to capture criteria data
• create a form for data entry or data viewing in Access
• work with forms
• create a form using Design View
• create reports in Access
• create, modify, and save reports
• preview and print a range of objects
• export records from Access
• export records to HTML for use on the Web
• produce reports with calculations
• import data into an Access table from a variety of sources
• work with records in a relational database
• use a range of data validation techniques to protect data integrity
• create forms using the Form Wizard
• create reports using the Report Wizard
• create a chart on a form
• use the Switchboard Manager to create a menu system
• completely secure a database file and its objects so that unauthorised access is prevented
• create simple macros
• use conditions in macros
• create macros that used with forms
• create a macro for an option group to provide instant filtering
• write a simple procedure in VBA
• split the tables from a database file
• create and maintain multiple copies of a database file
• create data access pages using the Design View
• create a data access page
• protect your database files against unauthorised access
• create sophisticated forms with tab controls and sub-form

Course Outline