Learn how to read, manipulate, and create Access 2003 database tables in this free lesson.
Let's imagine that you're going to start your own home business. You will need to prepare a database for your business, and the first step is to design a table that will contain a list of contacts who may one day be your clients or suppliers.
Let's assume that a database table called Business Contacts contains all of the fields listed in the first column of the following chart. The chart also contains four other columns:
Practice designing fields by filling out the following table.
|Text, Numbers, or Both?||Field Size||Required Entry?||Allow Duplicates?|