{"id":5452,"date":"2022-04-01T21:28:31","date_gmt":"2022-04-01T21:28:31","guid":{"rendered":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/?post_type=chapter&p=5452"},"modified":"2024-04-08T20:51:26","modified_gmt":"2024-04-08T20:51:26","slug":"module-14-assignment-modify-access-database","status":"publish","type":"chapter","link":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/chapter\/module-14-assignment-modify-access-database\/","title":{"raw":"Module 14 Assignment: Modify Access Database","rendered":"Module 14 Assignment: Modify Access Database"},"content":{"raw":"In the previous module\u2019s assignment, you created the beginning of a database. In this assignment you\u2019ll work with an existing database with business card information and use the skills you have learned in this module.\r\n\r\nTo complete this assignment, download the Access file here<\/a>. 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.\r\n
    \r\n \t
  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 \u201cLastName\u201d with your own last name. (Example: BA132_Hywater_Memo) It is a good idea to save your work periodically.<\/li>\r\n \t
  2. In the open Access database file open the 2020_BusinessCards table. The contact table entrees are now visible and can be modified.\r\n\"A<\/li>\r\n \t
  3. Add Information:<\/strong> There are database cells missing data. Use the information in the table to fill in the missing information in the right places.<\/li>\r\n<\/ol>\r\n
    \r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n
    Contact ID<\/td>\r\nFirstName<\/td>\r\nLastName<\/td>\r\nCompanyName<\/td>\r\nPhone<\/td>\r\nWebsite<\/td>\r\nEmail<\/td>\r\n<\/tr>\r\n
    3<\/td>\r\n<\/td>\r\n<\/td>\r\n<\/td>\r\n<\/td>\r\nCardaso.com<\/td>\r\n<\/td>\r\n<\/tr>\r\n
    6<\/td>\r\n<\/td>\r\n<\/td>\r\n<\/td>\r\n8015556987<\/td>\r\nFootagesaces.info<\/td>\r\nk.bush@footage.com<\/td>\r\n<\/tr>\r\n
    7<\/td>\r\n<\/td>\r\n<\/td>\r\n<\/td>\r\n<\/td>\r\n<\/td>\r\nMartin.l@marketp.co<\/td>\r\n<\/tr>\r\n
    10<\/td>\r\nJenna<\/td>\r\n<\/td>\r\n<\/td>\r\n<\/td>\r\n<\/td>\r\njennak@globalredial.com<\/td>\r\n<\/tr>\r\n
    13<\/td>\r\n<\/td>\r\n<\/td>\r\n<\/td>\r\n2025557895<\/td>\r\nPeoplesocial.net<\/td>\r\n<\/td>\r\n<\/tr>\r\n
    15<\/td>\r\n<\/td>\r\n<\/td>\r\n<\/td>\r\n<\/td>\r\n<\/td>\r\ncyyoung@creditbooth.nz<\/td>\r\n<\/tr>\r\n
    17<\/td>\r\nHamilton<\/td>\r\nJefferson<\/td>\r\n<\/td>\r\n<\/td>\r\n<\/td>\r\nhammyjeff@swipesure.org<\/td>\r\n<\/tr>\r\n
    18<\/td>\r\n<\/td>\r\n<\/td>\r\nCarpetEZ<\/td>\r\n<\/td>\r\nCarpetez.com<\/td>\r\n<\/td>\r\n<\/tr>\r\n
    20<\/td>\r\n<\/td>\r\n<\/td>\r\nCheesezy<\/td>\r\n<\/td>\r\nCheesezy.info<\/td>\r\n<\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\n\"Information\r\n\r\n<\/div>\r\n
      \r\n \t
    1. Edit Information:<\/strong> There is a misspelling in one of the contacts. Emile Zola should be spelled Emily Zola. Correct her name in the database.\r\n\"Access<\/li>\r\n \t
    2. Delete Contact Info:<\/strong> 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.\r\n\"Access<\/li>\r\n \t
    3. Add New Contact:<\/strong> Enter a new contact with the following information into the existing table.\r\n
        \r\n \t
      1. Heath Karrick, Spry Life, LLC, 2025551423, sprylife.com, heathkck@sprylife.com\r\n\"Access<\/li>\r\n<\/ol>\r\n<\/li>\r\n \t
      2. Filter:<\/strong> Sort the contact table by last name A\u2013Z.\r\n\"Access<\/li>\r\n \t
      3. Save:<\/strong> Save the file.<\/li>\r\n \t
      4. Submit the database file in your course online.<\/li>\r\n<\/ol>","rendered":"

        In the previous module\u2019s assignment, you created the beginning of a database. In this assignment you\u2019ll work with an existing database with business card information and use the skills you have learned in this module.<\/p>\n

        To complete this assignment, download the Access file here<\/a>. 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.<\/p>\n

          \n
        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 \u201cLastName\u201d with your own last name. (Example: BA132_Hywater_Memo) It is a good idea to save your work periodically.<\/li>\n
        2. In the open Access database file open the 2020_BusinessCards table. The contact table entrees are now visible and can be modified.
          \n\"A<\/li>\n
        3. Add Information:<\/strong> There are database cells missing data. Use the information in the table to fill in the missing information in the right places.<\/li>\n<\/ol>\n
          \n\n\n\n\n\n\n\n\n\n\n\n\n
          Contact ID<\/td>\nFirstName<\/td>\nLastName<\/td>\nCompanyName<\/td>\nPhone<\/td>\nWebsite<\/td>\nEmail<\/td>\n<\/tr>\n
          3<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\nCardaso.com<\/td>\n<\/td>\n<\/tr>\n
          6<\/td>\n<\/td>\n<\/td>\n<\/td>\n8015556987<\/td>\nFootagesaces.info<\/td>\nk.bush@footage.com<\/td>\n<\/tr>\n
          7<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\nMartin.l@marketp.co<\/td>\n<\/tr>\n
          10<\/td>\nJenna<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\njennak@globalredial.com<\/td>\n<\/tr>\n
          13<\/td>\n<\/td>\n<\/td>\n<\/td>\n2025557895<\/td>\nPeoplesocial.net<\/td>\n<\/td>\n<\/tr>\n
          15<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\ncyyoung@creditbooth.nz<\/td>\n<\/tr>\n
          17<\/td>\nHamilton<\/td>\nJefferson<\/td>\n<\/td>\n<\/td>\n<\/td>\nhammyjeff@swipesure.org<\/td>\n<\/tr>\n
          18<\/td>\n<\/td>\n<\/td>\nCarpetEZ<\/td>\n<\/td>\nCarpetez.com<\/td>\n<\/td>\n<\/tr>\n
          20<\/td>\n<\/td>\n<\/td>\nCheesezy<\/td>\n<\/td>\nCheesezy.info<\/td>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

          \"Information<\/p>\n<\/div>\n

            \n
          1. Edit Information:<\/strong> There is a misspelling in one of the contacts. Emile Zola should be spelled Emily Zola. Correct her name in the database.
            \n\"Access<\/li>\n
          2. Delete Contact Info:<\/strong> 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.
            \n\"Access<\/li>\n
          3. Add New Contact:<\/strong> Enter a new contact with the following information into the existing table.\n
              \n
            1. Heath Karrick, Spry Life, LLC, 2025551423, sprylife.com, heathkck@sprylife.com
              \n\"Access<\/li>\n<\/ol>\n<\/li>\n
            2. Filter:<\/strong> Sort the contact table by last name A\u2013Z.
              \n\"Access<\/li>\n
            3. Save:<\/strong> Save the file.<\/li>\n
            4. Submit the database file in your course online.<\/li>\n<\/ol>\n\n\t\t\t
              \n\t\t\t

              Candela Citations<\/h3>\n\t\t\t\t\t
              \n\t\t\t\t\t\t
              \n\t\t\t\t\t\t\t
              CC licensed content, Original<\/div>