Microsoft Office Tutorials and References
In Depth Information
Case Problems
Figure 1-34
Guest table records
Address
153 Summer Ave
5003 Wilson Blvd
6509 Great Rd
207 Riverside Dr West
34 Settlers Dr
City
Evanston
Chicago
Gary
Windsor
Tinley Park
State/Prov
IL
IL
IN
ON
IL
PostalCode
60201
60603
46401
N9A 5K4
60477
Country
USA
USA
USA
Canada
USA
Phone
847-623-0975
312-897-4515
219-655-8109
519-977-8577
708-292-4441
GuestID
201
203
206
202
205
GuestFirst
Student First
Tom
Li
Ingrid
Richard
GuestLast
Student Last
Davis
Zhu
Gorman
Nelson
5. Emma created a database named Travel that contains a Client table with data
about guests. The Guest table you created has the same design as the Client table.
Copy all the records from the Client table in the Travel database (located in the
Access1\Case4 folder provided with your Data Files) and paste them at the end of
the Guest table in the GEM database.
6. Resize columns in the datasheet, as necessary, so that all the fi eld values are
completely displayed, and then save the Guest table.
7. Close the Guest table, and then use the Navigation Pane to reopen it. Note that the
records are displayed in primary key order.
8. Use the Simple Query Wizard to create a query that includes the following fi elds
from the Guest table, in the order shown: GuestID, GuestLast, GuestFirst, City, and
Phone. Name the query GuestData .
9. The query results are displayed in order by the GuestID fi eld values. You can specify
a different order by sorting the query. Display the Home tab. Then, click the insertion
point anywhere in the GuestLast column to make it the current fi eld. In the Sort &
Filter group on the Home tab, click the Ascending button. The records are now listed
in order by the values in the GuestLast fi eld. Save and close the query.
10. Use the Form tool to create a form for the Guest table. In the new form, navigate to
record 12, and then print the form for the current record only . ( Hint : You must use
the Print dialog box in order to print only the current record. Go to Backstage view,
click the Print command, and then click Print to open the Print dialog box. Click the
Selected Record(s) option button and then click the OK button to print the current
record.) Save the form as GuestInfo , and then close it.
11. Use the Report tool to create a report based on the Guest table. In Layout view,
resize each fi eld so it is slightly wider than the longest entry (either the fi eld name
itself or an entry in the fi eld). Move the text “Page 1 of 1” to the left so it is within the
page area on the report’s fi rst page. Also, resize the box containing the total amount
that appears below the GuestID column so that the amount is completely displayed.
Display the report in Print Preview and notice that the columns of the report are
spread across two pages. Save the report as GuestList .
12. In the Close Preview group, click the Close Print Preview button to return to the
report in Layout view. To make more room on the fi rst page, you’ll delete the
Address, PostalCode, and Country columns from the report. Click anywhere in the
Address column to make it active. Click the Report Layout Tools Arrange tab, and
then click the Select Column button in the Rows & Columns group. Click the Home
tab, and then click the Delete button in the Records group to delete the selected
column. Repeat this process to delete the PostalCode and Country columns. The
remaining six fi elds should now all fi t on the report’s fi rst page.
13. Save the report, print it (only if asked by your instructor to do so), and then close it.
14. Close the Guest table, and then compact and repair the GEM database.
15. Close the GEM database.
 
Search JabSto ::




Custom Search