I have some computer applications project. I need an American computer applications expert???

5848061-4.pdf

Home >Business & Finance homework help >Management homework help >I have some computer applications project. I need an American computer applications expert???

Graded Project

Microsoft Access 2016

INTRODUCTION 2

INSTRUCTIONS 2

SCORING GUIDELINES 16

SUBMITTING YOUR PROJECT 18

INTRODUCTION

CONTENTS

GRADED PROJECT

MICROSOFT ACCESS 2016

INTRODUCTION The purpose of this project is to create a home inventory database that can be referred to in case of damage, theft, or natural disaster. You’ll assume the role of homeowner, who over time has acquired many valuable assets. You’d like to more easily manage purchase history, product serial and model numbers, warranties, and appraisal information. For this project, you must create an Access database with forms, queries, and reports that you will store off site in case of emergency.

INSTRUCTIONS

CREATE A DATABASE

1. Start Access and create a Blank database, naming it “Inventory.”

2. On the Home tab, click View and then name the new table “Inventory.”

3. In Design view, change the field name ID to Item ID and verify that it is data type AutoNumber and that it has been selected as the Primary Key.

4. In Design view, add the remaining fields and corresponding data types:

Field Name Data Type Description Item Name Short Text

Category Short Text Appliances, Electronics, Jewelry, Other

Manufacturer Short Text

Model Short Text

Serial Number Short Text

Purchase Date Date/Time (Short Date)

Purchase Price Currency

Merchant ID Number

Online Purchase Yes/No

Credit Card Purchase Yes/No

Warranty Type Short Text Store, Manufacturer, Other

Warranty Length Short Text

Repair Yes/No

Repair Date Date/Time (Short Date)

Comments Short Text

5. Save and then close the Inventory table.

6. Create a second table in Design view. Name the table “Merchants.”

7. Add the following fields and corresponding data types. Be sure Merchant ID is the Primary key:

Field Name Data Type Description Merchant ID AutoNumber

Merchant Name Short Text

Address Short Text

City Short Text

State Short Text

Zip Short Text

Email Hyperlink

Website Hyperlink

Telephone Short Text

Fax Short Text

8. Save and then close the Merchants table.

9. Create a relationship by linking the Merchant ID in the Inventory table to the Merchant ID in the Merchants table. Be sure to enforce referential integrity.

CREATE FORMS AND POPULATE THE DATABASE

1. Create a Merchants form that looks similar to Figure 1.

Figure 1

2. Create an Inventory form that looks similar to Figure 2.

Figure 2

3. Use the Merchants form to populate the appropriate sections in the Merchants table with the records listed below.

Merchant Records Merchant ID 1

Merchant Name Electronics Mart

Address 65 Resister Ave.

City Blankston

State PA

Zip 18454

Email [email protected]

Website www.emart.com

Telephone (570) 555-1111

Fax (570) 555-1112

Merchant ID 2

Merchant Name Appliances Inc.

Address 2020 Mechanics Road

City Blankston

State PA

Zip 18454

Email n/a

Website n/a

Telephone (570) 555-1234

Fax (none)

Merchant ID 3

Merchant Name Stuff Mart

Address 721 Frengburg St.

City Shopville

State NY

Zip 10022

Email [email protected]

Website www.stuffmart.com

Telephone (212) 555-5432

Fax n/a

Merchant ID 4

Merchant Name Phones and More

Address 21 Framer Circle

City Klossville

State PA

Zip 19019

Email [email protected]

Website www.phonesandmore.com

Telephone (612) 555-9876

Fax n/a

Merchant ID 5

Merchant Name Jewelry Warehouse

Address 24 Karat Street

City Platoid

State NY

Zip 00050

Email [email protected]

Website www.jewelware.com

Telephone (609) 555-3344

Fax (609) 555-3345

Merchant ID 6

Merchant Name Crazy John’s Computers

Address 456 Enterprise St.

City Wynnsville

State CO

Zip 18888

Email [email protected]

Website www.merchandizing.net/crazy

Telephone (301) 555-9080

Fax n/a

Merchant ID 7

Merchant Name Collector’s Emporium

Address 256 Antiques Ave.

City Oldensurg

State PA

Zip 18999

Email [email protected]

Website www.collectibles.net

Telephone (570) 555-1608

Fax (570) 555-1609

4. Use the Inventory form to populate the appropriate sections in the Inventory table with the records listed below.

Inventory Records Item ID 1

Item Name GameBox

Category Electronics

Manufacturer Super

Model GB928

Serial Number R729-382

Purchase Date 2/1/2017

Purchase Price $599.00

Merchant ID 1

Online Purchase No

Credit Card Purchase Yes

Warranty Type Manufacturer

Warranty Length 2 years, parts only

Repair No

Repair Date (none)

Comments packaged with one free game control

Item ID 2

Item Name Smart TV

Category Electronics

Manufacturer Super

Model 4200

Serial Number 1930456

Purchase Date 2/20/2017

Purchase Price $499.00

Merchant ID 1

Online Purchase No

Credit Card Purchase Yes

Warranty Type Manufacturer

Warranty Length 90 days, parts only

Repair No

Repair Date (none)

Comments (none)

Item ID 3

Item Name Laptop

Category Electronics

Manufacturer Deluxe

Model SuperFast

Serial Number 879603-109-345

Purchase Date 2/27/2017

Purchase Price $899.00

Merchant ID 3

Online Purchase No

Credit Card Purchase Yes

Warranty Type Manufacturer

Warranty Length 1 year, parts and labor

Repair Yes

Repair Date 6/1/2017

Comments keyboard replaced

Item ID 4

Item Name Bluetooth Headset

Category Electronics

Manufacturer Wireless

Model BT54910

Serial Number 345-896-000

Purchase Date 2/22/2017

Purchase Price $99.00

Merchant ID 4

Online Purchase Yes

Credit Card Purchase Yes

Warranty Type Manufacturer

Warranty Length 12 months, parts only

Repair No

Repair Date (none)

Comments (none)

Item ID 5

Item Name Ink Jet Printer

Category Electronics

Manufacturer Pro

Model U750

Serial Number 555639870

Purchase Date 1/15/2017

Purchase Price $49.00

Merchant ID 6

Online Purchase Yes

Credit Card Purchase Yes

Warranty Type Manufacturer

Warranty Length 90 days, parts and tech support

Repair No

Repair Date (none)

Comments (none)

Item ID 6

Item Name Refrigerator

Category Appliances

Manufacturer Wonderlux

Model Ice Age 2000

Serial Number 2567590

Purchase Date 4/5/2017

Purchase Price $999.00

Merchant ID 2

Online Purchase No

Credit Card Purchase Yes

Warranty Type Manufacturer/store

Warranty Length 2 years, parts and labor/5 years, refrigeration parts

Repair No

Repair Date (none)

Comments (none)

Item ID 7

Item Name Washing Machine

Category Appliances

Manufacturer Wonderlux

Model CL900

Serial Number 90050221

Purchase Date 6/4/2017

Purchase Price $625.00

Merchant ID 2

Online Purchase No

Credit Card Purchase Yes

Warranty Type Manufacturer

Warranty Length 1 year, parts and labor

Repair No

Repair Date (none)

Comments (none)

Item ID 8

Item Name Clothes Dryer

Category Appliances

Manufacturer Wonderlux

Model DR199

Serial Number 199502211

Purchase Date 6/4/2017

Purchase Price $700.00

Merchant ID 2

Online Purchase No

Credit Card Purchase Yes

Warranty Type Manufacturer

Warranty Length 1 year, parts and labor

Repair No

Repair Date (none)

Comments (none)

Item ID 9

Item Name Dishwasher

Category Appliances

Manufacturer Washomatic

Model DW19

Serial Number 195-763984

Purchase Date 8/12/2017

Purchase Price $475.00

Merchant ID 3

Online Purchase No

Credit Card Purchase Yes

Warranty Type Manufacturer

Warranty Length 1 year, parts and labor

Repair No

Repair Date (none)

Comments (none)

Item ID 10

Item Name Smart Phone

Category Electronics

Manufacturer EasyPhone

Model 17S

Serial Number 567-39QR4512

Purchase Date 1/30/2017

Purchase Price $799.00

Merchant ID 4

Online Purchase No

Credit Card Purchase Yes

Warranty Type Manufacturer

Warranty Length 1 year, parts only

Repair No

Repair Date (none)

Comments (none)

Item ID 11

Item Name Heart Pendant on Gold Chain

Category Jewelry

Manufacturer GoldPlus

Model n/a

Serial Number n/a

Purchase Date 2/11/2017

Purchase Price $599.00

Merchant ID 5

Online Purchase No

Credit Card Purchase Yes

Warranty Type n/a

Warranty Length n/a

Repair No

Repair Date (none)

Comments 24 karat gold, 18” serpentine link chain

Item ID 12

Item Name Engagement Ring

Category Jewelry

Manufacturer Jewelserv

Model n/a

Serial Number n/a

Purchase Date 2/12/2017

Purchase Price $2,500.00

Merchant ID 5

Online Purchase No

Credit Card Purchase Yes

Warranty Type n/a

Warranty Length n/a

Repair No

Repair Date (none)

Comments Appraisal in safety deposit box

Item ID 13

Item Name Super Hero #1 Comic Book

Category Collectibles

Manufacturer Funny Publishing May 1976 (publisher)

Model n/a

Serial Number n/a

Purchase Date 5/25/2017

Purchase Price $39.00

Merchant ID 7

Online Purchase Yes

Credit Card Purchase Yes

Warranty Type n/a

Warranty Length n/a

Repair No

Repair Date (none)

Comments 9.4 Comic Book Grading

Item ID 14

Item Name Super Hero #6 Comic Book

Category Collectibles

Manufacturer Funny Publishing November 1976 (publisher)

Model n/a

Serial Number n/a

Purchase Date 5/25/2017

Purchase Price $67.00

Merchant ID 7

Online Purchase Yes

Credit Card Purchase Yes

Warranty Type n/a

Warranty Length n/a

Repair No

Repair Date (none)

Comments 9.2 Comic Book Grading

QUERY THE DATABASE

1. Create a select query that retrieves the Item Name, Purchase Date, Purchase Price, and Online Purchase fields from the Inventory table for items purchased online.

a. Have the select query sort the results in chronological order by Purchase Date.

b. Be sure to format the Datasheet view so that all field names and data are displayed entirely.

c. Save the query naming it “Online Purchases” and then close the query.

2. Create a select query that retrieves the Merchant Name from the Merchants table and the Item Name, Category, Manufacturer, and Purchase Date from the Inventory table for appliances.

a. Have the select query sort the results in alphabetical order by Merchant Name.

b. Be sure to format the Datasheet view so that all field names and data are displayed entirely.

c. Save the query naming it “Appliance Purchases” and then close the query.

CREATE REPORTS

1. Create a tabular report using the Online Purchases query.

a. Sort the report data by Purchase Date.

b. Print Preview your report and adjust formatting as necessary, making sure all data are displayed on one page, as shown in Figure 3.

Figure 3

c. Save the report naming it “Online Purchases,” and then close the report.

2. Create a tabular report using the Appliance Purchases query.

a. Reduce field widths so that all fields are displayed in portrait orientation.

b. Move the Page 1 of 1 footer so that it is centered below the report data.

c. Delete the record count and the summary line below the Merchant Name data.

d. Group the report data by Merchant Name.

e. Sort the report data by Purchase Date.

f. Print Preview your report and adjust formatting as necessary, making sure all data are displayed on one page, as shown in Figure 4.

Figure 4

g. Save the report naming it “Appliance Purchases,” and then close the report.

SCORING GUIDELINES

RUBRIC

SKILL/ GRADING CRITERIA

EXEMPLARY (4)

PROFICIENT (3)

FAIR (2)

POOR (1)

NOT EVIDENT

(0)

Create tables

Tables with correct field names and types have been created.

Tables with mostly correct field names and types have been created.

Tables with some correct field names and types have been created.

Tables with- out correct field names and/or types have been created.

No attempt has been made to create tables.

Create forms

Forms corresponding to tables have been created.

N/A N/A An attempt has been made to create forms, but they don’t correspond to the tables.

No attempt has been made to create forms.

Perform data entry

All the designed records have been entered with minimal errors.

Most of the designed records have been entered with minimal errors.

Some of the designed records have been entered with minimal errors.

Few of the designed records have been entered with minimal errors.

No attempt has been made to perform data entry.

Create a select query

A select query with the designated fields and correct criteria has been created.

A select query with correct cri- teria and some of the designed fields has been created.

A select query with correct criteria and few of the designated fields has been created.

A select query that doesn’t contain the correct criteria has been created.

No attempt has been made to create a select query.

Sort select query results

A select query with the correct sort for the designed field has been created.

A select query with the correct sort for the wrong field has been created.

A select query with the wrong sort has been created.

A filter has been applied to query results in order to pro- vide a sort.

No attempt has been made to sort query results.

(Continued)

Format Datasheet

view

All the field names and field data are completely displayed in select query Datasheet view.

Some of the field names and field data are completely displayed in select query Datasheet view.

Few of the field names and field data are completely displayed in select query Datasheet view.

An attempt has been made to format Datasheet view.

No attempt to format Datasheet view has been made.

Create a report

A formatted report with grouping and sorting has been created.

A report with grouping and sorting that’s missing for- mats has been created.

A format- ted report with missing grouping and sorting has been created.

Minimal effort has been made to group, sort, and for- mat a report.

No attempt to create a report has been made.

SUBMISSION CHECKLIST

Before submitting your project, make sure you’ve correctly completed the following steps:

q Create, save, and name an Access database.

q Create tables with appropriate field names and corresponding data types.

q Create formatted forms that correspond to tables.

q Use forms to populate a database with records.

q Create a select query using fields from one table.

q Create a select query using fields from multiple related tables.

q Designate query criteria for select query results.

q Designate a sort order for select query results.

q Format select query Datasheet view to completely display field names and field data.

q Create a report.

q Sort and group a report.

q Edit a report format.

SUBMISSION GUIDELINES

Each project is individually graded and therefore could take approximately 5–7 business days to grade.

Follow this procedure to submit your assignment online:

1. Make sure the following information is in the heading of each file:

O Your name

O Your email address

O Your student number

O Course name and number

O Project number (584806)

2. Go to http://www.pennfoster.edu and log in to your student portal.

3. On your student portal, click on Take Exam.

4. In the box provided, enter the examination number. The number for this exam is 584806.

5. Click on Submit.

6. On the next screen, enter your email address. (Note: This information is required for online submission.)

7. If you wish to tell your instructor anything specific regarding this assignment, enter it in the Comments.

8. Attach your file or files as follows:

a. Click on the first Browse box.

b. Locate the file you wish to attach.

c. Double-click on the file.

d. To attach any additional files, click on the next Browse box and repeat steps b and c. Repeat until all files are uploaded.

9. Click on Submit.

Be sure to keep a backup copy of any files you submit to the school!

http://www.pennfoster.edu