The following hints and tips will help you avoid problems while working through the Access tutorial sessions in the textbook:
Before beginning the tutorial session, copy the contents of this College of Business network folder to the root directory of drive D (your zip disk):
L:\BTC\JON HUHTALA\DATABASE\Data Files
Pages AC1.08 - AC109 (#3 - #7) - To open the database for this session, browse as follows:
- drive D (your zip drive)
- the Data Files folder
- the Tutorial.01 folder
- the Tutorial folder
- the Seasonal database
Page AC1.14 (#1 - #4) - Be sure to open the Seasonal database in the Tutorial folder of the Tutorial.01 folder of the Data Files folder of your zip disk.
Page AC2.08 (#3 - #6) - Be sure to specify a database name of Northeast and create it in the Tutorial folder of the Tutorial.01 folder of the Data Files folder of your zip disk.
Page AC2.30 (#5) - The NEJobs database is in the Tutorial folder of the Tutorial.01 folder of the Data Files folder of your zip disk.
Page AC3.03 (#2) - Open the Northeast database in the Tutorial folder of the Tutorial.01 folder of the Data Files folder of your zip disk.
Page AC3.20 (#1 and #2) - Because of the data type of the StartDate field, these steps will NOT work as expected and may be skipped.
Page AC3.24 (#1) - The criteria of 7/01 will NOT work. Use the criteria of 7/01/2001 instead.
Page AC3.30 (#2) - Select the StartDate criteria value of #7/01/2001#.
Page AC3.33 (#10) - Be careful not to skip this step.
Page AC4.12 (#6 and #7) - Be careful here or you may end up printing ALL the records in the table. To save paper, I suggest you skip printing altogether.
This tutorial requires you to follow instructions carefully. It also requires precise mouse movements that you may find difficult and frustrating. You will find the "undo" toolbar button useful in backing-out errors.
Page AC4.33 (#1 - #4) - You may skip printing but should know how to print.
Page AC5.04 (#1 and #2) - Be sure to open the Jobs database in the Tutorial folder of the Tutorial.05 folder of the Data Files folder of your zip disk.
Page AC5.10 (#3) - You must scroll right (NOT left) to see the Phone field.
Page AC5.18 (#5 at top of page) - View query results but skip printing.
Page AC5.18 (#2 at bottom of page) - You must spell the criteria expression EXACTLY as specified.
Page AC5.19 (#7 at top of page) - View query results but skip printing.
Page AC5.19 (#3 at bottom of page) - You must spell the criteria expression EXACTLY as specified.
Page AC5.20 (#6) - You may need to select View and Refresh from the menu in order to see the list of queries.
This tutorial requires you to follow instructions carefully. It also requires precise mouse movements that you may find difficult and frustrating. You will find the "undo" toolbar button useful in backing-out errors.
Page AC5.36 (#2) - You may need to expand the View menu downward to see this menu choice.
Page AC5.40 (#5) - You may need to browse to the Tutorial folder of the Tutorial.05 folder of the Data Files folder of your zip disk to locate the specified picture file.
This tutorial requires you to follow instructions carefully. It also requires precise mouse movements that you may find difficult and frustrating. You will find the "undo" toolbar button useful in backing-out errors.
Page AC5.43 (#2) - After placing the tab control into the detail section, the tabs will display as "Page 8" and "Page 9" rather than "Page 13" and "Page 14" as shown by figure 5-41 in the book. The difference is irrelevant.
Page AC5.54 (#4) - The "Or" tab is in the extreme bottom-left corner of the window next to the "Look for" tab.
Page AC6.08 (#3) - Be careful NOT to delete the word "Openings" when inserting the label "TotalOpenings:" in front of it.
Page AC6.09 (#5) - Enter the expression EXACTLY as specified. Watch out for spelling mistakes.
Page AC6.35 (#8) - If you are asked to save changes when closing the window, click "Yes".
Page AC6.46 (#8) - Your orphaned group header may be on a different page of the report than that shown in the book. Use the navigation buttons to find it.
Page AC6.49 (#2) - The Seaview Restaurant information may be on a different page of the report than that shown in the book. Use the navigation buttons to find it.
Page AC6.56 (#7) - You may need to browse to the Tutorial folder of the Tutorial.05 folder of the Data Files folder of your zip disk to locate the specified picture file.
Page AC7.15 (#2) - Click the "OK" button WITHOUT specifying "Table" or "Query".
This tutorial requires you to follow instructions carefully. You will probably find it both challenging and frustrating as you learn to work with pivot table and pivot chart data analysis tools.
Page AC7.34 (#3 at top of page) - The PivotTable title bar is the blue bar that says "Microsoft Office PivotTable 10.0"
Page AC7.34 (#1 at bottom of page) - If you don't get the shortcut menu to appear using the technique specified in the book, click ONCE on any "Openings" column heading, click AGAIN on that same heading, then RIGHT-CLICK.
Page AC7.42 (#2) - The y-axis scale numbers will change as you drag the sizing handle.
Page AC7.42 (#3) - Make sure you click the "Field List" button on the PivotChart toolbar and NOT the "Field List" button on the main toolbar. There will be two of them on the screen. You must pick the one that is lower on the screen.
Page AC7.42 (#5) - Drag the Experience field from the field list to the spot on the screen that says "Drop Series Fields Here". Drag the Openings field from the field list to the spot on the screen that says "Drop Data Fields Here".
Several import and export operations are performed in this tutorial. All such operations should use the Tutorial folder of the Tutorial.05 folder of the Data Files folder of your zip disk.
Page AC8.06 (#1 and #2) - Be sure to open the Jobs database in the Tutorial folder of the Tutorial.08 folder of the Data Files folder of your zip disk.
Page AC8.10 (#7) - View, but do NOT print, the query recordset.
Page AC8.12 (#8) - View, but do NOT print, the query recordset.
Page AC8.15 (#4) - View, but do NOT print, the query recordset.
Page AC8.30 (#7) - If the "Apply Filter" button isn't visible, the Filter/Sort toolbar be hidden. Select View from the main menu and Toolbars from the pop-up submenu. Choose Filter/Sort to display the missing toolbar.
Page AC8.37 (#8) - Connect the "one" side of the relationship to the "many" side of the relationship. In other words, drag from the "one" side to the "many" side.
Page AC8.52 (#4) - The direction of the drag is critical. Do it EXACTLY as specified in the book.
Page AC8.54 (#6) - View, but do NOT print, the query recordset.
No identified trouble spots.
This tutorial can be tricky. Read carefully and follow directions.
Page AC9.30 (#3) - SQL (pronounced "sequel") is a text-oriented language used to view and manipulate data in any relational database.
Page AC9.33 (#3) - Type carefully. The statement must be EXACTLY as specified in the book.
Page AC9.38 (#3) - Nothing will happen because the command button actions have yet to be defined.
No identified trouble spots.