Question Details

(solution) MBA 820 Fall 2015 Lab Assignment #2 - MS ACCESS In Class


So, I have an Info. Management Technology course that's deals with MS ACCESS entry data and all of these software's I've never used. We have an assignment which is Part 2 to the one I've already completed using MS ACCESS. I spend hours and hours on these assignments trying to figure out exactly what and how that my instructor require for these data entries. I really need some assistance on this lab because he gave out the instructions and expects us to figure it out. I am going to attach what I've done so far from the previous assignment as well as what needs to be done for the new lab assignment. 


MBA 820 Fall 2015

 

Lab Assignment #2 ? MS ACCESS

 

In Class Assignment #4, we built a relationship between the Order and Style tables by

 

linking the common field (Style_Num). We can take this concept a step further by

 

creating ?lookups? on the Order form, where we can get a pull down box of all valid

 

styles. In class, you were shown how to go into the Order table?s data dictionary and put

 

in a Lookup for the Style_Num field; we used a combo box for the Display Control (do

 

this now if you didn?t already do so). Any existing or new records being entered to the

 

Order table will be able to pull up all of the valid style numbers from the Style table.

 

(Note: since we created the Order form before defining this relationship, you will

 

need to delete the original Style_Num field from your form and then immediately

 

add it back into your form to activate the lookup function ? do this now if you

 

didn?t already do so).

 

Part 1

 

Suppose that the Tees Are Wee Company wanted to track the number of orders taken by

 

each of their salespeople; as each order is being taken, a unique salesperson ID will be

 

recorded on the Order form. Your job is as follows:

 

1. Create a new table in the TRW database called SALESPERSON, using the

 

following data dictionary:

 

Field Name

 

Sales_ID

 

Sales_name

 

Comm Field Description

 

Unique ID number

 

assigned to each

 

salesperson

 

Salesperson?s first

 

and last name

 

Commission each

 

salesperson earns on

 

sales Data Type

 

Text

 

(Primary

 

Key)

 

Text Field Size

 

3 Input mask

 

N/A 25 N/A Text 2 99% 2. Enter the following sample data for the SALESPERSON table (no need to create

 

a data entry form):

 

Sales_ID 101

 

102

 

103

 

104

 

105 Sales_name Comm Naylor, William

 

Owen, John

 

Garland, Mary

 

Lewis, Barbara

 

Martinez, Phil 12%

 

10%

 

15%

 

12%

 

12% 3. Add a new field to the ORDER table called Sales_ID; this field is now the

 

foreign key linking the Order and Salesperson tables. You will need to create a

 

lookup in the ORDER table data dictionary from the SALESPERSON table.

 

4. Define this link between the two tables by using the RELATIONSHIPS function

 

in the MS-ACCESS ?tools? menu.

 

1 5. Add the new field to the Order form; insert it between the Phone Number and

 

Design Type fields (note the X?s and 9?s showing in the boxes below are for

 

illustration only to show that there will be data in these boxes).

 

TEES ARE WEE ORDERS

 

Order Number xxxxx Units Ordered by Size Date xx/xx/xxxx

 

Small

 

Medium Customer name Xxxxx, Xxxx Phone number xxx Style Number xxxxxx 999 (xxx)xxx-xxxx Sales ID 999 Large 999 Extra large 999 6. Update the original orders with the appropriate Sales ID:

 

Order

 

Number 1001

 

1002

 

1003

 

1004

 

1005

 

1006

 

1007

 

1008

 

1009

 

1010 Order

 

Date 9/28/2013

 

9/28/2013

 

9/28/2013

 

9/28/2013

 

9/28/2013

 

9/29/2013

 

9/29/2013

 

9/29/2013

 

9/29/2013

 

9/30/2013 Customer?s

 

Name Barnes, Janet

 

Jones, Ed

 

Adams, Al

 

Davis, Owen

 

Landes, Larry

 

Morris, Sue

 

Bates, Nancy

 

Thomas, Rob

 

Date, Charles

 

Evans, Jim Customer?s

 

Phone # (215)774-3826

 

(610)525-1834

 

(610)779-8921

 

(215)523-3826

 

(609)775-2913

 

(215)778-8371

 

(302)773-6018

 

(727)526-9205

 

(215)777-9014

 

(610)523-0145 2 Sales Style

 

ID Number 105

 

101

 

101

 

102

 

103

 

101

 

104

 

105

 

104

 

102 M32861

 

Custom

 

R38671

 

M32861

 

Custom

 

P22371

 

Custom

 

P22371

 

R38671

 

M32861 Sm Med Lg Xlg 2

 

0

 

26

 

0

 

10

 

0

 

28

 

0

 

16

 

4 10

 

17

 

14

 

73

 

7

 

8

 

0

 

18

 

11

 

31 8

 

22

 

0

 

44

 

3

 

16

 

0

 

14

 

3

 

11 4

 

14

 

2

 

32

 

0

 

4

 

0

 

7

 

0

 

6 Part 2

 

Using the tables & queries that we created in the Tees Are Wee database, create the

 

following 2 reports using the Report Wizard:

 

Report #1 ? Production Scheduling Report; the data source will be the ORDER table;

 

your report will use the following functions: Sorting, grouping & totaling (sum). Here is

 

an example of what the report should look like:

 

TEES ARE WE

 

Production Scheduling Report

 

Order

 

Number

 

XLarge

 

Style: Prepared by: Dan Schaefer

 

Order

 

Date Customer

 

name Units

 

Small Units

 

Medium Units Units

 

Large Custom

 

1002 5/28/2012 Jones, Ed 0 1005 5/28/2012 Landes, Larry 17 22 10 7 3 Subtotal for Style: xx xx Subtotal for Style xx xx xx Subtotal for Style: Style: xx xx xx xx Subtotal for Style: xx xx xx xxx xxx xxx M32861 Style: P22371 Style: R38671 Total for all Styles: 3 14 Report #2 ? Billing Report; the data source will be a query called Billing. To create this

 

query, copy the existing query ?Order Summary? to a new query called Billing; you must

 

then add 2 new fields to your query called Qty_Ordered & Amt_Billed. These new fields

 

will be created using the expression builder and will be calculated as follows:

 

Qty_Ordred = total of all sizes ordered

 

Amt_Billed = total of all sizes ordered * price

 

Your report will use the following functions: Querying, sorting & totaling (sum). Here is

 

an example:

 

TEES ARE WE

 

Billing Report Prepared by: Dan Schaefer Order

 

Number Customer

 

Name Style

 

Number Style

 

Description Price Quantity

 

Ordered 1001 Barnes, Janet M32861 Mickey Mouse $20.00 24 $480.00 1010 Evans, Jim R38671 Happy Face $15.00 30 $450.00 Total Invoiced: Amount

 

Billed $x,xxx.xx Make sure to do the following for your reports:

 

a. Add the company name and your name to the report using the ?label feature?

 

b. Add subtotals and a data labels where required

 

c. Modify the column headings in the report to remove abbreviations and fix any

 

spacing issues

 

d. Adjust columns and margins to ensure reports fit on 1 page in Portrait format.

 

Deliverables:

 

1. Production Scheduling Report

 

2. Billing Report

 

3. e-copy of the TRW database submitted on CANVAS

 

Final notes:

 

I will be specifically looking for the Salespersons table and the lookups in the data

 

dictionary and on the Order Form. 4

 


Solution details:
STATUS
Answered
QUALITY
Approved
ANSWER RATING

This question was answered on: Jan 30, 2021

PRICE: $15

Solution~0001017573.zip (25.37 KB)

Buy this answer for only: $15

This attachment is locked

We have a ready expert answer for this paper which you can use for in-depth understanding, research editing or paraphrasing. You can buy it or order for a fresh, original and plagiarism-free solution (Deadline assured. Flexible pricing. TurnItIn Report provided)

Pay using PayPal (No PayPal account Required) or your credit card . All your purchases are securely protected by .
SiteLock

About this Question

STATUS

Answered

QUALITY

Approved

DATE ANSWERED

Jan 30, 2021

EXPERT

Tutor

ANSWER RATING

GET INSTANT HELP/h4>

We have top-notch tutors who can do your essay/homework for you at a reasonable cost and then you can simply use that essay as a template to build your own arguments.

You can also use these solutions:

  • As a reference for in-depth understanding of the subject.
  • As a source of ideas / reasoning for your own research (if properly referenced)
  • For editing and paraphrasing (check your institution's definition of plagiarism and recommended paraphrase).
This we believe is a better way of understanding a problem and makes use of the efficiency of time of the student.

NEW ASSIGNMENT HELP?

Order New Solution. Quick Turnaround

Click on the button below in order to Order for a New, Original and High-Quality Essay Solutions. New orders are original solutions and precise to your writing instruction requirements. Place a New Order using the button below.

WE GUARANTEE, THAT YOUR PAPER WILL BE WRITTEN FROM SCRATCH AND WITHIN A DEADLINE.

Order Now