Human Resource Databases

Database Scenario:

The Music Stop is a locally owned music store in your hometown. It buys and sells CDs, cassettes, and recordswith a staff of 8 people. Up until this point, it has beenusing paper-based records to keep track of customers who come in to sell used music; realizing this system is very outdated and problematic, the store hascalled you and asked you to create a simple Microsoft Access table so it can keep track of the customers selling music and its employees.

Individual Assignment Details (100 points):

Each individual shouldcreate an Access database that includes 2 different tables: an employee table and a customer table.

  • Field titles for theemployee table should be as follows:
    • Employee ID number
    • First name
    • Last name
    • Address
    • Date of hire
    • Date of birth
    • Social security number
    • Hourly wage
  • Field titles for the customer table should be the following:
    • Customer ID number
    • First name
    • Last name
    • Address
    • Phone number
    • Number of items sold to store
  • Select the appropriate data type for each field title (for example: social security number would be number type)
  • For the employee table,enter 8 fake employees into the table
  • For the customer table, enter 10 fake customers into the table
  • Appropriately title each table
  • If you think of other field titles that should be included, make sure to include them.
  • Some things to consider:
    • To create a new table, click “Create” on the top toolbar and then select table.
    • To addfield titles on the “Home” toolbar switch to Design View.

Leave a Comment

Your email address will not be published. Required fields are marked *

Is this question part of your Assignment?

Get expert help

Girl in a jacket


At UvoCorpEssays, we have a knowledgeable
and proficient team of academic tutors.
With a keen eye for detail, we will deliver a
quality paper that conforms to your instructions
within the specified time. Our tutors are guided
by values that promote a supportive and caring
environment to a client base from diverse backgrounds.
Our driving motto is ‘winning minds, empowering success.’

description here description here description here