• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL

Part 5. Using Access > Task 4 How to Add New Tables

Task 4 How to Add New Tables

You can create many different tables in each Access file, and each table can vary in its focus. For example, you might have one table consisting of customer data (such as names and addresses) and another table detailing your inventory (such as an item number and price). As long as you created your database using the wizard or a template, you have at least one table. For some databases, one Table is not enough. You have several ways of creating new tables. You can use the Table Wizard, you can design your own table from scratch, or you can use a default blank table and fill in your own fields. Regardless of how you create a table, all tables work the same way. Fields are listed in columns, and records are listed in rows.

  1. Select the Table Object

    To work with database tables, click the Tables object in the Objects bar of the Database window. You'll see three options for working with tables: Use the Create table in Design view option to custom-design a table. Use the Create table by using wizard option to open the Table Wizard that walks you through steps for creating a table. To create a default blank table, use the Create table by entering data option.

  2. Start a Blank Table

    To start a blank table, double-click the Create table by entering data option. This action opens a default table in Datasheet view, as shown here. To rename the fields, double-click the field label and type your own text. To fill out a record, click the first empty cell in the first column and start entering data.

  3. Use the Table Wizard

    Another way to start a table is to use the Table Wizard, which does all the design work for you. From the Database window, double-click the Create table by using wizard option. This action opens the Table Wizard, as shown here. You can view two separate table lists, Business or Personal. Select the one you want.

  4. Add Fields

    You can build your table using fields from different sample tables: just mix and match what you need from the samples. Select a table from the Sample Tables list; the Sample Fields list box displays the fields available for that table. To add a field, select the field and click the > button. When you have finished adding fields, click Next to continue.

  5. Assign a Name

    In the next wizard dialog box, type a descriptive name for the table and let the wizard determine the primary key (a field that's unique for each record in the table—typically, it's just a number, starting with 1). Click Next to continue.

  6. Create the Table

    If your database already has at least one table, the next dialog box that appears asks about the relationship between tables. Ignore this dialog box for now and click Next to open the final dialog box. Indicate whether you want to change the table design, enter data directly, or have the wizard create a data entry form for you. When you're done selecting options, click Finish.



Not a subscriber?

Start A Free Trial

  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint