Access Adv

Enquire About This Course

Our 1 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
• 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, , Append)
• AutoLookup & Crosstab Queries
• Calculated Fields

 

• mullantechnology.com specialise in customised systems that support our clients’ business requirements and objectives – creating both desktop & web based database applications.
• We know that the best way to provide a database is to create a database solution around the way you work.
• The result is a user friendly system streamlined to fit your particular business processes, to a degree that an off-the-shelf product could never match.
• Click here to visit our mullantechnology.com website and view sample databases & details of the technology we can offer to meet your requirements.

Click here to download:

Microsoft Access Adv

Enquire About This Course