Microsoft Access : Chapter 1 : Overview


Chapter Overview: This should contain an overview or summary of the contents of this chapter. It may include selected PowerPoint slides and other narrative that describe the learning objectives and topics.


 

Objective

Description

Objective 1: Table Design


 

Table Wizard

The table wizard guides beginning users in a step by step process of setting up tables.

The table wizard offers an array of field names and tables to choose from.

Manually Setting Up a Table

The choice of a data type for a field defines the kind of value that can be inserted into a field.

 

Objective 2: Form Properties

 

View Properties of Individual Operations and Entire Report

Toggle sizes, select default view, etc.

 

 

Objective 3: Using Primary Keys

 

 

 


 

 

 

A Primary key uniquely defines individual records in a table.  It is marked by a key shape to the left of the name.

Objective 4: Using Different Views

 

Data Sheet View:

This is the standard view when observing tables, queries, forms, and reports.  Information can be manually edited in this view.

 

Design View:

Tables and forms are created using this view.  A ruler (seen to the left) is used to enable one to line up and justify boxes.  Also, the background base can be expanded.

 

Microsoft Access : Chapter 1 : Overview