26 Jun Need help with Microsoft Access ? For the Week 3 Microsoft Access Module 1 Lab Assignment, you will develop a?database for the gift shop at your local science museum.?Use skill
Need help with Microsoft Access
For the Week 3 Microsoft Access Module 1 Lab Assignment, you will develop a database for the gift shop at your local science museum. Use skills/techniques/concepts learned in the Microsoft Access Module 1. HINT: The finished Lab Assignment should include: 2 tables, 1 query, 1 form, and 1 report.
Problem: The Milledgeville, Georgia, science museum operates a gift shop that sells science-related products. The gift shop purchases the products from vendors that deal in science-related games, toys, and other merchandise. Currently, the information about the items and the vendors is stored in two tables. You are to create a database that will store the item and vendor information.
Perform the following tasks:
- Create a new blank database in which to store all data for the gift shop and save the database as LastnameFirstnameAccessLab1.accdb
- Import the Vendor table AND the Item table from the database (Module 1 Lab Assignment.accdb) into the new blank database you created in Step 1.
- Open the Vendor table.
- Change the field size for the Vendor Code field to 2
- Change the field size for the Vendor Name field to 25
- Change the field size for the Telephone Number field to 12
- Assign the caption VC to the Vendor Code field
- Resize the columns to best fit the data
- Save the changes to the table and close the table
- Open the Item table.
- Change the field size for the Vendor Code field to 2
- Change the field size for the Item Number field to 4
- Change the field size for the Description field to 28
- Add the caption Wholesale for the Wholesale Cost field, the caption Retail for the Retail Price field, and the caption VC for the vendor code
- The On Hand field should be an Integer field
- Resize the columns to best fit the data
- Save the changes to the table and close the table
- Create a query for the Item table. Include the Item Number, Description, Wholesale Cost,
Retail Price, and Vendor Code. Save the query as Item Query. - Create a form for the Item table. Save the form as Item.
- Create a report for the Item table. Include the Item Number, Description, On Hand, and Wholesale Price. Save the report as Item Status Report.
- Change the telephone number for Asherton Wholesalers to 999-999-9999.
- Update the author (use your name) and title (use 'Week 3 Microsoft Access Module 1 Lab Assignment') in the document properties.
Appointment ID | Patient ID | Appointment Date | Appointment Time | Treatment Number | Veterinarian | Owner |
---|---|---|---|---|---|---|
1 | F-1 | 6/30/21 | 12/30/99 | T-3 | B01 | 0-6 |
2 | C-2 | 10/25/21 | 12/30/99 | T-4 | B01 | 0-8 |
3 | C-2 | 1/10/21 | 12/30/99 | T-2 | B01 | 0-5 |
4 | F-1 | 6/30/21 | 12/30/99 | T-1 | B01 | 0-1 |
5 | C-1 | 8/23/21 | 12/30/99 | T-4 | G01 | 0-4 |
Treatment Number | Treatment | Animal Type | Cost |
---|---|---|---|
T-1 | Feline Rabies Shot | Feline | ¤ 18.00 |
T-10 | Neuter | Feline | ¤ 25.00 |
T-11 | Spay | Canine | ¤ 35.00 |
T-12 | Neuter | Canine | ¤ 40.00 |
T-13 | Microchip | Feline | ¤ 10.00 |
T-14 | Microchip | Canine | ¤ 10.00 |
T-2 | Dog Wellness Exam | Canine | ¤ 50.00 |
T-3 | Wellness Exam | Feline | ¤ 20.00 |
T-4 | Dog Rabies Shot | Canine | ¤ 20.00 |
T-5 | Feline Vaccinations | Feline | ¤ 30.00 |
T-6 | Canine Vaccinations | Canine | ¤ 35.00 |
T-7 | Heartworm | Canine | ¤ 25.00 |
T-8 | Heartworm | Feline | ¤ 20.00 |
T-9 | Spay | Feline | ¤ 25.00 |
Veterinarian ID | First Name | Last Name | Office Phone | Cell Phone | Email Address | Street Address | City | State | ZIP Code |
---|---|---|---|---|---|---|---|---|---|
B01 | William | Black | 719-238-6682 | 719-334-9856 | [email protected] | 9887 Dover | Dolores | CO | 81323 |
G01 | Teresa | Gomez | 435-222-4545 | 435-229-5612 | [email protected] | 6214 Lansing | Blanding | UT | 84511 |