Launched in 2005 in Boston, Massachusetts, Academic Software has consistently been the fastest-growing education-focused software retailer in North America. It is committed exclusively to academic customers, offering thousands of full-version software titles at great discounts. Academic Software has partnered with the top technology manufacturers, including Adobe, Microsoft, Sibelius, Sony Media Software, and Wacom, to offer excellent service and prices, which are available only to students, schools, and teachers. From the very beginning, Academic Software has relied heavily on technology to ensure a positive shopping experience for its customers. The company’s philosophy is simple: Hire amazing people, give them the best tools, and help them deliver an unbeatable customer experience. One facet of Academic Software’s business that needs assistance is its database organization. You have been asked to assist Academic Software with creating a relational database structure for organizing software, vendors, and academic categories. Currently, this information is stored in an Excel spreadsheet, T6_AcademicSoftware_Data.xls, which Academic Software has provided to you.

Specifically, you are asked to:

1. Create a Microsoft Access database.

2. Create the tables, fields, data types, and primary key(s) for the database using the structure provided in the T6_AcademicSoftware_Data.xls file.

3. Create the relationship(s) needed between the tables.

4. Populate the database with the data provided in the T6_AcademicSoftware_Data.xls file.

A. Special notes to use with the 4 questions from the workbook:

1. Three tables will be created for this MS Access database according to the assignment instruction: Categories, Software, and Vendors

2. Use the attached MS Excel file to populate the MS Access database file you will create for this assignment

3. Software ID – Use as the primary key for the Software table.

4. Create unique ID field for vendors and academic categories tables, which are to be used as the primary key: Vendors (e.g., Academic Software = AS) and Academic Categories (e.g., Math = MTH).

 

1 2 3 11 12 13 A C D Academic Software Software ID Software Name Category Price A 0593 0870 1673 1693 2573 2603 3933 3963 4353 5820 5940 5950 B Easy Calculus Math Number Crunch Math Vendor Name $79.95 Learnit Software 145 Oak Ave. Wilmington DE $49.95 Edusoft Inc. 1625 Brook St. Costa Mesa CA Chem Works Science $19.95 Compuschool Co. 9661 King Pl. Springfield MA $29.95 Learnit Software 145 Oak Ave. Wilmington DE $24.95 Edusoft Inc. 1625 Brook St. Costa Mesa CA MEN $24.95 Compuschool Co. 9661 King Pl. Springfield MA $39.95 Academic Software 346 Magee Ave. Philadelphia PA $39.95 Compuschool Co. 9661 King Pl. Springfield MA $69.95 Academic Software 346 Magee Ave. Philadelphia PA Science $24.95 Academic Software 346 Magee Ave. Philadelphia PA $89.95 Edusoft Inc. $29.95 Learnit Software Kid-Writer Pendulum Storywriter Math Tester Rhythmetic English Test Tube Science English Writing is Fun English Math Math Science Quest Science E Easy English English F Vendor Address G H I J Vendor Vendor Vendor Vendor City State Zip Phone 302-475-4477 714-336-4785 413-572-8292 302-475-4477 714-336-4785 413-572-8292 215-780-3953 413-572-8292 215-780-3953 215-780-3953 714-336-4785 302-475-4477 1625 Brook St. Costa Mesa CA 145 Oak Ave. Wilmington DE 19808 92688 01013 19808 92688 01013 19111 01013 19111 19111 92688 19808