Reference no: EM13724804
Question 1: Download the ValleProducts.accdb database. Save the file as ValleeProducts_LastNameFirstName.accdb
Question 2: Create a new table named Orders using the table design below. You may create your table in design view or datasheet view. Save the Orders table as Orders Your Name #3.
Question 3: Add the three records listed belowto the Orders table.
Question 4: Define a one-to-many relationship between the Customer table and Orders table. Right click in the window and select Show table. Select the referential integrity option and both cascade options for the relationships. Save the relationship.
Question 5: Create a query based on Customer table that shows CustomerNum, CustomerName, Street, City, and State for all customers in Grand Rapids, South Bend, and Toledo. This will be a List-of-Values query.
Save as #5 Cities YourName. Query results will show 8 records.
Question 6: Create a query based on the Coffee Table that displaysall four fields. Show only those records that do not have the following Coffee Types: African, Blended, and Flavored.
Save as #6Coffee Types YourName. The query results willshow 13 records.
Question 7: Create a query based on the Product Table that shows all Decaf products that have a WeightCode field value of A, or whose Price field value is less than 30. Display all fields from the Product table. Open the Product table and look in design view if you need information about how Decaf is listed there. Remember to indicate Decaf in both rows. Hint: Look in design view of the Product table to see how Decaf is displayed. You must be sure to use the OR operator for A or < 30 which means those two criteria must be on two different rows.
Save the query as #7 Decaf YourName. Your results should show 35 records.
Question 8: Create a new query based on the Product table. Use aggregate functions to find the lowest, average and highest values in the Price field. Name the fields: Lowest Price, Average Price and Highest Price, respectively.
Save the query as #8 Prices YourName. Your results will show one row of results: $7.99 $30.36 $234.00
Question 9: Create a new query based on the Product table. Use aggregate functions to find the lowest, average and highest values in the Price field by WeightCode. Name the fields: Lowest Price, Average Price and Highest Price, respectively.
|
Prepare a ppt to explain your business plan
: Imagine that you are starting a business, and you must prepare a PowerPoint presentation to explain your business plan to potential investors and/or lenders. Develop a 9-12-slide presentation in Microsoft PowerPoint format.
|
|
Describe the approach to research the subject thesis
: One of the requirements for this course is the completion of a five-page Research Paper. The Research Paper is distinguishable from a report by the inclusion of an original thesis. The Research Paper will be at least five pages in length, include at ..
|
|
How would you define intelligence
: How would you define intelligence? Measuring intelligence has been a part of the educational psychology discourse for many years. There are many ways to define and measure the intelligence of a person.
|
|
Create a report displaying the customer records
: Create a report displaying the customer records using multiple tables. Identify the primary keys in the tables you are reporting on, and show the results of your report
|
|
Assignment related to sql programming
: Define a one-to-many relationship between the Customer table and Orders table. Right click in the window and select Show table. Select the referential integrity option and both cascade options for the relationships. Save the relationship.
|
|
What is human resources planning
: In 200 - 250 words, what is Human Resources planning? How does the HR planning process facilitate the achievement of an organization's strategic objectives?
|
|
Compute the elasticities for each independent variable
: Compute the elasticities for each independent variable. Determine the implications for each of the computed elasticities for the business in terms of short-term and long-term pricing strategies. Provide a rationale in which you cite your results.
|
|
Write marketing research paper for adidas
: Write marketing research paper for Adidas. The instructions are attched. Need at least 20 pages. Need citations Plagarism free
|
|
Unfair tactical advantage in union organizing situations
: Do employers have an unfair tactical advantage in union organizing situations? Please support your perspectives reference material.
|