Essay on Customer Service and Query

816 Words Mar 28th, 2012 4 Pages
-------------------------------------------------

-------------------------------------------------

-------------------------------------------------
Shelly Cashman access 2010
-------------------------------------------------
Chapter 2: Lab 1
Querying the eco clothesline database
Skills
Save a database with a new filename
Create a query in Design view
Use text criteria in a query
Use comparison operators in a query
Use wildcards in a query
Sort data in a query
Omit duplicates from a query
Create and run a parameter query
Create a top-values query
Join tables in a query
Sort a query on multiple fields in Design view
Change join properties
Add a calculated field to a query
Create a caption for a field
Use an
…show more content…
Create a query for the Customer table that includes the Customer Number, Customer Name, Street, and City fields for all customers whose names begin with “T”. Save the query as Lab 2-1 Query 3. (See figure below)

5. Create a query for the Customer table that lists all cities in descending order. Each city should appear only once. Save the query as Lab 2-1 Query 4. (See figure below)

6. Create a query for the Customer table that prompts the user with the text Enter City to allow the user to enter the city for which to search when the query is run. The query results should display the Customer Number, Customer Name, Balance, and Amount Paid fields for all customers in that city. Test the query by searching for those records where the Customer is located in Ashton. Save the query as Lab 2-1 Query 5. (See figure below)

7. Create a query for the Customer table that includes the Customer Number, Customer Name, and Balance fields. Sort the records in descending order by the Balance field. Display only the top 25% of the records in the query result. Save the query as Lab 2-1 Query 6. (See figure below)

8. Create a query that joins the Sales Rep and the Customer tables. Include the Sales Rep Number, First Name, and Last Name fields from the Sales Rep table. Include the Customer Number, Customer Name, and Balance fields from the Customer table. Sort the records in ascending order by sales rep’s last name and customer name. Modify the query so that

Related Documents