Access 2000

Purpose of a database

Overview of database design

Tables

            Fields:  names, types, properties--default values, format, caption, validation rules

            Tables:  create, edit, copy, delete, import

            Define table relationships, referential integrity

Data

            Enter and edit text

            Sort, find/replace, filter/select, re-arrange columns, freeze columns

Queries

            Create, modify, sort, Boolean logic (AND/OR), calculated fields

Forms

            Create, modify, multiple object selection, easy object alignment

            Command buttons, option groups, drop-down lists, displaying pictures

            Color, format painter, control tip pop-up text, lock fields

            Tab order, invisible field, transfer a form-calculated value to a table

Reports

            Design concepts, mailing labels, create groups and group header/footer

            Group totals, report totals, sequentially number a list, count items in a list