michigan informatics

Designing a Table

Tables are the heart of Microsoft Access because they contain the actual data. You should spend more time planning your tables than you do actually creating them. This will save you time in the long run.

Each Access database can contain hundreds of tables. Each table contains multiple records (displayed as rows) such as a people in an address book. Each record contains multiple fields (displayed as columns) such as phone numbers and street addresses.

To design a table, make sure your tables object (1) is selected in the database window and click New (2).