Tables and Forms: Design, Properties, Views, and Wizards

1
Exploring Microsoft Access

• Chapter 2
• Tables and Forms Design, Properties, Views, and
  Wizards
• By
• Robert T. Grauer
• Maryann Barber

2
Objectives (1 of 2)

• Describe table design
• Describe data types and properties set a primary
  key
• Use Table Wizard add and delete fields
• Discuss data validation importance

3
Objectives (2 of 2)

• Use Form Wizard
• Distinguish between bound, unbound, and
  calculated controls
• Modify an existing form
• Switch between Form view, Design view, Datasheet
  view, PivotTable view and PivotChart view

4
Overview

• Basic principles of table and form design
• Design guidelines
• Design in Access
• UsingForm Wizard

5
Table Design Basics

• Include necessary data
• Store data in its smallest parts
• Avoid calculated fields

6
Creating a Table

• Table Wizard is easiest
• Designing a table yourself
• Field names
• Data types
• Primary key
• Views Datasheet or Design
• Properties

7
Data Types

• Number field
• Text field
• Memo field
• Date/Time field
• Currency field

• Yes/No field
• OLE field
• AutoNumber
• Hyperlink field

8
New Table Screen
Click on New Button
Select how to view/create new table
9
Table Wizard Screen
Includes All Fields

Removes Selected Field
10
Table Design View
Primary Key
Field Names
Data Type
Field Properties
Description
11
Properties (1 of 2)

• Field size
• Format
• Input Mask
• Caption

• Default Value
• Validation Rule
• Validation Text

12
Properties (2 of 2)

• Required
• Allow Zero Length
• Indexed
• Unicode Compression
• IME Mode
• IME Sentence Mode

13
Creating a Form

• Controls--objects
• Bound control has data source
• Unbound control no data source
• Calculated control expression as data source
• Properties
• Form Wizard

14
Form Design View
Click and drag to move Toolbox
Sizing handles
15
Form View
16
Chapter 2 Summary

• Information depends on underlying data
• Database design is critical
• Table Wizard creates tables easily

17
Chapter 2 Summary Continued

• Form provides easy way to enter and display data
• Form consists of objects called controls
• Property is a characteristic or attribute of an
  object