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).
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:
Comm Field Description
Unique ID number
assigned to each
and last name
salesperson earns on
sales Data Type
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):
105 Sales_name Comm Naylor, William
Martinez, Phil 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
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:
Name Barnes, Janet
Evans, Jim Customer?s
Phone # (215)774-3826
(610)523-0145 2 Sales Style
ID Number 105
M32861 Sm Med Lg Xlg 2
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
Style: Prepared by: Dan Schaefer
Medium Units Units
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
TEES ARE WE
Billing Report Prepared by: Dan Schaefer Order
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
d. Adjust columns and margins to ensure reports fit on 1 page in Portrait format.
1. Production Scheduling Report
2. Billing Report
3. e-copy of the TRW database submitted on CANVAS
I will be specifically looking for the Salespersons table and the lookups in the data
dictionary and on the Order Form. 4
This question was answered on: Jan 30, 2021
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 .
About this QuestionSTATUS
Jan 30, 2021EXPERT
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).
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.