Introduction Access XP-2003
Course Duration
Duration – 1 Day. Course timings 0930-1630 (approximate)
Course Aims
You will learn the basic skills necessary to create databases, tables, queries, forms and reports using Access. Additionally, you wilt team elementary skills to modify forms and reports.
Pre-requisites
No prior knowledge of Access is assumed, but some exposure to databases would be helpful. You should be able to use basic Windows features, a mouse and keyboard.
Target Audience
This course is designed for new users who wish to understand the basics of Access 2003.
Content/Topics
The Microsoft Access 2003 Introduction course will cover the following topics enabling delegates at the end of the course to be able to:
———————————————————————————————————————————————————————–
Database Concepts
Understanding Databases
Introduction to Relational Database
Getting Started
Starting Access & Opening Files
The Access Application Window
The Table Datasheet and Design Views
Introducing Queries, Forms and Reports
Views and Navigating in a Table and Form
Close a Database and Access
Database Design and Table Creation
Create a Database using a Wizard
Create a Blank Database
Create a Table using the Table Wizard
Create a Table in Datasheet View
Create a Table in Design View
Adding Fields and Data Types to a New Table
Setting a Primary Key
Introducing Field Properties and the Input Mask
Saving a Table
Database Entry & Editing Techniques
Enter Records in a Table
Selecting techniques
Editing and Deleting Records and Fields
Forms
Creating a Form Using Autoform
Enter records in a form
Formatting the datasheet
Printing the datasheet
Copying a table from the Database Window
Finding, Sorting & Filtering
Using Find and Replace
Sorting Records
Filtering Records
Queries
Opening Existing Queries
Creating Queries with the Simple Query Wizard
Creating Queries in Design View
Using criteria e.g. Text, Logical and Comparison Operators, and Multiple Criteria
Intro to Grouping & Summary queries (totaling)
Reports
Creating Reports with Auto Report Creating Reports with the Report Wizard
Creating Labels with the Label Wizard
Basic formatting and customising reports
Printing Reports