| Class Outline |
|
 |
Information &
Technology Services
Faculty and Staff Training |
Create Tables
and Forms in Access
Tables are the fundamental structure in a Microsoft Access database.
Forms allow for easy data entry into tables. This class will show
you how to create and modify tables and forms.
Length:
2 hours |
Book:
Optional Reference Book
|
Prerequisite Class or Equivalent Knowledge:
Get to Know Your Computer
Understand the Windows Desktop
Get Started Building Databases in Access |
Course Content
Designing and Creating Tables
-
Table design
-
Creating a table in Access
-
Data Types and Field properties
-
Table relationships
Modifying Tables
- Adding a lookup field
- Adding an input mask
Customizing Forms
- Building forms in design view
- Customizing form fields
|
|
|
 |
