 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. |
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
Prior to to course we will discuss your requirements and develop the course content to suit your needs.
- All participants receive handouts and course files of the course content if they want to review the information at a later date.
- 6 months FREE E-mail Support after course.
- Inspire IT are flexible with start and finish times for courses. We have delivered training courses that started at 7am and finished at 2pm due to clients preference.
For more information please E-mail Alan Joyce at info@inspiresit.ie or contact him at 085 1055651 or Skype inspireitweb
|
| |
- 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
-
Main/Subform
Wizard
- Linking Forms
- Multiple
Table Forms
|
- 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
|
|
