Access Advanced

Mullan Training
Belfast, United Kingdom

Course Format: Classroom | E-learning | Virtual Class | Online/Live | On-site/In-house | Blended | Self-paced

Course Description:

'' 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.

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.
You will advance your querying ability and then to use SQL statements in your queries.
You will discover how to work with objects, and the fundamentals of database management.
Finally you will be taught how to protect your valuable data sources.
You will then be qualified to progress to our VBA Access course.

Course 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:
Carry Out Actions Depending On Criteria
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 ...''

Elements of this syllabus are subject to change.

Phone:+ 44 (0) 28 9032 2228

School Address/Venue(s):

Mullan Training
Ist Floor, Blackstaff Studios
Blackstaff Square
8-10 Amelia St
Belfast
BT2 7GS
United Kingdom

Jobs & Resumes: Belfast
Houses & Roommates: Belfast
Travel Agencies: Belfast

Search other schools for Access Advanced training resources.

Access VBA
Access
Excel - Advanced
Excel
Excel VBA advanced
Excel VBA
Microsoft Office 2007
Outlook
Powerpoint - Advanced

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: Our combined search function does not only provide you with the training courses and students, but also talent resumes and jobs, or shared apartments nearby for rent.