MS Access Level 4
Sponsored links
Must be a fairly confident Access user. You’ve created databases a few times and know about relating tables. Queries are a breeze to you.
This course looks at setting databases up for other people to use. You will learn how to automate the flow of your database using a start up screen (or Switchboard), and learn how to use macros in Access. Please note that macros are not VBA.
| Delivery: |
|
| Regions: |
|
| Category: |
Further Details
Multi User Databases
· Splitting the database into a front and
back end
· Creating a security file so users have to
log-in to the database
Working with macros (Not VBA)
· Understanding and Exploring Macros
· Using the Macro window Toolbar
· Creating New Macros
- Open a form read only
- Open a form for data entry only
- Export a table to Excel
- Send a report via Email
- Copy table to another database
- Print a Report
· Running a macro
· Stepping through a macro
· Modifying a macro
· Adding Conditions to Macros
· Using the Expression builder to create Conditions
· Running macros with conditions
· Attaching Macros to a Form
· Attaching Macros to a Report
· Filtering Records
· Commenting Macros
· Macro Names
· Printing Macro Definitions
· Viewing Macro Definitions
Working with Switchboards
· Creating a Start-up Screen (Switchboard) using the wizard
· Editing a Switchboard Item
· Setting the properties of the form so it stays on top
· Deleting a Switchboard
This Training Course is taught in classrooms in the following locations:
London SE
Information provided is for information purposes only and no guarantees are made with regards to accuracy. It is advised that all details are checked prior to making a booking. Contents © 1999 - 2012. All rights reserved.
