Access 2003

Designed for anyone wishing to learn Access 2000 to the Microsoft Office Specialist (MOS) syllabus. The course is suitable for beginners but students are expected to have experience of using a windows operating and mouse.

The course is about 20 hours long and covers the following topics:

Lesson One – Including: Terminology used in connection with a database, loading the Microsoft Office Access program, opening an existing database, navigating around different objects in a database, using datasheet and design view, entering a new record, finding records, sorting records

Lesson Two – Including: Planning and design of a database, recognising relationships between tables, defining fields, data types and properties using design view, entering data into tables using datasheet view, re-sizing columns, using the Lookup Wizard

Lesson Three – Including: Defining relationships, using the Table Wizard to create a table, modifying the table design, using the Input Mask Wizard, using the Database Wizard to create a new database

Lesson Four – Including: Editing data in form and datasheet views, adding new records, using print preview, changing page orientation, printing a datasheet, enforcing referential integrity in a relationship, using the Form Wizard, working with controls in form design

Lesson Five – Including: Using advanced sort, using filter by form, importing a table from an external database, using a junction table to resolve a many to many relationship, adding a new field to a form, using a calculated control on a form, creating a query, using criteria to retrieve selected data, creating and naming a calculated field in a query

Lesson Six – Including: Adding a field with data validation in a table, creating a form with subform, entering data using a form/subform combination, creating and modifying the design of a report, adding a subreport to an existing report

Lesson Seven – Including: Exporting an HTML file, editing an existing web page, creating a data access page, adding a hyperlink, object dependencies, importing an Excel spreadsheet as a table, importing a comma delimited text file as a table, creating a switchboard, backing up a database

Access 2000 Proficient

Designed for anyone wishing to learn Access 2000 to the Microsoft Office Specialist (MOS) syllabus. The course is suitable for beginners but students are expected to have experience of using a windows operating and mouse.

The course is about 20 hours long and covers the following topics:

Lesson 1: Understand the following terms - table, record, field, query, form, report, common field, one-to-one relationship, one-to-many relationship, primary key and foreign key. Understand the planning and design of a database containing related tables and recognise relationships between tables. Use the Office Assistant.

Lesson 2: Define fields, data types and properties for three tables using design view. Enter data into tables using datasheet view. Set primary keys and establish relationships. Navigate records in a table. Use the Lookup Wizard to create a field that looks up data from another table and to establish a relationship. Use Find to locate specific entries. Sort records. Use the Table Wizard to create a table, modify the table design and enter data into the table. Use the Input Mask Wizard.

Lesson 3: Edit data in form and datasheet views. Add new records. Change page orientation. Enforce referential integrity in a relationship. Work with controls in form design.

Lesson 4: Import a table from an external database. Use a junction table to resolve a many to many relationship. Add a new field to a form. Use a calculated control on a form. Create a query. Use criteria to retrieve selected data. Create and name a calculated field in a query.

Lesson 5: Add a field with data validation in a table. Enter data using a Form/Subform combination. Perform summary calculations on a group of records in a Query. Create and modify the design of a Report. Save a table as a Web page. Add a hyperlink in an existing Web page.