Microsoft Office Tutorials and References
In Depth Information
Guest table records
153 Summer Ave
5003 Wilson Blvd
6509 Great Rd
207 Riverside Dr West
34 Settlers Dr
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 ﬁ 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 ﬁ 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 ﬁ 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 ﬁ 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 ﬁ 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 ﬁ eld so it is slightly wider than the longest entry (either the ﬁ eld name
itself or an entry in the ﬁ eld). Move the text “Page 1 of 1” to the left so it is within the
page area on the report’s ﬁ 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 ﬁ 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 ﬁ elds should now all ﬁ t on the report’s ﬁ 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.