top  Microsoft™ Access

Level 2

Principles of Table Relationships

	One-to-One Relationships
	One-to-Many Relationships
	Many-to-Many Relationships
	Referential Integrity

Table Design Techniques

	Default Values
	Validation Rules and Text
	Input Mask
	Field Properties
	Indexing Techniques

Enhancing Queries

	Types of Queries – Select, Parameter, and Summary
	Adding and Formatting Calculated Fields
	Using the Zoom Box to Edit
	Concatenating (Combining) Fields
	Selecting Unique and Top Values
	Creating Multi-Table Queries

Customizing Reports

	Modify Existing Reports
	Changing Report Control Properties
	Line Spacing and Page Breaks
	Adding Field Controls to a Report
	Adding, Deleting, Moving, and Aligning Field Controls

Enhanced Form Design

	Customizing a Form
	Adding Calculations to a Form
	Calculated Controls
	Adding Text Boxes
	Aligning Objects on the Form
	Adding a ComboBox/List Box to the Form
	Adding Graphic Images to the Form
	Changing the Tab Order
	Using Command Buttons in the Form
	Creating a Desktop Icon to Open the Main Form