Defining the requirements
- Eliciting user needs and wants
- Consolidating a design into a system specification
- Designing the data model
Creating an Access database system
- Selecting the best Access design style
- Access tables, fields, indexes
- Assigning proper field types
- Table relationships
- Modifying field functionality with properties
Integrating internal and external data
- Customising forms with the Layout View
- Embedding forms
- Importing existing tables
- Protecting data using layered validation
- Picking controls in Layout and Design Views