Access Project 6

1
Access Project 6

• Creating an Application System Using Macros,
  Wizards, and the Switchboard Manager

2
Objectives

• Create, add actions to, run, copy, and modify
  macros
• Create a switchboard and switchboard pages
• Modify switchboard pages
• Use a switchboard

3
Opening a Database

• Start Microsoft Office Access and open the Ashton
  James College database, which should be stored in
  the Data folder on your C drive

4
Creating a Macro

• Click the Macros object
• Click the New button
• Maximize the window by double-clicking its title
  bar

5
Adding Actions to a Macro
6
Running a Macro

• Right-click the Open Client Update Form macro and
  then click Run on the shortcut menu
• Click the Close Window button on the Client
  Update Form window title bar

7
Modifying a Macro

• Right-click the Open Client Update Form macro
• Click Design View
• If the Macro Name column appears, click the macro
  Names button on the Macro Design toolbar to
  remove the Macro Name column
• If the Condition column appears, click the
  Conditions button on the Macro Design toolbar to
  remove the Condition column

8
Modifying a Macro

• Click the row selector on the row containing the
  OpenForm action to select the row, and then press
  the INSERT key to insert a new row
• Click the Action column arrow on the new row,
  select Maximize as the action, and then type
  Maximize the window as the comment
• Click the Close Window button, and then click the
  Yes button to save the changes

9
Modifying a Macro
10
Copying and Pasting a Macro

• Ensure the Macros object is selected, and
  right-click the Open Client Update Form macro
• Click Copy to copy the macro to the clipboard
• Right-click any open area of the Database window
• Click Paste, type Open Trainer Master Form in the
  Macro Name text box in the Paste As dialog box
• Click the OK button

11
Adding Actions to a Macro

• Click No
• Press the F6 key to move back to Echo in the
  Action column, and then press the TAB key
• Type Turn echo off to avoid screen flicker in the
  Comment column, and then press the TAB key
• Select Hourglass as the action in the second row
• Press the TAB key and then type Turn on hourglass
  as the comment in the second row

12
Adding Actions to a Macro

• Press the TAB key and then select OpenForm as the
  third action
• Press the F6 key to move to the Action Arguments,
  and then click the Form Name box arrow
• Click Client Update Form, press the F6 key, press
  the TAB key, and then type Open Client Update
  Form as the comment
• Select Hourglass as the fourth action

13
Copying and Pasting a Macro
14
Creating a Switchboard

• With the Database window appearing, click Tools
  on the menu bar, and point to Database Utilities
  on the Tools menu
• Click Switchboard Manager
• Click the Yes button to create a new switchboard

15
Creating Switchboard Pages

• Click the New button in the Switchboard Manager
  dialog box
• Type View Form as the name of the new switchboard
  page
• Click the OK button to create the View Form
  switchboard page
• Use the same technique to create the View Table,
  View Report, and Print Report switchboard pages

16
Creating Switchboard Pages
17
Modifying the Main Switchboard Page

• With the main Switchboard (Default) page
  selected, click the Edit button
• Click the New button, type View Form as the text,
  and then click the Switchboard box arrow
• Click View Form and then click the OK button to
  add the item to the switchboard
• Using the technique illustrated in the previous
  two steps, add the View Table, View Report, and
  Print Report items to the Main Switchboard page.
  In each case, the command is Go to Switchboard.
  The names of the switchboards are the same as the
  name of the items. For example, the switchboard
  for the View Table item is called View Table

18
Modifying the Main Switchboard Page

• Click the New button, type Exit Application as
  the text, and click the Command box arrow
• Click Exit Application and then click the OK
  button to add the item to the switchboard
• Click the Close button in the Edit Switchboard
  Page dialog box to indicate you have finished
  editing the Main Switchboard page

19
Modifying the Main Switchboard Page
20
Opening a Switchboard

• Click the Forms object and then right-click
  Switchboard
• Click Open

21
Creating AutoExec Macro

• Click the Macros object
• Click the New button
• Maximize the window by double-clicking its title
  bar

22
Adding Actions to AutoExec Macro