 |
|
There are many excellent online courses. This has been hugely beneficial in my day to day work.
|
|
- Louise Nolan
|
|
|
|
|
CLAIT Level 2 - Database Solutions with Access 2002
Course Aims
This course is designed to help you to obtain the skills and knowledge required for CLAIT Level 2 Unit 3 "Databases" and Unit 11 "Database Solutions". You will learn to use Access 2002 to create a database and database reports.
You will learn to design and format tables, forms, reports, and queries. You will also be able to use calculated fields and functions to group and summarise data in queries and reports. |
Assumed Knowledge
Basic experience of using a personal computer, mouse, and keyboard to create a file and enter and edit data is required. Some previous experience of using Access will be useful but is not required. |
Course Audience
People attempting to obtain a CLAIT Plus qualification and seeking basic database design skills. |
|
This course can be found in the following categories:
|
Courses > CLAIT
|
|
Table of Contents
|
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 - Designing a Table
|
Determine data inputs and outputs for a database
|
|
Create a table in design view
|
|
Switch between design and datasheet views and different object windows
|
|
Modify basic field properties (size, format)
|
|
|
|
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
|
|
|
Access 2002 - Creating a Report
|
Create a report using the Report Wizard
|
|
Move, resize, and delete controls
|
|
Add and modify a label control
|
|
Undo and Redo design changes
|
|
|
|
Access 2002 - Summarising and Calculating Data
|
Create a query to summarise values
|
|
Add a calculated field to query output
|
|
Add a calculated field to form or report
|
|
Use the Expression Builder to create expressions
|
|
|
|
Access 2002 - Creating a Summary Report
|
Create a summary report using the Report Wizard
|
|
Add and remove group headers and footers
|
|
Modify group and detail section sort orders
|
|
Modify report section properties
|
|
|
|
Access 2002 - Modifying Controls
|
Select a single control or multiple controls
|
|
Move, resize, align, and distribute controls
|
|
Change the tab order of controls on a form
|
|
Modify control properties
|
|
Create a form/report template
|
|
|
|
Access 2002 - Importing Data
|
Import data from different sources (spreadsheet, text file, database, Outlook/Exchange Address Book)
|
|
Use Drag-and-Drop and the Clipboard to copy and paste data
|
|
|
|
Access 2002 - Modifying a Table
|
Set table field properties (size, caption, format)
|
|
Use the Hyperlink data type
|
|
Modify a table by adding and removing fields and changing field properties
|
|
|
|
|
|
