Full control over features and software of Microsoft Access
249ر.س
Product description
Bag code: COMSO62525024
Days: 5 days
Time: 25 training hours
Targeted participants: Anyone interested in learning about Microsoft Access information
Program overview: This program is about full control of features and software of Microsoft Access (definition – types – properties – objectives – advantages – disadvantages .. etc.)
It will be presented through the following units:
Unit One: Types of controls
Unit Two: Creating a calculated control
Unit Three: Setting the tab order for controls
Unit Four: Adding autocomplete control to the view
Unit Five: Access security structure
Program objectives:
To enable the trainee to recognize types of controls
To determine the trainee to automatically align controls in a form
To teach the trainee to set the tab order for controls
To apply the trainee to add autocomplete control to the view
To implement the trainee to the Access security structure
Program axes:
Unit One: (Types of controls)
Types of controls
Continued: Types of controls
Understanding binding using controls
Unit Two: (Creating a calculated control)
Automatically aligning controls in a form
About layouts
Create a new layout
Switch layout from tabular to stacked, or vice versa
Split one layout into two layouts
Rearrange controls in a layout
Add controls to a layout
Remove controls from a layout
Create a calculated control
Change a linked control to a calculated control
Types of controls that can be used as calculated controls
Unit Three: (Setting the tab order for controls)
Setting the tab order for controls
Remove a control from the tab order
Change the tab behavior for the last field in the tab order
Understanding default values
Set a default value for a table field
Set a default value for a control
Set a default row for a list box or combo box
Set a default for a value list
Set a default for a lookup list
Examples of default values
Unit Four: (Adding autocomplete control to the view)
Adding autocomplete control to the view
Using the autocomplete control in the browser
Set additional options for the autocomplete control
Controlling program flow using If, Else If, and Else
Add an If block to a macro
Add Else or Else If blocks to an If block
Create the sub-macro
Unit Five: (Access security structure)
New in Access security
Access and user-level security
Access security structure
Disable mode
ActiveX controls
Using an Access database in a trusted location
Open the Trust Center
Set a database in a trusted location
Bag contents:
PowerPoint 177
Trainer's guide 117
Trainee's guide 100
Activities 12
Introductory guide 1
References 4
Evaluation forms and data 6
Pre- and post-test 6
Videos 4
Images 10
Mind maps 1
Brochure 1
Bag contents 12
Training bag template
Please click here to view the training bag template
Questions you might have

