View the step-by-step solution to:

MICROSOFT ACCESS PROJECT: INDIVIDUAL SUBMISSION Topic Selection & Getting Started As you think about the database you will create for your...

Need help with Microsoft Access. Please assist me with the following problems. Instructions are listed belowaccess 1.pngaccess 2.png

access 1.png

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. a Data relating to your personal life: 0 Tracking gift ideas for Christmasfbirthdays
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
o Roster for team sports a Data used in a professional capacity: 0 Hair salon appointment tracker
Doctor’s office appointment tracker
Restaurant inventory management Hotel management
Registration database for an event (conference, convention, workshop, etc.) Karaoke 00000 00000 How to begin: I. 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.

access 2.png

Database Examples A. Database for a Landscaping company. Data is divided into 3 tables:
1. Customer: demographic info for customers 2. Contract: jobs that have been created for the customers
3. Invoice: invoices that have been sent based on the contract Relationships are defined as follows I For every 1 customer, there may be many contracts (landscaping jobs)
I For every 1 contract, there may be many invoices that have been billed tthuslomul tbllnvoire 7 m i‘ lmolleunI
COMM“! Cam-nun
FirstN-me [momma
lama-Ia ' lllroitdtem
“"0"! uwolcum
“m“ umlumd
(in
sun
2‘9
[In-Imam“:
Comments B. Database for DMV records. Data is divided into 3 tables:
1. Drivers: demographic and license information for drivers that have been ticketed
2. Ticket: fields detailing the offense when a driver is pulled over
3. Officer: demographic information regarding the police officer making the stop Relationships are defined as follows I Each driver may have multiple tickets
I Each police officer may have issued multiple tickets I ll'tthtI
LIIINIIII Hmfliml
Adore" C. Database for a tire shop. Data is divided into 3 tables:
1. Customer: demographic info for customers
2. Sales: sales record for each transaction where the shop has sold a tire
3. Tires: tine inventory Relationships are defined as follows I Every customer may have multiple sales/purchases
I Each tire may have been sold on multiple sales/purchases Customs: Buck Sals Buck Tilu Buck
V tum ‘F 1mm:- 1 mun
InvokeDlt: Modal Nam (mm Manutmum
ParllD Unit Pnu Qu-nuty rm

Recently Asked Questions

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question