Course Objectives:
At
the end of this course participants will be able to understand more
advanced operations associated with database design. You will see how to create drop down menu's in tables, how to create advanced forms and reports.
Benefits:
This course is designed for those users who wish to step their current knowledge of Access to take advantage of the more complex features. On completion delegates will understand relational databases and be able to work with related tables. They will learn how to generate much more complicated queries and create more advanced forms and reports before tackling PivotCharts and PivotTables.
Typically our courses are delivered in one day, to groups of upto 8 delegates, at your location. This keeps your costs down, and allows your staff to learn in a familiar environment. If you don't have your own training facility, then we can deliver training at a location to suit you, which you can arrange yourself or we can do that for you.
For more information please contact us at info@inspiresit.ie or call the senior trainer on 085 1055651
Inspire IT has delivered training in Dublin, Waterford, Kilkenny, Sligo, Galway, Donegal, Tipperary, Athlone, Dundalk, Kerry and Wexford.
We will travel onsite anywhere in Ireland
Tables
- Field Properties
- Lookup
Fields
- Default Values
- Validation
Rules/Text
- Input Masks
Relationships
- Applying
a Primary Key
- Applying
Relationships
- Creating
other relationships
- Querying
Related Tables
- Applying
Joins
- Referential
Integrity
- Updating
and Deleting Records
- Viewing a
subdatasheet
Queries
- Creating
a query
- Action
Queries
- Append
Query
- Delete Query
- Make Table
Query
- Update Query
- Crosstab
Query
Forms
- Linking Forms
- Multiple
Table Forms
- Main/Subform
Wizard
|
Form
Controls
- Calculated
Fields
- Command
Button
- Combo
Box
- List
Boxes
- Check
Boxes
- Option
Groups
- Tab
Control
- Form
Headers and Footers
- Printing
Forms
Reports
- Grouped
Report
- Calculated
Fields
- Calculating
Percentages
- Report Headers
& Footers
- Printing
Reports
Import
and Export Data
- Importing
Data
- Exporting
Data
- Linking
Data
Macros
- Macro
Actions
- Create
a New Macro
- Attaching
a Macro to a Control
- Create
Macros from Controls
- Multiple
Action Macros
|
| Back to Main Accessl Page>> |
|
|
