Creating Database Tables: Apply It 1

  • Create a blank database
  • Name the database and location
  • Discuss the role of tables in access
  • Differentiate among types of tables
  • Create a new table

In this assignment, you’ll create a new database and set it up for data to be entered. This year you decided to keep new business cards (physical and electronic) you receive organized with by creating an Access database to store all their information for quick access.

To complete this assignment, 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 Microsoft Access to the Home page
    The Home page in Microsoft Access
  2. Chose New Database: Choose from one of the ways to create a new database and select the New database option.
    The Microsoft Access New page. Blank database has been selected
  3. Name Database: Decide on a file name for the new database and its location on your computer where you’ll save it. Remember this is to be created for collecting business card information so name accordingly. Save the new Module 12 assignment file to the Rowan folder on your desktop as BA132_LastName_BCDatabase.accdb, replacing “LastName” with your own last name. (Example: BA132_Hywater_BCDatabase) It is a good idea to save your work periodically.
    Dialog box for a new database. The file has been named 2020_Business cards
  4. Create Database: A new data table is now open and ready for data input.A blank table in Microsoft Access