Module 14 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.

  1. 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.
  2. In the open Access database file open the 2020_BusinessCards table. The contact table entrees are now visible and can be modified.
    A table within Access that has contact entrees visible.
  3. 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
Information from the table being added into the empty cells of the Access database.
  1. Edit Information: There is a misspelling in one of the contacts. Emile Zola should be spelled Emily Zola. Correct her name in the database.
    Access database with the name Emile being updated to Emily.
  2. 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.
    Access database with Joe Jones no longer listed.
  3. Add New Contact: Enter a new contact with the following information into the existing table.
    1. Heath Karrick, Spry Life, LLC, 2025551423, sprylife.com, heathkck@sprylife.com
      Access database with Heath Karrick's information added to the records.
  4. Filter: Sort the contact table by last name A–Z.
    Access database contacts are sorted alphabetically by last name.
  5. Save: Save the file.
  6. Submit the database file in your course online.