Access 2007 Advanced Courseware

Microsoft Access 2007 Advanced Training Materials

Advanced Level Training Course

Training Course Outline

ACCESS 2007 FORM CUSTOMIZATION

  •     Linking a form to a table
  •     Placing controls on the form
  •     Aligning controls on a form
  •     Sizing to fit controls on a form
  •     Special effects
  •     Setting tab order
  •     Placing a bound control on the form
  •     Placing a check box on the form
  •     Placing a command button on the form
  •     Placing a group box on the form
  •     Placing a combo box on the form
  •     Placing a list box on the form

TYPES OF FORMS INACCESS 2007

  •     Popup forms
  •     Modal forms
  •     Split forms

LIMITING USER ACCESS WITHIN ACCESS 2007

  •     Limiting users from adding new records
  •     Limiting users from deleting existing records
  •     Limiting users from editing a records

EXPORTING FORM TO XML IN ACCESS 2007

  •     Exporting to XML

ACCESS 2007 REPORTS

  •     Creating a report
  •     Creating an AutoFormat template
  •     Applying an AutoFormat to a report using the Report Wizard
  •     Applying an AutoFormat to an existing report
  •     Conditional formatting
  •     Subreports
  •     Formatting reports

ACCESS 2007 SWITCHBOARDS

  •     What is a switchboard?
  •     Creating a Switchboard
  •     Adding a switchboard
  •     Deleting a switchboard
  •     Adding items to a Switchboard
  •     Editing a Switchboard
  •     Deleting items within a Switchboard
  •     Editing items within a Switchboard
  •     Making a Switchboard the default Switchboard
  •     Displaying Switchboards automatically when opening a database

CUSTOMIZING ACCESS  2007

  •     Customization options
  •     Current Database options
  •     Datasheet options
  •     Object Designers options
  •     Proofing options
  •     Customize options
  •     Add-ins options

 

Access 2007 Advanced Courseware
3 (60%) 1 vote