Unsure what properties your fields should have? Let Access 2007's field list set them for you

by Mary Ann Richardson | May 08, 2007 7:00:00 AM

Tags: Microsoft Office, Databases, Mary Ann Richardson, Click New, Microsoft Access, Field List, Microsoft Office Suite Access Tips Newsletter

Takeaway: With a variety of built-in fields, Access 2007 makes it easy for you to design a table for your database. Here's how to use the intuitive features of the latest version of Access to make your job easier.

One of the most difficult things about designing a database table is setting the field properties. To make it easier, Access 2007 has already designed a number of common fields for you; you simply pick the ones you want from the field list. Follow these steps to create a table for your employee database:

1. Click the Office Button.
2. Click New.
3. In the File Name Box in the far right Blank Database column, enter Employee Database.
4. Click the Create button.
5. Click the Create tab in the ribbon.
6. Click the Table button the Table Group.
7. Click the New Field button in the Fields And Columns Group.
8. Under the Table tab, click in the box under Add New Field.
9. Scroll to and double-click Company under the Field list.
10. Click in the next Add New Field box.
11. Scroll to and double-click Last Name under the Field list.
12. Repeat steps 10 and 12 for each new field you want to add from the Field list.

Miss a tip?

Check out the Microsoft Access archive, and catch up on our most recent Access tips.

Help users increase productivity by automatically signing up for TechRepublic's free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.