 |
|
There are many excellent online courses. This has been hugely beneficial in my day to day work.
|
|
- Louise Nolan
|
|
|
|
|
CLAIT Level 1 - Databases with Access 2002
Course Aims
This course is designed to help you to obtain the skills and knowledge required for CLAIT Level 1 Unit 5 "Databases". You will learn to use Access 2002 to add and edit database records, select records using a query, and to print simple reports. |
Assumed Knowledge
You should be able to use a personal computer, mouse, and keyboard to create a file and enter and edit data. Typically you will either have basic previous experience with a computer or completed a "Using the Computer" course. |
Course Audience
People pursuing the CLAIT qualification and seeking basic skills in data entry and database use. |
|
This course can be found in the following categories:
|
Courses > CLAIT
|
|
Table of Contents
|
Access 2002 - Basic Database Concepts
|
Understand what a database is
|
|
Recognise the advantages of using a computer database
|
|
Know the function of the main database objects (table, query, form, report)
|
|
|
|
Office 2002 - Getting Started
|
Start an Office application
|
|
Recognise the different elements of an Office application window
|
|
Display and select commands
|
|
Use the keyboard to select commands
|
|
Close an Office application
|
|
|
|
Access 2002 - What is Access?
|
Create a new blank database
|
|
Select a database object using the Objects Bar
|
|
Open and close an existing database
|
|
Log on to an existing database
|
|
Make a backup copy of a database file
|
|
|
|
Access 2002 - Adding and Editing Records
|
Enter records using a datasheet
|
|
Undo changes to a field or record
|
|
Navigate through records in a datasheet
|
|
Check spelling in a datasheet
|
|
Delete records from a table
|
|
|
|
Access 2002 - Using a Datasheet
|
Modify the layout and formatting of a datasheet
|
|
Sort records by a single or more than one field
|
|
Apply and remove a filter
|
|
Use Filter by Selection or Filter by Form
|
|
Use basic operators to construct simple criteria expressions
|
|
|
Access 2002 - Using a Form
|
Understand the differences between a form and a datasheet
|
|
Use AutoForm to generate a simple form
|
|
Create a form with the Form Wizard
|
|
Enter and edit records using a form
|
|
Navigate through records in a form
|
|
Add, delete, and modify records using a form
|
|
Find, sort, and filter records using a form
|
|
Add a label to a form header or footer
|
|
|
|
Access 2002 - Using a Select Query
|
Understand the differences between a query and a sort or filter
|
|
Create a query using the Simple Query Wizard
|
|
Add, remove, and hide query fields
|
|
Run, save, close, open, and delete a query
|
|
|
|
Access 2002 - Using Criteria Expressions
|
Select records by a single criterion
|
|
Select records using multiple criteria
|
|
|
|
Access 2002 - Using a Report
|
Preview output from an object
|
|
Print output from database objects (table, query, form, or report)
|
|
Use AutoReport to generate a basic report
|
|
Save, close, open, and delete a report
|
|
Change the Page Setup of database objects
|
|
|
|
|
|
