Microsoft office for Mac
Kingin757
customerlistlayout.ppsxCustomer List layout
Dr. Gjestland
Click to continue
Slide ‹#› of 22
Customer List layout
These instructions supplement the steps in the tutorial for Activity 9.4 on pages 156 - 157.
These instructions will ask you to do a couple more things than the tutorial does. These additional steps are graded.
Click to continue
Slide ‹#› of 22
Customer List layout
Click on the View menu in the menu bar and select Layout Mode.
Click to continue
Slide ‹#› of 22
Customer List layout
Click on the New Layout/Report button in the Status Bar.
Click to continue
Slide ‹#› of 22
Customer List layout
The New Layout/Report dialog will open.
Show records from should be the Customers table.
Click to continue
Slide ‹#› of 22
Customer List layout
Change the Layout Name to Customer List.
Click to continue
Slide ‹#› of 22
Customer List layout
Select Computer as the display device.
Click to continue
Slide ‹#› of 22
Customer List layout
Select List as the layout format.
Click to continue
Slide ‹#› of 22
8
Customer List layout
Click on the Finish button to create the new layout.
Click to continue
Slide ‹#› of 22
Customer List layout
Click on the Change Theme button (rectangle #1 below).
Select the Vibrant theme (rectangle #2) if it is not already selected and click OK.
Click to continue
Slide ‹#› of 22
Customer List layout
Open the Field Picker if it is not already displayed (command + K). Make sure that you have selected the horizontal field placement and labels above fields options.
Click to continue
Slide ‹#› of 22
11
Customer List layout
Click on the Customer ID field. Hold down on the command key and click on the Company, State, and Tier fields. Release the command key. All four fields should now be highlighted.
Click to continue
Slide ‹#› of 22
Customer List layout
Each layout has three sections.
Header
Body
Footer
Click to continue
Slide ‹#› of 22
Customer List layout
The field labels need to appear in the Header of the layout so they appear once at the top of the form.
Click to continue
Slide ‹#› of 22
Customer List layout
Anything that appears in the Body of the layout will be repeated for each record in the table. The fields should appear in the Body of the layout.
Click to continue
Slide ‹#› of 22
Customer List layout
Drag the selected fields from the Field Picker to the layout.
Video of dragging fields, requires Adobe Flash Player
A rectangle will appear as you move the fields over the layout. The top half of the rectangle should appear in the header of the layout (the brown section) and the bottom half of the rectangle should appear in the body of the layout (the light blue section).
If dragging the fields does not work as shown in the video, undo it and try again.
You may need to adjust the fields and field labels as shown near the end of the video to fix any overlaps.
Click to continue
Slide ‹#› of 22
Customer List layout
You may need to move the fields down in the Body section of the layout to get them to appear after you click on Exit Layout. Watch the video on the next slide.
Hold down on the shift key and select the Customer ID, Company, Website, and State fields. Release the shift key.
Press the down arrow key a couple times to move the fields down.
Click to continue
Slide ‹#› of 22
Customer List layout
The video first shows that if the fields are too high in the body of the layout, they do not appear after you exit layout mode.
The video then shows how to move the fields down (select the fields, then press the down arrow key a few times).
Finally, the video shows that the fields now appear after you exit layout mode.
Click to continue
Slide ‹#› of 22
Customer List layout
Select the labels in the Body of the layout and change their font color to white, if needed.
Inspector Appearance tab Text group
Click to continue
1
2
Slide ‹#› of 22
Customer List Layout
Click on Exit Layout in the Status toolbar and save your changes.
Click on New Record in the Status toolbar to start a new company record.
Click to continue
Slide ‹#› of 22
Customer List Layout
Enter your name as the Company name, any state that you want, and pick a tier for yourself.
Notice that the Customer ID is automatically assigned.
Click to continue
Slide ‹#› of 22
Slide ‹#› of 22
