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.
    Access database table open with first cell in ContactID column selected.
  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

    Access database table open showing cells that were previously missing data are now filled.

  4. 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 table open showing the corrected spelling for Emily Zola.
  5. 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 table open showing the record for Joe Jones has been removed.
  6. 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 table open showing the addition of the record for Heath Karrick.
  7. Filter: Sort the contact table by last name A–Z.
    Access database table open showing the records sorted by last name from A to Z.
  8. Save: Save the file.
  9. Submit the presentation file in your course online.

Contribute!

Did you have an idea for improving this content? We’d love your input.

Improve this pageLearn More