13.19: Assignment- Modify Access Database
In the previous module’s assignment, you created the beginning of a database. In this assignment you’ll work with an existing database with business card information and use the skills you have learned in this module.
To complete this assignment, download the Access file here . Follow the directions, then submit your assignment. If you get stuck on a step, review this module and ask your classmates for help in the discussion forum.
- Open the database and save the new Module 13 assignment file to the Rowan folder on your desktop as BA132_LastName_BusinessCardDB.accdb, replacing “LastName” with your own last name. (Example: BA132_Hywater_Memo) It is a good idea to save your work periodically.
-
In the open Access database file open the 2020_BusinessCards table. The contact table entrees are now visible and can be modified.
-
Add Information:
There are database cells missing data. Use the information in the table to fill in the missing information in the right places.
Contact ID FirstName LastName CompanyName Phone Website Email 3 Cardaso.com 6 8015556987 Footagesaces.info k.bush@footage.com 7 Martin.l@marketp.co 10 Jenna jennak@globalredial.com 13 2025557895 Peoplesocial.net 15 cyyoung@creditbooth.nz 17 Hamilton Jefferson hammyjeff@swipesure.org 18 CarpetEZ Carpetez.com 20 Cheesezy Cheesezy.info -
Edit Information:
There is a misspelling in one of the contacts. Emile Zola should be spelled Emily Zola. Correct her name in the database.
-
Delete Contact Info:
One of the contacts is no longer at the company and needs to be removed from the database. Locate Joe Jones and delete the record.
-
Add New Contact:
Enter a new contact with the following information into the existing table.
-
Heath Karrick, Spry Life, LLC, 2025551423, sprylife.com,
heathkck@sprylife.com
-
Heath Karrick, Spry Life, LLC, 2025551423, sprylife.com,
heathkck@sprylife.com
-
Filter:
Sort the contact table by last name A–Z.
- Save: Save the file.
- Submit the presentation file in your course online.
Contributors and Attributions
CC licensed content, Original
- Assignment: Modify Access Database. Authored by : Sherri Pendleton. Provided by : Lumen Learning. License : CC BY: Attribution