|
Provided by: Mullan Training Advanced MS AccessAccess |
 |
Training
Provided by Mullan Training
Our 2 day Advanced Microsoft Access training course is suitable for those with a sound working knowledge of Access who wish to progress to the most complicated functions and features.
The course will be primarily instructive with some time used as a tutorial; delegates will have the opportunity to work through an exercise provided by the tutor or work on their own database.
To illustrate possible development methods, a complex existing database will be presented at the outset this will make use of:
- macros
- interrogating data using custom dialogue boxes
- action queries
- use of Expression Builder
- a range of advanced functions
PREREQUISITES
A working knowledge of Access or our Introduction to MS Access course will allow sufficient knowledge to attend our Advanced MS Access course.
BENEFITS
At the end of this course you will have a complete understanding of the higher functions of Access.
You will:
- Learn to automate functions by creating simple and then very advanced macros.
- Advance your querying ability and then to use SQL statements in your queries.
- Discover how to work with objects, and the fundamentals of database management.
- Be taught how to protect your valuable data sources.
You will then be qualified to progress to our VBA Access course.
WORK ON YOUR OWN DATABASES
Delegates that have their on databases they want to work on are encouraged to bring then to the course to work on as part of the tutorial.
LOCATIONS
Courses can be delivered at our offices in Belfast city centre (opposite the Europa Hotel) or in your own workplace (where we can provide 8 laptops, projector & flipcharts).
ADDITIONAL INFORMATION
If you would like more information please do not hesitate to contact us.
For a course outline visit our website
www.mullantraining.com
or email us at
info@mullantraining.com
or telephone
028 9032 2228
|
|
||||||||||||||||
Advanced MS Access
ourse Content
Create Expressions
 For Use Within Reports, Queries, Forms, Macros
 Definition Of (Symbols, Fields, Identifiers, Operators, Functions)
 Use To Define Calculated Control, Establish Validation Rule, Create Calculated Field
 Use To Set Condition For Running A Macro
 Create Using The Expression Builder
Forms
 Create Forms With Macros To Create A User Interface
 Create Custom Dialogue Boxes (Set Properties - Modal, Popup, Etc)
 Create Forms With Multiple Subforms
 Calculated Fields
 Use Expression Builder To Limit To Displayed Records
 Insert Picture (Picture Properties, As Background, Etc Also For Report)
Security
 Assign & Change Database Passwords
 Security Account Password
 Prevent Users From Replicating, Setting Database Password And Changing Startup Options
 User-Level Security Wizard
 Create A New Workgroup Information File
 Join And Log Onto An Access Workgroup
 Permissions (Overview, Types, Assign & Remove Them)
Reports
 Specify Grouping Levels (Grouping Header/ Footer, Group On, Group Interval, Keep Together)
 Calculated Fields
 Report Properties (Force New Page, Keep Together, Events, Etc)
 Create Mailing Labels And Charts From Table/ Query Data
Macros
 Create A Macro (Actions, Arguments)
 Autoexec Macro
 Macro Functions (Setvalue, Setmenu Item, Msgbox, Run, Etc)
 Create A Macro Group
 Add An Action To A Macro
 Move An Action In A Macro
 Enter An Expression In A Macro Action Argument
 Use Conditions To:
1. Carry Out Actions Depending On Criteria
2. Validate Data
 Show And Hide Macro Names And Conditions In The Macro Window
Queries
 Use The ! And . (Dot)Operators
 Expressions
 Aggregate Functions
 Parameter Queries With The Criteria Provided From A Form (Standard Or Custom Dialogue)
 Action Queries (Update, Delete, Append)
 AutoLookup & Crosstab Queries
 Calculated Fields
Create Expressions
 For Use Within Reports, Queries, Forms, Macros
 Definition Of (Symbols, Fields, Identifiers, Operators, Functions)
 Use To Define Calculated Control, Establish Validation Rule, Create Calculated Field
 Use To Set Condition For Running A Macro
 Create Using The Expression Builder
Forms
 Create Forms With Macros To Create A User Interface
 Create Custom Dialogue Boxes (Set Properties - Modal, Popup, Etc)
 Create Forms With Multiple Subforms
 Calculated Fields
 Use Expression Builder To Limit To Displayed Records
 Insert Picture (Picture Properties, As Background, Etc Also For Report)
Security
 Assign & Change Database Passwords
 Security Account Password
 Prevent Users From Replicating, Setting Database Password And Changing Startup Options
 User-Level Security Wizard
 Create A New Workgroup Information File
 Join And Log Onto An Access Workgroup
 Permissions (Overview, Types, Assign & Remove Them)
Reports
 Specify Grouping Levels (Grouping Header/ Footer, Group On, Group Interval, Keep Together)
 Calculated Fields
 Report Properties (Force New Page, Keep Together, Events, Etc)
 Create Mailing Labels And Charts From Table/ Query Data
Macros
 Create A Macro (Actions, Arguments)
 Autoexec Macro
 Macro Functions (Setvalue, Setmenu Item, Msgbox, Run, Etc)
 Create A Macro Group
 Add An Action To A Macro
 Move An Action In A Macro
 Enter An Expression In A Macro Action Argument
 Use Conditions To:
1. Carry Out Actions Depending On Criteria
2. Validate Data
 Show And Hide Macro Names And Conditions In The Macro Window
Queries
 Use The ! And . (Dot)Operators
 Expressions
 Aggregate Functions
 Parameter Queries With The Criteria Provided From A Form (Standard Or Custom Dialogue)
 Action Queries (Update, Delete, Append)
 AutoLookup & Crosstab Queries
 Calculated Fields
About The Training Provider: Mullan Training
Mullan Training - Mullan Training are a computer training company in Belfast city centre.
We deliver high quality computer training in Belfast and throughout Northern Ireland.
We can deliver computer training courses in our training suites OR in your own offices. We are an authorised
Microsoft Office Specialist (MOS) Testing Centre so delegates can prepare for & sit exams with us.
Courses we deliver...
