Essay Available:
You are here: Home → Essay → Technology
Pages:
38 pages/≈10450 words
Sources:
Level:
MLA
Subject:
Technology
Type:
Essay
Language:
English (U.S.)
Document:
MS Word
Date:
Total cost:
$ 39.95
Topic:
Microsoft Access Assignment (Essay Sample)
Instructions:
The paper involved manipulating databases using Microsoft Access. It was in MLA format and double-spaced.
source..Content:
Student’s Name
Professor’s Name
Course Code
Date
Microsoft Access Assignment
Question 1
I created relationships between all the related fields in the six tables.
Question 2
The information obtained from the query is as follows:
Products Query
ProductName
CompanyName
Quantity
Discount
ShippedDate
Sir Rodney's Scones
Specialty Biscuits, Ltd.
40
15.00%
1/16/2013
Sir Rodney's Scones
Specialty Biscuits, Ltd.
40
25.00%
1/19/2013
Nord-Ost Matjeshering
Nord-Ost-Fisch Handelsgesellschaft mbH
28
25.00%
1/19/2013
Pâté chinois
Ma Maison
60
25.00%
1/19/2013
Gnocchi di nonna Alice
Pasta Buttini s.r.l.
30
20.00%
1/23/2013
Pâté chinois
Ma Maison
30
15.00%
1/27/2013
Chef Anton's Cajun Seasoning
New Orleans Cajun Delights
30
25.00%
1/28/2013
Geitost
Norske Meierier
40
25.00%
1/28/2013
Question Three
The information obtained from the query is as follows:
Second Query
Company Name
Contact Name
ProductName
UnitPrice
ProductCost
OrderDate
Freight
Tradição Hipermercados
Anabela Domingues
Uncle Bob's Organic Dried Pears
$30.00
$22.50
4/28/2012
$76.10
Tradição Hipermercados
Anabela Domingues
Northwoods Cranberry Sauce
$40.00
$28.75
4/28/2012
$76.10
Tradição Hipermercados
Anabela Domingues
Mishi Kobe Niku
$97.00
$65.00
4/28/2012
$76.10
Tradição Hipermercados
Anabela Domingues
Ikura
$31.00
$30.00
4/28/2012
$76.10
Tradição Hipermercados
Anabela Domingues
Queso Manchego La Pastora
$38.00
$22.75
4/28/2012
$76.10
Tradição Hipermercados
Anabela Domingues
Alice Mutton
$39.00
$20.70
4/28/2012
$76.10
Tradição Hipermercados
Anabela Domingues
Carnarvon Tigers
$62.50
$48.75
4/28/2012
$76.10
Tradição Hipermercados
Anabela Domingues
Sir Rodney's Marmalade
$81.00
$58.80
4/28/2012
$76.10
Tradição Hipermercados
Anabela Domingues
Gumbär Gummibärchen
$31.23
$22.80
4/28/2012
$76.10
Tradição Hipermercados
Anabela Domingues
Schoggi Schokolade
$43.90
$22.89
4/28/2012
$76.10
Tradição Hipermercados
Anabela Domingues
Rössle Sauerkraut
$45.60
$32.50
4/28/2012
$76.10
Tradição Hipermercados
Anabela Domingues
Thüringer Rostbratwurst
$123.79
$82.50
4/28/2012
$76.10
Tradição Hipermercados
Anabela Domingues
Nord-Ost Matjeshering
$25.89
$12.20
4/28/2012
$76.10
Tradição Hipermercados
Anabela Domingues
Mascarpone Fabioli
$32.00
$14.40
4/28/2012
$76.10
Tradição Hipermercados
Anabela Domingues
Gravad lax
$26.00
$25.51
4/28/2012
$76.10
Tradição Hipermercados
Anabela Domingues
Côte de Blaye
$263.50
$263.01
4/28/2012
$76.10
Tradição Hipermercados
Anabela Domingues
Ipoh Coffee
$46.00
$45.51
4/28/2012
$76.10
Tradição Hipermercados
Anabela Domingues
Manjimup Dried Apples
$53.00
$52.51
4/28/2012
$76.10
Tradição Hipermercados
Anabela Domingues
Perth Pasties
$32.80
$32.31
4/28/2012
$76.10
Tradição Hipermercados
Anabela Domingues
Gnocchi di nonna Alice
$38.00
$37.51
4/28/2012
$76.10
Tradição Hipermercados
Anabela Domingues
Raclette Courdavault
$55.00
$54.51
4/28/2012
$76.10
Tradição Hipermercados
Anabela Domingues
Camembert Pierrot
$34.00
$33.51
4/28/2012
$76.10
Tradição Hipermercados
Anabela Domingues
Sirop d'érable
$28.50
$28.01
4/28/2012
$76.10
Tradição Hipermercados
Anabela Domingues
Tarte au sucre
$49.30
$48.81
4/28/2012
$76.10
Tradição Hipermercados
Anabela Domingues
Vegie-spread
$43.90
$43.41
4/28/2012
$76.10
Tradição Hipermercados
Anabela Domingues
Wimmers gute Semmelknödel
$33.25
$32.76
4/28/2012
$76.10
Tradição Hipermercados
Anabela Domingues
Gudbrandsdalsost
$36.00
$35.51
4/28/2012
$76.10
Tradição Hipermercados
Anabela Domingues
Mozzarella di Giovanni
$34.80
$34.31
4/28/2012
$76.10
Victuailles en stock
Mary Saveley
Uncle Bob's Organic Dried Pears
$30.00
$22.50
5/1/2012
$53.05
Victuailles en stock
Mary Saveley
Northwoods Cranberry Sauce
$40.00
$28.75
5/1/2012
$53.05
Victuailles en stock
Mary Saveley
Mishi Kobe Niku
$97.00
$65.00
5/1/2012
$53.05
Victuailles en stock
Mary Saveley
Ikura
$31.00
$30.00
5/1/2012
$53.05
Victuailles en stock
Mary Saveley
Queso Manchego La Pastora
$38.00
$22.75
5/1/2012
$53.05
Victuailles en stock
Mary Saveley
Alice Mutton
$39.00
$20.70
5/1/2012
$53.05
Victuailles en stock
Mary Saveley
Carnarvon Tigers
$62.50
$48.75
5/1/2012
$53.05
Victuailles en stock
Mary Saveley
Sir Rodney's Marmalade
$81.00
$58.80
5/1/2012
$53.05
Victuailles en stock
Mary Saveley
Gumbär Gummibärchen
$31.23
$22.80
5/1/2012
$53.05
Victuailles en stock
Mary Saveley
Schoggi Schokolade
$43.90
$22.89
5/1/2012
$53.05
Victuailles en stock
Mary Saveley
Rössle Sauerkraut
$45.60
$32.50
5/1/2012
$53.05
Victuailles en stock
Mary Saveley
Thüringer Rostbratwurst
$123.79
$82.50
5/1/2012
$53.05
Victuailles en stock
Mary Saveley
Nord-Ost Matjeshering
$25.89
$12.20
5/1/2012
$53.05
Victuailles en stock
Mary Saveley
Mascarpone Fabioli
$32.00
$14.40
5/1/2012
$53.05
Victuailles en stock
Mary Saveley
Gravad lax
$26.00
$25.51
5/1/2012
$53.05
Victuailles en stock
Mary Saveley
Côte de Blaye
$263.50
$263.01
5/1/2012
$53.05
Victuailles en stock
Mary Saveley
Ipoh Coffee
$46.00
$45.51
5/1/2012
$53.05
Victuailles en stock
Mary Saveley
Manjimup Dried Apples
$53.00
$52.51
5/1/2012
$53.05
Victuailles en stock
Mary Saveley
Perth Pasties
$32.80
$32.31
5/1/2012
$53.05
Victuailles en stock
Mary Saveley
Gnocchi di nonna Alice
$38.00
$37.51
5/1/2012
$53.05
Victuailles en stock
Mary Saveley
Raclette Courdavault
$55.00
$54.51
5/1/2012
$53.05
Victuailles en stock
Mary Saveley
Camembert Pierrot
$34.00
$33.51
5/1/2012
$53.05
Victuailles en stock
Mary Saveley
Sirop d'érable
$28.50
$28.01
5/1/2012
$53.05
Victuailles en stock
Mary Saveley
Tarte au sucre
$49.30
$48.81
5/1/2012
$53.05
Victuailles en stock
Mary Saveley
Vegie-spread
$43.90
$43.41
5/1/2012
$53.05
Victuailles en stock
Mary Saveley
Wimmers gute Semmelknödel
$33.25
$32.76
5/1/2012
$53.05
Victuailles en stock
Mary Saveley
Gudbrandsdalsost
$36.00
$35.51
5/1/2012
$53.05
Victuailles en stock
Mary Saveley
Mozzarella di Giovanni
$34.80
$34.31
5/1/2012
$53.05
Suprêmes délices
Pascale Cartrain
Uncle Bob's Organic Dried Pears
$30.00
$22.50
5/2/2012
$97.09
Suprêmes dé...
Professor’s Name
Course Code
Date
Microsoft Access Assignment
Question 1
I created relationships between all the related fields in the six tables.
Question 2
The information obtained from the query is as follows:
Products Query
ProductName
CompanyName
Quantity
Discount
ShippedDate
Sir Rodney's Scones
Specialty Biscuits, Ltd.
40
15.00%
1/16/2013
Sir Rodney's Scones
Specialty Biscuits, Ltd.
40
25.00%
1/19/2013
Nord-Ost Matjeshering
Nord-Ost-Fisch Handelsgesellschaft mbH
28
25.00%
1/19/2013
Pâté chinois
Ma Maison
60
25.00%
1/19/2013
Gnocchi di nonna Alice
Pasta Buttini s.r.l.
30
20.00%
1/23/2013
Pâté chinois
Ma Maison
30
15.00%
1/27/2013
Chef Anton's Cajun Seasoning
New Orleans Cajun Delights
30
25.00%
1/28/2013
Geitost
Norske Meierier
40
25.00%
1/28/2013
Question Three
The information obtained from the query is as follows:
Second Query
Company Name
Contact Name
ProductName
UnitPrice
ProductCost
OrderDate
Freight
Tradição Hipermercados
Anabela Domingues
Uncle Bob's Organic Dried Pears
$30.00
$22.50
4/28/2012
$76.10
Tradição Hipermercados
Anabela Domingues
Northwoods Cranberry Sauce
$40.00
$28.75
4/28/2012
$76.10
Tradição Hipermercados
Anabela Domingues
Mishi Kobe Niku
$97.00
$65.00
4/28/2012
$76.10
Tradição Hipermercados
Anabela Domingues
Ikura
$31.00
$30.00
4/28/2012
$76.10
Tradição Hipermercados
Anabela Domingues
Queso Manchego La Pastora
$38.00
$22.75
4/28/2012
$76.10
Tradição Hipermercados
Anabela Domingues
Alice Mutton
$39.00
$20.70
4/28/2012
$76.10
Tradição Hipermercados
Anabela Domingues
Carnarvon Tigers
$62.50
$48.75
4/28/2012
$76.10
Tradição Hipermercados
Anabela Domingues
Sir Rodney's Marmalade
$81.00
$58.80
4/28/2012
$76.10
Tradição Hipermercados
Anabela Domingues
Gumbär Gummibärchen
$31.23
$22.80
4/28/2012
$76.10
Tradição Hipermercados
Anabela Domingues
Schoggi Schokolade
$43.90
$22.89
4/28/2012
$76.10
Tradição Hipermercados
Anabela Domingues
Rössle Sauerkraut
$45.60
$32.50
4/28/2012
$76.10
Tradição Hipermercados
Anabela Domingues
Thüringer Rostbratwurst
$123.79
$82.50
4/28/2012
$76.10
Tradição Hipermercados
Anabela Domingues
Nord-Ost Matjeshering
$25.89
$12.20
4/28/2012
$76.10
Tradição Hipermercados
Anabela Domingues
Mascarpone Fabioli
$32.00
$14.40
4/28/2012
$76.10
Tradição Hipermercados
Anabela Domingues
Gravad lax
$26.00
$25.51
4/28/2012
$76.10
Tradição Hipermercados
Anabela Domingues
Côte de Blaye
$263.50
$263.01
4/28/2012
$76.10
Tradição Hipermercados
Anabela Domingues
Ipoh Coffee
$46.00
$45.51
4/28/2012
$76.10
Tradição Hipermercados
Anabela Domingues
Manjimup Dried Apples
$53.00
$52.51
4/28/2012
$76.10
Tradição Hipermercados
Anabela Domingues
Perth Pasties
$32.80
$32.31
4/28/2012
$76.10
Tradição Hipermercados
Anabela Domingues
Gnocchi di nonna Alice
$38.00
$37.51
4/28/2012
$76.10
Tradição Hipermercados
Anabela Domingues
Raclette Courdavault
$55.00
$54.51
4/28/2012
$76.10
Tradição Hipermercados
Anabela Domingues
Camembert Pierrot
$34.00
$33.51
4/28/2012
$76.10
Tradição Hipermercados
Anabela Domingues
Sirop d'érable
$28.50
$28.01
4/28/2012
$76.10
Tradição Hipermercados
Anabela Domingues
Tarte au sucre
$49.30
$48.81
4/28/2012
$76.10
Tradição Hipermercados
Anabela Domingues
Vegie-spread
$43.90
$43.41
4/28/2012
$76.10
Tradição Hipermercados
Anabela Domingues
Wimmers gute Semmelknödel
$33.25
$32.76
4/28/2012
$76.10
Tradição Hipermercados
Anabela Domingues
Gudbrandsdalsost
$36.00
$35.51
4/28/2012
$76.10
Tradição Hipermercados
Anabela Domingues
Mozzarella di Giovanni
$34.80
$34.31
4/28/2012
$76.10
Victuailles en stock
Mary Saveley
Uncle Bob's Organic Dried Pears
$30.00
$22.50
5/1/2012
$53.05
Victuailles en stock
Mary Saveley
Northwoods Cranberry Sauce
$40.00
$28.75
5/1/2012
$53.05
Victuailles en stock
Mary Saveley
Mishi Kobe Niku
$97.00
$65.00
5/1/2012
$53.05
Victuailles en stock
Mary Saveley
Ikura
$31.00
$30.00
5/1/2012
$53.05
Victuailles en stock
Mary Saveley
Queso Manchego La Pastora
$38.00
$22.75
5/1/2012
$53.05
Victuailles en stock
Mary Saveley
Alice Mutton
$39.00
$20.70
5/1/2012
$53.05
Victuailles en stock
Mary Saveley
Carnarvon Tigers
$62.50
$48.75
5/1/2012
$53.05
Victuailles en stock
Mary Saveley
Sir Rodney's Marmalade
$81.00
$58.80
5/1/2012
$53.05
Victuailles en stock
Mary Saveley
Gumbär Gummibärchen
$31.23
$22.80
5/1/2012
$53.05
Victuailles en stock
Mary Saveley
Schoggi Schokolade
$43.90
$22.89
5/1/2012
$53.05
Victuailles en stock
Mary Saveley
Rössle Sauerkraut
$45.60
$32.50
5/1/2012
$53.05
Victuailles en stock
Mary Saveley
Thüringer Rostbratwurst
$123.79
$82.50
5/1/2012
$53.05
Victuailles en stock
Mary Saveley
Nord-Ost Matjeshering
$25.89
$12.20
5/1/2012
$53.05
Victuailles en stock
Mary Saveley
Mascarpone Fabioli
$32.00
$14.40
5/1/2012
$53.05
Victuailles en stock
Mary Saveley
Gravad lax
$26.00
$25.51
5/1/2012
$53.05
Victuailles en stock
Mary Saveley
Côte de Blaye
$263.50
$263.01
5/1/2012
$53.05
Victuailles en stock
Mary Saveley
Ipoh Coffee
$46.00
$45.51
5/1/2012
$53.05
Victuailles en stock
Mary Saveley
Manjimup Dried Apples
$53.00
$52.51
5/1/2012
$53.05
Victuailles en stock
Mary Saveley
Perth Pasties
$32.80
$32.31
5/1/2012
$53.05
Victuailles en stock
Mary Saveley
Gnocchi di nonna Alice
$38.00
$37.51
5/1/2012
$53.05
Victuailles en stock
Mary Saveley
Raclette Courdavault
$55.00
$54.51
5/1/2012
$53.05
Victuailles en stock
Mary Saveley
Camembert Pierrot
$34.00
$33.51
5/1/2012
$53.05
Victuailles en stock
Mary Saveley
Sirop d'érable
$28.50
$28.01
5/1/2012
$53.05
Victuailles en stock
Mary Saveley
Tarte au sucre
$49.30
$48.81
5/1/2012
$53.05
Victuailles en stock
Mary Saveley
Vegie-spread
$43.90
$43.41
5/1/2012
$53.05
Victuailles en stock
Mary Saveley
Wimmers gute Semmelknödel
$33.25
$32.76
5/1/2012
$53.05
Victuailles en stock
Mary Saveley
Gudbrandsdalsost
$36.00
$35.51
5/1/2012
$53.05
Victuailles en stock
Mary Saveley
Mozzarella di Giovanni
$34.80
$34.31
5/1/2012
$53.05
Suprêmes délices
Pascale Cartrain
Uncle Bob's Organic Dried Pears
$30.00
$22.50
5/2/2012
$97.09
Suprêmes dé...
Get the Whole Paper!
Not exactly what you need?
Do you need a custom essay? Order right now:
Other Topics:
- Programming: Binary CodingDescription: Creating an FPGA design is easier than creating a microprocessor design...1 page/≈275 words| MLA | Technology | Essay |
- Intrusion Detection Systems Description: Intrusion detection systems (IDS) are software application that inspects inbound and outbound network activity for suspicious activities that may show a security breach...2 pages/≈550 words| MLA | Technology | Essay |
- How Does Internet Influence Society NowadaysDescription: Founded over five decades ago and gained super recognition in the late 1990's, the internet is now the greatest human discovery...2 pages/≈550 words| MLA | Technology | Essay |
