 |
|
There are many excellent online courses. This has been hugely beneficial in my day to day work.
|
|
- Louise Nolan
|
|
|
|
|
ECDL 4 Database with Access 2000
Course Aims
This course is designed to help you to obtain the skills and knowledge required for ECDL Module 5 "Database" (Syllabus 4.0). You will learn to use Access to create a relational database and database queries, forms, and 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
You should be able to use a personal computer, mouse, and keyboard to create a file and enter and edit data. Typically, you will have either basic previous experience with a computer or completed a "Using the Computer" course. |
Course Audience
Students training to obtain an ECDL or those wanting to learn to create basic database applications. |
|
Table of Contents
|
Access 2000 - 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)
|
|
|
|
Access 2000 - What is Access?
|
Recognise the different elements of the Access screen
|
|
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 2000 - 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 2000 - 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 2000 - Using a Datasheet
|
Modify the layout and formatting of a datasheet
|
|
Sort records by a single field or by 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 2000 - 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 2000 - 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 2000 - Using Criteria Expressions
|
Select records by a single criterion
|
|
Select records using multiple criteria
|
|
|
|
Access 2000 - 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 2000 - 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 2000 - Designing a Relational Database
|
Describe basic principles of relational database management systems
|
|
Split a database into relational tables using primary keys
|
|
Understand the importance of referential integrity
|
|
Design a table for a relational database
|
|
|
|
Access 2000 - Creating Table Relationships
|
Create and edit table relationships
|
|
Arrange tables in the Relationship window
|
|
Enforce referential integrity
|
|
Display related records in a subdatasheet
|
|
|
|
Access 2000 - 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
|
|
|
|
Access 2000 - Enforcing Business Rules
|
Set field properties (Default Value, Required, Allow Zero Length)
|
|
Define a custom input mask
|
|
Use the Input Mask Wizard
|
|
Set field and table level validation
|
|
|
|
Access 2000 - 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 2000 - Joining Tables with Queries
|
Create and modify a multi-table select query
|
|
Specify join properties for relationships
|
|
Understand the effect of join types in a query
|
|
Use self joins and cross joins
|
|
|
|
|
|
