Microsoft Access Project: Individual Submission

Topic Selection & Getting Started

As you think about the database you will create for your project, consider areas of your life where you have data that may need tracking. Understand that in this project, you will create a small database of just a couple of tables, so you can keep it simple.

Choosing Your Topic:

Consider the type of data utilized in your field or industry and how it might be tracked in a database.

  • Data relating to your personal life:
  • Tracking gift ideas for Christmas/birthdays
  • Tracking your child’s milestone events
  • Keeping track of valuable items in your home
  • Tracking home or vehicle maintenance
  • Maintaining contact information for your friends and family
  • Recording charitable donations
  • Roster for team sports
  • Data used in a professional capacity:
  • Hair salon appointment tracker
  • Doctor’s office appointment tracker
  • Restaurant inventory management
  • Hotel management
  • Registration database for an event (conference, convention, workshop, etc.)
  • Karaoke

How to begin:

  1. Write down a list of all of the fields related to your topic that could be included in the database.
  2. Divide the data into “buckets” of related information. For example: customer demographics may be one table, while appointments made by those customers need to be housed in a separate, but related table. A real-life database could include many more tables, but you will focus on just 2–3 tables for this project.
  3. Design your tables based on the fields identified above in steps 1–2. Apply appropriate data types and consider what information will join the tables together using a relationship.
  4. There must be at least 50 records added to the database and they must be distributed appropriately in each table.
  5. Be sure to include a description to your instructor of the purpose of your database in the comments area of your Blackboard submission. This provided rationale will assist your instructor with the grading of your project.


 

Database Examples

  1. Database for a Landscaping company. Data is divided into 3 tables:
  2. Customer: demographic info for customers
  3. Contract: jobs that have been created for the customers
  4. Invoice: invoices that have been sent based on the contract

Relationships are defined as follows

  • For every 1 customer, there may be many contracts (landscaping jobs)
  • For every 1 contract, there may be many invoices that have been billed
  1. Database for DMV records. Data is divided into 3 tables:
  2. Drivers: demographic and license information for drivers that have been ticketed
  3. Ticket: fields detailing the offense when a driver is pulled over
  4. Officer: demographic information regarding the police officer making the stop

Relationships are defined as follows

  • Each driver may have multiple tickets
  • Each police officer may have issued multiple tickets
  1. Database for a tire shop. Data is divided into 3 tables:
  2. Customer: demographic info for customers
  3. Sales: sales record for each transaction where the shop has sold a tire
  4. Tires: tire inventory

Relationships are defined as follows

  • Every customer may have multiple sales/purchases
  • Each tire may have been sold on multiple sales/purchases

 

Submit your Microsoft Access Project: Individual Submission by 11:59 p.m. (ET) on Monday of Module/Week 7.