Module 5 - Databases

Aims and Objectives
To enable students to take the ECDL Databases modular test.
Know how to use Access 2003 in order to sit the ECDL modular test.
The flexibility and value of self-study course designed to enable you to work at your own pace.
A personalised workbook to use as a reference guide on completion of the course.
The opportunity to gain the widely recognised Pitman Training Certificate.

Target Audiences
Those who wish to learn how to use this popular program to the ECDL syllabus.

Prerequisites
Knowledge of Windows and using a mouse.

Course Content
Module 1: Database Concepts: Tables, Records, Fields, Primary Keys, Field Data Types, Field Properties, Table Relationships.

Module 2: The Access Application: Starting Access, The Task Pane, The Access Menu Bar, The Access Database Toolbar, Office Asistant, Toolbars, Keybaord Shortcut Keys, Using Help, Type a Question for Help, Starting the Access Help Task Pane, Office Assistant, ScreenTips, First Step with Databases, Before you Start, Opening a Database, The Database Window, Working with Database Window, Database Objects, Viewing Objects, Changing Views, Closing the Database, Closing the Application, Creating a Database.

Module 3: Designing Tables: Main Table Operations, Creating a Table, Designing a Table, Specifying Fields and Data Types, Creating Fields, Saving a Table, Creating the Customer, Order and Supplier Tables, Other Methods of Creating a Table and Fields, Field Properties, Validation Rules, Altering Field Properties, Defining a Primary Key, Indexing Fields, Indexing a Field, Relating Tables, Types of Relationship, Adding a Relationship, Deleting a Relationship, Using Lookups to Ensure Relationships are valid.

Module 4: Table Data: Adding Data, Adding Records, Modifying Records, undoing Operations, Navigating in a Table, Navigating with the Navigation Bar, Navigating with the Keyboard, Altering Columns, Deleting Data, Deleing Values from a Field, Deleting Records, Deleting Fields in a Table, Deleting a Table, Printing Tables, Previewing a table, Print Setup Options, Printing a table, Final Exercise.

Module 5: Forms: Form Design Basics, Creating a Form Using the Form Wizard, Closing a Form, Opening a Form, Changing Form View, Modifying a Form in Design View, Saving a Form, Deleting a Form, Navigating Data in a Form, Changing Data Using a Form, Adding Records Using a Form, Changing Data Using a Form, Deleting Records Using a Form, Final Exercise.

Module 6: Retrieving Information: Searching, Searching for Data in a Table, Searching for Data in a Form, Filters, Filtering Records in a Table, Creating a Filter Using Filter by Form, Removing a Filter, Creating a Filter Using Filter by Selection, Filtering Records in a Form, Queries, Creating Query by Using Wizard, Closing a Query, Creating a Query in Design View, Saving a Query, Deleting and Moving Fields in a Query, Switching Views in a Query, Creating a Two-Table Query Using Wizard, Deleting a Query, Creating a Two-Table Query Using Design View, Running a Query, Adding Criteria to a Query, Using AND, Using OR, Showing and Hiding Columns in a Query, Sorting Records in Query Design, Sorting Records in Datasheet View.

Module 7: Reports: Creating Reports, Closing a Report, Grouping Records, Summarising, Altering Report Layout, Opening a Report in Design View, Altering Field Arrangement, Saving a report, Altering Fields, Printing Reports, Previewing a Report, Print Setup Options, Printing the Report.