Microsoft Office Tutorials and References
In Depth Information
Learn It Online
Test your knowledge of chapter content and key terms.
Instructions: To complete the Learn It Online exercises, start your browser, click the Address bar, and
then enter the Web address scsite.com/ac2007/learn . When the Access 2007 Learn It Online
page is displayed, click the link for the exercise you want to complete and then read the instructions.
Chapter Reinforcement TF, MC, and SA
A series of true/false, multiple choice, and short
answer questions that test your knowledge of the
chapter content.
Who Wants To Be a Computer Genius?
An interactive game that challenges your
knowledge of chapter content in the style of a
television quiz show.
Flash Cards
An interactive learning environment where
you identify chapter key terms associated with
displayed defi nitions.
Wheel of Terms
An interactive game that challenges your
knowledge of chapter key terms in the style of the
television show Wheel of Fortune .
Practice Test
A series of multiple choice questions that test your
knowledge of chapter content and key terms.
Crossword Puzzle Challenge
A crossword puzzle that challenges your
knowledge of key terms presented in the chapter.
Apply Your Knowledge
Reinforce the skills and apply the concepts you learned in this chapter.
Using the Query Wizard, Creating a Parameter Query, Joining Tables, and Creating a Report
Instructions: Start Access. Open the The Bike Delivers database that you modifi ed in Apply Your
Knowledge in Chapter 1 on page AC 64. (If you did not complete this exercise, see your instructor for
a copy of the modifi ed database.)
Perform the following tasks:
1. Use the Simple Query Wizard to create a query for the Customer table. Include the Customer
Name, Balance, and Courier Number in the query. Assign the name, Customer Query, to the query.
2. Create a query for the Customer table and add the Customer Number, Customer Name, Courier
Number, and Balance fi elds to the design grid. Sort the records in descending order by Balance.
Add a criterion for the Courier Number fi eld that allows the user to enter a different courier each
time the query is run. Save the query as Courier Parameter Query.
3. Create a query that joins the Courier and the Customer tables. Add the Courier Number, First
Name, and Last Name fi elds from the Courier table and the Customer Number and Customer
Name fi elds from the Customer table. Sort the records in ascending order by Courier Number
and Customer Number. All couriers should appear in the result even if they currently have no
customers. Save the query as Courier-Customer Query.
4. Create the report shown in Figure 2–84. The report uses the Courier-Customer Query.
 
Search JabSto ::




Custom Search