Custom Search
Home > Last Minute Training > Access 2003 Advanced- Last Minute Training
Provided by: Last Minute Training

Access 2003 Advanced- Last Minute Training

 Last Minute Training
Training Provided by Last Minute Training Location: Toronto Date: 2009-03-23 List Price: $825 Offered Price: $660. 00 Seats Available: 2 This course takes an in-depth look at macros, securing a shared database and using functions. For information call 1 877 313 8881 or visit http://www. lastminutetraining. ca/ courses. php/ course/ 7059/ Access-2003-Advanced-%283-Days%29
This is primarily ilt training
Contact Last Minute Training for more information
Course Level:basic
Duration:3 days
Training Presented in:English
Access 2003 Advanced- Last Minute 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
About The Training Provider: Last Minute Training
Last Minute Training - Last Minute Training Corp. works similar to last minute discounted travel. We sell training seminars at deep discounts on a last minute basis. If you want to save 30 - 60 off high quality training seminars and have the flexibility to attend with only a few days notice check out our website and see if the training you are looking for is on sale. While your there set up and free account...
Home > Last Minute Training > Access 2003 Advanced- Last Minute Training
Advertise With Us
Want to market your access training?
tcw11-gfc-v396M-11/24/09-18:36:03-()[A]-[A]-[A] -19:26:08