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, I’m changing the width of the Start Date column.