Assignment: Create New Access Database

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_Memo) 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
  5. Open Design View: Open the design view of the current table and name the table 2020_BusinessCards.
    A blank database in Microsoft Access. A Save As dialog box is open, and a new table called 2020_BusinessCards is being created.
  6. Set the Primary Key: In the ‘Field Name’ with the little key to the left side create a primary key name to use for this table. (Refer to the module about the various options of creating a key.) Make sure to keep the Data Type to AutoNumber and add in a text description.
    A database in Microsoft Access. A cell underneath the column "Field Name" is selected. There is a small key icon to the left of the selected cell. A dialogue box with two tabs "General" and "Lookup" is open at the bottom of the page. The tab "General" is selected with the following fields: Field Size, New Values, Format, Caption, Indexed, Text Align.
  7. Indexed: In the new table with the new key make sure the filed for Indexed is set to Yes (No Duplicates).
    A database in Microsoft Access with one row filled out. The cell underneath "Field Name" reads "Biz_Card". The cell underneath Data Type reads "AutoNumber". The cell underneath Description (Optional) reads "Collected business cards for 2020". The "General" tab is selected for the dialogue box at the bottom of the page and the cell next to "Indexed" reads "Yes (No duplicates)".
  8. Save File: Save all of your work again.
  9. Submit the database file in your course online.

Contribute!

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

Improve this pageLearn More