Answered step by step
Verified Expert Solution
Question
1 Approved Answer
assume you are in school full time and are starting a part-time side business. You will need to create a database for your part-time concierge
assume you are in school full time and are starting a part-time side business. You will need to create a database for your part-time concierge service. Examples of specialty services include pet sitting, house sitting, running errands, grocery shopping, etc. You need to design your database for this business. You will need at least five entities with attributes.Using Microsoft Access, perform the following tasks:
- Create a database and at least five tables along with the appropriate attributes to meet the needs of the business case above.
- In your database, you will need to show that you have added ten customers, ten specialty services, and have performed 25 services for customers in the past month.
- Create at least five forms to get data into your database.
- Create a report to show monthly activity.
- Run your report before and after adding new customers to test functionality. (Get a screenshot of the report before you add more records.)
- Add subtotals and totals into your report.
- Be sure to set up the correct relationship types between the tables: 1:M, 1:1, M:1, M:M.
- Be sure to include referential integrity constraints.
- Using your diagramming tool of choice, diagram your database table and the relationships between the tables.
- Save the database with all objects and save with filename customer_sales.accdb.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started