The software developers who created Access realize that often people create substantially the same contents for their database. Access
provides a couple of ways to automate database building: one way is by using database templates (which were covered in a sidebar in an earlier
module). The other way is to use the Table Wizard
Rather than building an entire database for you (as a template does), the Table Wizard enables you to quickly create a table with all the
fields properly defined. Of course, once Access has made the table, you can use all the skills you will learn in this module to edit it so
that it meets your individual requirements.
The Table Wizard will notcreate every table that you need, but it does have options for many of the more common tables that people create in
both business and personal databases.
Ready to try creating a table with the Table Wizard? This Simulation leads you through the process.
Create new Table with Wizard
The data in this table fits neatly into the column width supplied by Access. This is not always the case. The easiest way to change column
width is to double-click the right side of the column header. Here, Im changing the width of the Start Date column.
Click the Exercise link below to create a table using the table wizard.
Creating New Table with Wizard - Exercise
In the next lesson you will be introduced to the datasheet.