Objectives

Generally To plan and design a database and to create a table with different data types and field properties in design view.

Specifically On completion of this lesson, you will be able to:

• Determine data inputs and outputs for a database
• Create a table in design view
• Use multiple data types
• Set a primary key
• Switch between design and datasheet views and different object windows
• Modify field properties (size, format, caption, indexed)