Working with Tables: Apply It 1

  • Define datasheets
  • Discuss datasheet windows within Microsoft Access
  • Enter data in datasheets
  • Change values in datasheets

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. Save: Save the file.