Expert answer:Access Assignment Duong Exploring
Solved by verified expert:i attached all the needed files below. The Access file is where to do the work. Please use my file to do the work.
duong_exploring_a02_grader_a1.zip
ex16_ac_ch02_grader_cap_as_instructions.docx
exploring_a02_grader_a1_zoo.xlsx
Unformatted Attachment Preview
Office 2016 – myitlab:grader – Instructions
Exploring – Access Chapter 2: Assessment Project 1
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
Points
Possible
Instructions
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
Add the following fields and set their field properties as shown:
3
4
5
Field Name
Data Type
Field Size Property
Caption
ExhibitName
Short Text
15
Exhibit Name
Acres
Number
Integer
(none)
InitialCost
Currency
(no change)
Initial Cost
YearlyCost
Currency
(no change)
Yearly Cost
DateOpened
Date/Time
(no change)
Date Opened
Show
Yes/No
(no change)
(none)
Switch to Datasheet view and save the table. Add the following records, letting Access assign
the Exhibit ID:
Exhibit Name
Asia
Africa
The Americas
Acres
2
4
3
Initial Cost
2000000
3500000
1500000
Yearly Cost
300000
500000
250000
Date Opened Show
1/15/2011 Yes
2/3/2014
Yes
5/15/2005 No
Close the table.
Import the downloaded exploring_a02_grader_a1_Zoo.xlsx workbook as a new table in the
current database. Using the Import Spreadsheet Wizard, specify that the first row contains
column headings, set the AnimalID field to be indexed with no duplicates, and set the
AnimalID field as the primary key. Import the table with the name Animals and do not save
the import steps.
12
9
10
6
View the Animals table in Design view, and change the field size for the AnimalID field to Long
Integer. Change the field sizes for the ExhibitID and TrainerID fields to Long Integer. Save the
table. Click Yes in the dialog box indicating that some data may be lost. Close the table.
6
7
Begin establishing relationships in the database by adding the Animals, Exhibits, and Trainers
tables to the Relationships window. Close the Show Table dialog box. Resize the field lists so
that all fields display. Create a one-to-many relationship between the ExhibitID field in the
Exhibits table and the ExhibitID field in the Animals table, enforcing Referential Integrity.
Select the option to cascade update the related fields.
8
Updated: 04/06/2016
1
EX16_AC_CH02_GRADER_CAP_AS_Instructions.docx
Office 2016 – myitlab:grader – Instructions
Step
Exploring – Access Chapter 2: Assessment Project 1
Points
Possible
Instructions
8
Create a one-to-many relationship between the TrainerID field in the Trainers table and the
TrainerID field in the Animals table, enforcing Referential Integrity. Select the option to
cascade update the related fields. Save and close the Relationships window.
8
9
Create a query using the Simple Query Wizard. From the Animals table, add the AnimalID,
AnimalType, and DateOfLastCheckup fields (in that order). Ensure the query is a Detail query.
Name the query Checkup List and finish the wizard.
10
10
View the query in Design view, and then set the criteria for the DateOfLastCheckup field so
that only animals whose last checkup was before 1/1/2019 are displayed.
5
11
Sort the query in ascending order by the DateOfLastCheckup field. Save the query. Run the
query, and then close the query.
5
Create a new query in Design view. Add the Animals, Exhibits, and Trainers tables to the
query design window. Add the following fields to the query (in this order):
12
AnimalType
Origin
ExhibitName
FirstName
LastName
Position
9
13
Set Africa as the criteria for the ExhibitName field and sort the query in ascending order by
Origin. Run the query, and save the query as African Exhibit. Close the query.
6
14
Copy the African Exhibit query in the Navigation pane and paste it with the name Asian
Exhibit. Modify the query in Design view to replace Africa with Asia. Run the query, save the
query, and close the query.
6
15
Close the database and exit Access. Submit the database as directed.
0
Total Points
Updated: 04/06/2016
2
100
EX16_AC_CH02_GRADER_CAP_AS_Instructions.docx
AnimalID AnimalType
1 Emerald Tree Boa
2 Elephant
3 Galapagos Tortoise
4 Iguana
5 Gerenuk
6 Muntjac
7 Sea Otter
8 Water Monitor
9 Clouded Leopard
10 Bengal Tiger
11 Black Rhinoceros
12 Gorilla
13 Zebra
14 Ostrich
15 Giraffe
16 Komodo Dragon
17 Cuban Crocodile
Weight Diet
Mice, birds
10000 Plant parts, grass
400 Vegetation
2 Rodents, birds, insects
80 Leaves, fruits, flowers
50 Leaves, grass, fruit
Mollusks, Sea Urchins
5 Small animals, birds
50 Small animals
450 Animals, fish, fowl
2500 Plants
300 Leaves, plant parts, fruit
600 Plants
200 Alfalfa
4000 Leaves, stems
200 Deer, Boar
300 Fish, small animals
Origin
South America
Africa
Galapagos Islands
Central America
Africa
India, China
North Pacific Ocean
Southern Asia
Southeast Asia
India
Africa
Central Africa
South Africa
Africa
West Africa
Indonesia
Cuba
Endangered
NO
NO
YES
NO
NO
YES
NO
NO
NO
YES
YES
NO
NO
NO
YES
YES
YES
ExhibitID DateOfLastCheckup TrainerID
3
1
2/1/2019
2
3
6/9/2019
3
5
10/8/2018
3
4
9/1/2018
2
2
2/11/2019
1
1
6/9/2018
1
1
8/14/2019
1
3
2/1/2019
1
2
9/17/2018
1
4
12/1/2018
2
4
10/17/2019
2
5
5/4/2018
2
3
7/28/2019
2
2
10/25/2018
2
4
2/1/2019
1
1
5/9/2018
3
3
5/12/2019
…
Purchase answer to see full
attachment
How it works
- Paste your instructions in the instructions box. You can also attach an instructions file
- Select the writer category, deadline, education level and review the instructions
- Make a payment for the order to be assignment to a writer
- Download the paper after the writer uploads it
Will the writer plagiarize my essay?
You will get a plagiarism-free paper and you can get an originality report upon request.
Is this service safe?
All the personal information is confidential and we have 100% safe payment methods. We also guarantee good grades