 |
|
There are many excellent online courses. This has been hugely beneficial in my day to day work.
|
|
- Louise Nolan
|
|
|
|
|
ECDL Database with MS Access 2002
Course Aims
This course is designed to prepare readers for the ECDL/ICDL module 5 examination. The course will allow reader to create, edit and format a simple database consisting of tables, queries, forms and reports using Access 2002. The course follows ECDL/ICDL syllabus version 3.0. |
Assumed Knowledge
Readers should be confident users of the computer (start computer, use a mouse, keyboard and printer) and the Windows operating system (start applications and manage files and folders). Some experience of using Microsoft Excel will be advantageous. |
Course Audience
New, recent or intending users of Microsoft Access 2002 who have little or no existing database knowledge. |
|
Table of Contents
|
Getting Started with Access 2002
|
Recognise the different elements of the Access screen
|
|
Display and select items from menus and toolbars
|
|
Create a new blank database
|
|
Select a database object using the Objects Bar
|
|
Open an existing database
|
|
Get assistance using Access
|
|
|
|
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 field properties (size, format, caption, indexed)
|
|
|
|
Sorting and Filtering Data
|
Sort records by a different field
|
|
Sort records by more than one field
|
|
Filter data to see just the records you want
|
|
Use Advanced Filter options
|
|
|
|
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 records using a form
|
|
Navigate through records in a form
|
|
|
Using a Select Query
|
Understand the differences between a query and a sort or filter
|
|
Create a query using the Simple Query Wizard
|
|
Add and remove query fields in design view
|
|
Specify criteria in a query
|
|
Use calculated fields on a query
|
|
Create a query to summarise data
|
|
|
|
Using a Report
|
Print output from database objects (table, query, form or report)
|
|
Use AutoReport to generate a basic report
|
|
Design more complex reports using the Report Wizard
|
|
|
|
Customizing Forms and Reports
|
Understand the different sections of forms and reports
|
|
Change the size of a form
|
|
Add controls to a form/report using the Toolbox
|
|
Change the properties of controls
|
|
Modify the page setup on reports
|
|
Modify sorting and grouping properties of reports
|
|
|
|
|
Glossary
|
|
|
|
|
