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