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.

.N.B I need the Microsoft acres copy and another detail process how the assignment was done in a Microsoft word file

ComputerScienceExpert

(11)

Status NEW Posted 04 May 2017 12:05 AM My Price 8.00

-----------

Attachments

file 1493859528-Solutions file 2.docx preview (51 words )

H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly -----------onl-----------ine----------- an-----------d g-----------ive----------- yo-----------u e-----------xac-----------t f-----------ile----------- an-----------d t-----------he -----------sam-----------e f-----------ile----------- is----------- al-----------so -----------sen-----------t t-----------o y-----------our----------- em-----------ail----------- th-----------at -----------is -----------reg-----------ist-----------ere-----------d o-----------n -----------THI-----------S W-----------EBS-----------ITE-----------. ----------- Th-----------ank----------- yo-----------u -----------

Not Rated(0)

• Buy Answer