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.

Security
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
 Year
 Month
 Day
 Weekday
 Date
 Now
 DateSerial
Special Functions
 IIF
 Switch
 IsNull
 Format
 Eval
 CurrentUser
 CurentObjectName
Text Functions
 Left
 Mid
 Right
 Chr
 InStr
 UCase
 LCase
Domain Functions
 DAvg
 DMax
 DMin
 DSum
 DCount
 DLookup

Creating Macros
Delete Buttons (with Wizard)
Close Buttons (with Wizard)
Creating a Macro
Macro Object vs. Macro Names
Selecting Actions
 OpenForm
 OpenReport
 MsgBox
 Maximize
 StopMacro
 GoTo Control
 Stop Macro
 GoToRecord
 Run Command
 PrintOut
 SetValue
 RunMacro
 ShowToolbar
 FindRecord
 ApplyFilter
 ShowAllRecords
Adding Where Conditions
Using the Conditions Column
Special Macro Types
 SendKeys
 AutoKeys
 AutoExec
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
Pre-Requisites

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 ]

Reviews
 

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.

need-to-train-a-group-banner

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 322 times.