Read PlugIn_T6-Basic Skills and Tools Using Access 2013/2010 (there was no way to attach but this can be easily found online) and do problem 3 (Academic Software):

3. Academic Software

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 companys philosophy is simple: Hire

amazing people, give them the best tools, and help them deliver an unbeatable customer

experience.

One facet of Academic Softwares 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, fi elds, data types, and primary key(s) for the database using the

structure provided in the T6_AcademicSoftware_Data.xls fi le.

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

4. Populate the database with the data provided in the T6_AcademicSoftware_Data.xls file (see below).

For this assignments:

1. Create the DB and the required tables.

2. Create relationships among the tables.

3. Enter the data into the tables from the spreadsheet.

Software Software Software Vendor Vendor Vendor l Vendor Vendor City Software ID Name Category Price Vendor Name Address Phone $79.95 Learnit Software 145 Oak Ave. Wilmington DE 19808 302-475-4477 S4995 Edusot Inc. 0870 Number Crunch Math 1625 Brook St. Costa Mesa CA 92688 714-336-4785 1673 Chem Works Science $19.95 Compuschool Co 9661 King PL Springfield MA 01013 413-572-8292 Kid-Writer English 1693 $29.95 Learnit Software 145 Oak Ave. Wilmington DE 19808 302-475-4477 2573 Pendulum Science $24.95 Edusoft Inc 1625 Brook St. Costa Mesa CA 92688 714-336-4785 2603 StoryWriter English $24.95 Compuschool Co 9661 King PI! Springfield MA 01013 413-572-8292 Math Tester Math $39.95 Academic Software 346 Magee Ave. Philadelphia PA 3933 19111 215-780-3953 3963 Writing is Fun English S39.95 Compuschool Co. 9661 King Pl. Springfield MA 4353 Rhythmetic Math 369.95 Academic Software 346 Magee Ave. Philadelphia PA 01013 413-572-8292 19111 215-780-3953 5820 Test Tube Science S24 95 Academic Software 346 Magee Ave. Philadelphia PA 19111 215-780-3953 S89.95 Edusot Inc. 1625 Brook St. Costa Mesa CA 92688 714-336-4785 5940 Science Quest Science 5950 Easy English English $29.95 Learnit Software 145 Oak Ave. Wilmington DE 19808 302-475-4477 Software Software Software Vendor Vendor Vendor l Vendor Vendor City Software ID Name Category Price Vendor Name Address Phone $79.95 Learnit Software 145 Oak Ave. Wilmington DE 19808 302-475-4477 S4995 Edusot Inc. 0870 Number Crunch Math 1625 Brook St. Costa Mesa CA 92688 714-336-4785 1673 Chem Works Science $19.95 Compuschool Co 9661 King PL Springfield MA 01013 413-572-8292 Kid-Writer English 1693 $29.95 Learnit Software 145 Oak Ave. Wilmington DE 19808 302-475-4477 2573 Pendulum Science $24.95 Edusoft Inc 1625 Brook St. Costa Mesa CA 92688 714-336-4785 2603 StoryWriter English $24.95 Compuschool Co 9661 King PI! Springfield MA 01013 413-572-8292 Math Tester Math $39.95 Academic Software 346 Magee Ave. Philadelphia PA 3933 19111 215-780-3953 3963 Writing is Fun English S39.95 Compuschool Co. 9661 King Pl. Springfield MA 4353 Rhythmetic Math 369.95 Academic Software 346 Magee Ave. Philadelphia PA 01013 413-572-8292 19111 215-780-3953 5820 Test Tube Science S24 95 Academic Software 346 Magee Ave. Philadelphia PA 19111 215-780-3953 S89.95 Edusot Inc. 1625 Brook St. Costa Mesa CA 92688 714-336-4785 5940 Science Quest Science 5950 Easy English English $29.95 Learnit Software 145 Oak Ave. Wilmington DE 19808 302-475-4477