Project #67560 - using word, excel, and access

In the project;

·      Decide on a business (real or fictitious) to use as the subject matter for the project

·      Utilize Excel to create a workbook containing the business’ data

·      Utilize Access to create a database using the Excel data

o   Will need to create the data in Excel and import the worksheets into Access as tables to use for your database

·     

Ideas for businesses which can be used for the subject matter include (but are not limited to):

 

·      Pet store

·      Ski resort

·      Accounting services

·      Computer services

·      Medical clinic

·      Lawn care service

·      Fantasy sports league

·      Child’s sports league

·      Library (print or digital)

·      Restaurant

·      Hair salon

·      Housecleaning service

 

 

 

Grading rubric

 

Excel Spreadsheets

Creation of 1 workbook containing a minimum of 4 spreadsheets with data (minimum 50 data fields)

8

 

Tabs for each spreadsheet are appropriately named

2

 

Column headings are bolded

2

 

Data displays appropriately in all cells

2

 

Cells are formatted appropriately (text, number, currency, etc.)

5

 

1 meaningful PivotTable

4

 

1 meaningful PivotChart

4

 

 

Access Database

All spreadsheets from Excel workbook imported as tables

4

 

            No redundant data in tables

2

 

Primary keys set for each table

4

 

Foreign keys added to appropriate tables

3

 

Relationships created and referential integrity enforced appropriately

2

 

4 meaningful queries to summarize data from tables

8

 

2 meaningful reports

4

 

            Color and font the same for all reports

2

 

            Data display appropriately (currency has dollar sign,            decimals, etc.)

2

 

 

Formulas

Four formulas in Excel, Access or a combination of the two

4

 

Four formulas are used correctly

4

 

 

i have few examples i can show you, i am willing to pay starting at $100 and willing to more after i confirm the work

 

Subject Computer
Due By (Pacific Time) 04/29/2015 11:59 pm
Report DMCA
TutorRating
pallavi

Chat Now!

out of 1971 reviews
More..
amosmm

Chat Now!

out of 766 reviews
More..
PhyzKyd

Chat Now!

out of 1164 reviews
More..
rajdeep77

Chat Now!

out of 721 reviews
More..
sctys

Chat Now!

out of 1600 reviews
More..
sharadgreen

Chat Now!

out of 770 reviews
More..
topnotcher

Chat Now!

out of 766 reviews
More..
XXXIAO

Chat Now!

out of 680 reviews
More..
All Rights Reserved. Copyright by AceMyHW.com - Copyright Policy