I’m working on a Excel exercise and need support.
EX16_AC_CH02_GRADER_CAP_AS - Metropolitan Zoo
Project Description:
The Metropolitan Zoo tracks its animals in Excel. The organization decides to use a database to organize the data about the animals, their trainers, and the animal exhibits. In this project, you will open an existing database and create a new table. You will import an Excel file containing information about the animals, and query the database to determine which animals need a checkup. You will also create a query to obtain a listing of the animals in each exhibit.
Instructions:
For the purpose of grading the project you are required to perform the following tasks:
Step
Instructions
Points Possible
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 fields and set their field properties as shown: