Start access. open the downloaded access file named exploring_a02_grader_a1.

 · Start Access. Open the downloaded Access file named exploring_a02_grader_a1. 0. 2. Create a new table in Design view. Add the field name ExhibitID with the AutoNumber Data Type. Add the caption Exhibit ID. Set the ExhibitID field as the Primary . Step Instructions Point Value 1 Start Access. Open the downloaded Access file named exploring_a02_grader_a1. 0 2 Create a new table in Design view. Add the field name ExhibitID with the AutoNumber Data Type. Add the caption Exhibit ID. Set the ExhibitID field as the primary key for the table. Save the table using the name Exhibits. 6 3 Add the following. 1Start Access. Open the downloaded Access file named exploring_a02_grader_hCreate a new table in Datasheet view using the name Donations. Switch to Design View and change ID to DonationID. Add the following field names to the table: DonorID, PlantID, DonationDate, and DonationAmount (in that order)Change the Data Type for the DonorID and PlantID fields to Number. Change the Data Type.

1. Start Access. Open the downloaded Access file named exploring_a02_grader_a1. 0. 2. Create a new table in Design view. Add the field name ExhibitID with the AutoNumber Data Type. Add the caption Exhibit ID. Set the ExhibitID field as the Primary Key for the table. 1 Start Access. Open the downloaded Access file named exploring_a02_grader_a1. 0 2 Create a new table in Design view. Add the field name ExhibitID with the AutoNumber Data Type. Add the caption Exhibit ID. Set the ExhibitID field as the Primary Key for the table. Save the table using the name Exhibits. 6 3 Add [ ]. Start Access. Open the downloaded Access file named exploring_a02_grader_a1. 0. 2. Create a new table in Design view. Add the field name ExhibitID with the AutoNumber Data Type. Add the caption Exhibit ID. Set the ExhibitID field as the primary key for the table. Save the table using the name Exhibits. 6. 3.

Firstly, you should install Microsoft Access Database Engine. Entities. If the navigation pane isn't already open, you can click the sideway arrows to open the pane. For the version and later, the extension is. Click the Microsoft Office Button, and then click Open. Open the file named exploring_a05_grader_h2_Hotel. Start Access. Open the downloaded Access file named exploring_a01_grader_a1. Close the table. Open the Customers form in Form view. Use Search to locate the record for Baker Auto Supply. Modify the record so that the Address1 field displays N.W. 7 Avenue. Save and close the form. Open the Products form in Form view. Start Access. Open the downloaded Access file named exploring_a03_Grader_h1. 2 Create a query using Query Design. From the Customers table, include the fields CompanyName, ContactName, ContactTitle, and Phone (in that order). From the Orders table, include the fields OrderID, OrderDate, and ShippedDate (in that order).