Reference no: EM132098209
1. Create a query that shows the Country, City, CustomerID, and Customer CompanyName for all customers located in France, Spain, or Sweden. Sort the queryby Country, then CompanyName.
2. Create a query that shows the ProductID, ProductName, and UnitPrice for all products with a UnitPrice greater than $50. Sort the query in descending order of UnitPrice.
3. Create a query that shows the CategoryName, ProductID, ProductName, and UnitPrice for all products in the Produce or Seafood categories. Sort the queryin order of CategoryName, then ProductName.
4. Create a query that shows the Supplier CompanyName, CategoryName, ProductID, and ProductName for all products in the Produce or Seafood categories.Sort the query in order of Supplier CompanyName, then CategoryName, then ProductName.
5. Create a query that shows the OrderID, OrderDate, Customer CompanyName, and Country for all orders placed by customers in the United Kingdom. Sort thequery by CompanyName.
6. Create a query that shows the OrderID, OrderDate, Customer CompanyName, ProductName, Quantity, and UnitPrice for all products included in the order. UseUnitPrice from the Order Details table (not the Products table). Only show orders from the companies named “Lonesome Pine Restaurant” or “RattlesnakeCanyon Grocery.” Sort the query by OrderDate, then CompanyName.
7. Create a form that will let you enter data for all fields included in the Customers table.
8. Create a form that shows the CategoryID, CategoryName, and Description for each category, along with the ProductID, ProductName, and UnitPrice for allproducts in that category. The form should have Category in the main form and Products in the subform.
9. Create a well-formatted report that shows the data from the query in Activity #2.
10. Create a well-formatted report that shows the Supplier’s CompanyName, CategoryName, ProductName, and UnitPrice for all products.
11. Create a well-formatted report that shows the data from the query in Activity #6.
What is the eec would be willing to pay for the supplier
: What would be the least amount of savings that would make this investment attractive to EEC? Given this scenario, what is the most EEC would be willing to pay.
|
Discuss about the strategies for communication
: Research and share some strategies that teachers and administrators can implement to facilitate and enhance increased communication.
|
How the strategy meets corporate objectives
: If it is a new one discuss the challenges and obstacles and how the strategy meets corporate objectives.
|
What do you think about the debate and what is your position
: What do you think about the debate and what is your position? Why do you believe your position is sustainable or defensible?
|
Create a query that shows the country-city-customerid
: Create a query that shows the Country, City, CustomerID, and Customer CompanyName for all customers located in France, Spain, or Sweden.
|
Analyze your global business enterprise
: Assess the country's recent economic conditions related to GDP, inflation, interest rates, currency value, personal income, and employment.
|
What are the ethical considerations in the given case
: Imagine you are the assistant controller in charge of general ledger accounting at Linbarger Company. Your company has a large loan from an insurance company.
|
Identify the tool that will be used to measure mastery
: Create a summative assessment that appraises mastery of the Common Core State Standard and the Unit Objective.
|
How changes in physical development affect
: The effect of early and late onset of puberty on adolescent physical development and social/emotional relationships with peers.
|