 |
|
There are many excellent online courses. This has been hugely beneficial in my day to day work.
|
|
- Louise Nolan
|
|
|
|
|
ECDL AM5 Advanced Database with Access 2002
Course Aims
This course is designed to help you to obtain the skills and knowledge required for ECDL AM5 "Database Advanced". You will learn to use Access 2002 to create a relational database, design queries, forms, and reports, and automate actions using macros.
You will learn how to design a relational database structure and create queries, forms, and reports based on multiple tables. You will also learn to import, export, and link data and to manipulate records using action queries. |
Assumed Knowledge
You should be able to use Access to create a database, incorporating simple tables, queries, forms, and reports. You should have mastered the objectives of ECDL Module 5 "Database" before attempting this course. |
Course Audience
Students training to obtain an Advanced ECDL or those wanting to create and maintain a relational database. |
|
Table of Contents
|
Access 2002 - Using Criteria Expressions
|
Select records by a single criterion
|
|
Select records using multiple criteria
|
|
|
|
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 - 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 - 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 2002 - Creating Table Relationships
|
Create and edit table relationships
|
|
Arrange tables in the Relationship window
|
|
Enforce referential integrity
|
|
Display related records in a subdatasheet
|
|
|
|
Access 2002 - 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
|
|
|
|
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
|
|
|
|
Access 2002 - 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 2002 - Enforcing Referential Integrity
|
Use the Find Unmatched and Find Duplicates Query Wizards
|
|
Set Cascade Update and Cascade Delete options
|
|
|
|
|
Access 2002 - Using Parameter and Crosstab Queries
|
|
Access 2002 - Exporting Data
|
Export a table or query to Excel
|
|
Export data to Word and complete a mail merge
|
|
Save data in other file formats
|
|
Export data objects to a different database
|
|
Save a table, query, or form as a web page
|
|
|
|
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 - Linking to an External Data Table
|
Create a link to data stored in a spreadsheet
|
|
Create a link to a table in another Access database
|
|
Split a database into a front-end and back-end
|
|
|
|
Access 2002 - Using an Action Query
|
Transfer data to other tables with Make Table and Append queries
|
|
Change data with an Update query
|
|
Delete data with a Delete query
|
|
|
|
Access 2002 - Designing Forms and Reports
|
Create a new form or report in design view
|
|
Understand use of different sections
|
|
Display, hide, and resize a section
|
|
Modify form/report, section, and control properties
|
|
Use the Control Wizard to add a control (list box, combo box, check box, option group)
|
|
|
|
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 - Using a Subform or Subreport
|
Use the Form/Report Wizard to create a form or report based on multiple tables
|
|
Use the Subform control and synchronise forms
|
|
Modify the layout of a subform
|
|
Use the Subreport control
|
|
|
|
Access 2002 - Designing a Macro
|
Understand what a macro is and how it works
|
|
Add a macro to an event handler
|
|
|
|
|
|
