Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Choose a company, school, organization, or other entity (real or imagined) that could use a database to manage its information. For this entity, create a
Choose a company, school, organization, or other entity (real or imagined) that could use a database to manage its information. For this entity, create a Microsoft Access database that has the following characteristics:
- At least 4 tables containing 5 to 10 records each
- Tables should have an adequate number of fields to demonstrate the characteristics of each record. For example, there would be many more fields in the Student Master table than were shown in class.
- In the description area in the table design view, explain why you chose the data type for each field in the table.
- Each table should have a primary key and any related tables should have a primary and foreign key, and be linked in the relationship window
- Each field should have an appropriate data type considering its purpose and minimizing the size of the database
- At least two queries that would be useful to users, one of which must be a parameter query (i.e. it asks for a value to limit results)
- At least one report that would be useful to users. The format created by the report wizard is acceptable, although you may earn extra points for making it look better.
- A short description of the organization you chose and the purpose of the database should be include in the Comments section in the database properties.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered 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