Learn: in:
» back to Search Results

Course rating of 0 Vendor rating of 0

Topics include: security (activating, adding users & setting permissions), functions (domain, date, string, logical, and case), creating macros (macro actions, conditions, autoexec and autokeys macros), creating customized menus/toolbars, and more.

Course Outline


This course takes an in-depth look at macros, securing a shared database and using functions. 

This course is classroom style instruction: Instructor-led, hands-on training.

Creating a Workgroup File
Creating Users & Groups
Placing Users in Groups
Setting User Passwords
Owning the Database
Opening Exclusively
Setting Permissions
Testing Permissions
Query Permissions
Permissions for Other Objects
Creating a User Table
Setting a Database Password
User Level Security Wizard

Access Command Line Options
Load a Database Automatically
Startup Picture
Default User Login
Default Password
Default Workgroup
No Shortcut Icon?

Built-in Functions
Database References
Date Functions
Special Functions
Text Functions
Domain Functions

Creating Macros
Delete Buttons (with Wizard)
Close Buttons (with Wizard)
Creating a Macro
Macro Object vs. Macro Names
Selecting Actions
 GoTo Control
 Stop Macro
 Run Command
Adding Where Conditions
Using the Conditions Column
Special Macro Types
Database Startup Settings

Customizing Toolbars
Editing Toolbars
Adding & Removing Icons
Resetting a Toolbar
Creating a Toolbar
Adding Icons
Icons to Open Objects
Editing Icons
Macros Icons
Copy a Icon Image
Assigning a Toolbar to a Form
Converting Macros to Toolbars

Customized Menus
Creating a Menu Bar
Creating the Menus
Displaying & in Menus
Fly-Out Menus
Adding Commands
Attaching a Menu to a Form
Attaching a Menu to a Report
Converting Macros to Menus

Compact, Repair & Encrypt
Compacting/Repairing a Database
Compacting Database on screen
Making a Compacted Copy
Encrypting a Database

Switchboard Manager
Creating a Switchboard
Setting it to Open Automatically
Editing a Switchboard
Going beyond the 8 Button Limit

Unbound Forms & Reports
Changing Next AutoNumber


Prerequisites & Certificates

Course Prerequisite: Required: Solid understanding of all Access Introduction & Intermediate Level I topics.

Certificates offered

Participants receive with this course: * courseware (notes on all topics covered, along with exercises used during course). * a certificate of completion

Cancellation Policy

Map & Reviews
Computer Help
[ View Provider's Profile ]


This course has not yet been rated by one of our members.

If you have taken a course through this vendor please log into your account and leave feedback for this vendor. You will be helping ensure our members get directed to the best training facilities.


This course currently does not have any dates scheduled. Please call 1-877-313-8881 to enquire about future dates or scheduling a private, in house course for your team.

This page has been viewed 324 times.