Create a New Table in Datasheet Project

New Table in Datasheet Project
New Table in Datasheet Project



  1. Create a new table in Datasheet View with the following options:
    1. Rename the default primary key ID field State and change the data type to Short Text. (Hint: State should remain the primary key.)
    1. Change the field size of the State field to 2.
    1. Add a new field with the name StateName and the Short Text data type.

Save the table with the name States, but do not close it.

Table 1: States table

State StateName
ID Idaho
OR Oregon
WA Washington
WY Wyoming

Save the changes to the Advertiser table, and then close the table.

Save the query with the name Advertiser Query (which is the default name) and close it, if necessary.

  1. Create a simple form for the Advertiser table. Save the form as Advertiser Form, and then close the form. (Hint: Use the Form button to create this form.)
  2. Open the AdRep Update Form in Form View and navigate to the third record, which has the AdRepNumber field value of KS02. Change the Address field value for this record to 90 Mesa Verde St., and then close the AdRep Update Form.
  3. Create a simple report based on the Advertiser table. Save the report as Advertiser Report, and then close the report.
  4. Open the Idaho Wyoming Billboard Circulation report in Layout View, and then modify the report to match Figure 1 on the next page by following these directions:
    1. Delete the Type and Facing columns.
    1. Change the column heading for the BbrdID column and the DEC column to the headings shown in Figure 1.
    1. Sum the values in the DEC column. If necessary, expand the size of the total control so it displays completely.
    1. Change the report title from “Idaho Wyoming Billboards” to Idaho Wyoming Billboard Circulation. (Hint: Do not type the period.)

(Hint: Your report may display a different date and time than what is shown in Figure 1.)

Save and close any open objects in your database. Compact and repair your database, close it, and then exit Access. Follow the directions on the SAM website to submit your completed project.

Create a New Table in Datasheet Project

  • Order

  • Payment

  • Processing

  • Delivery

Validation error occured. Please enter the fields and submit it again.
Thank You ! Your email has been delivered.