| Audience | Any data base user or manager |
Prerequisites | Windows - User or equivalent |
Objectives | - Determine database normalization rules
- Create, structure, and format a database
|
Teaching method | Presentations - Demonstrations - Guided and Individual Exercises |
Contents | Chapter 1 - Establishing Relationships Between Tables - Understanding the role of relationships
- Create a relationship between two tables
- Understanding referential integrity
- Perform cascading operations
|
Chapter 2 - Creating a Database Table - Understand the basics of creating a database
- Create a table
- Set the primary key
- Change the structure of a table
- Edit field properties
|
Chapter 3 - Inserting External Data - Import data from another application or network
- Import Excel and Access data
|
Chapter 4 - Creating Simple Queries - Use the Query Wizard
- Create a simple query in design view
|
Chapter 5 – Creating Forms - Use the Form Wizard or The Instant Form
|
Chapter 6 - Creating Simple States - Use the State Creation Wizard or Instant State
|
