Microsoft Access 2003

Unit 1. Basic elements of Access2003

Opening and closing Access2003 The initial screen The bars Intelligent menus

Unit 2. Create, open, and close a database

Basic concepts Creating a database Closing a database Opening a database More ways to open a database

Unit 3. Creating data tables

Creating a datatable The field builder Data types The lookup wizard The primary key Saving a table Closing a table

Unit 4. Modifying data tables

Modifying the design of a table Introducing and modifying data in a table Moving within a table Finding and replacing data

Unit 5. Properties of the fields

Introduction Field size Field format Customizing formats Decimal places Input mask Customizing input masks Caption Default value Validation rule Validation text Required Indexed Indexes

Unit 6. Relationships

Basic concepts on relationships Creating the first relationship Referential integrity Adding tables to the relationship window Removing tables from the relationship window Editing relationships Deleting relationships Tidying the relationship window Showing direct relationships Visualizing all the relationships