Course outlines may be downloaded for many of the courses.

If you would like additional outlines please do not hesitate to contact us.

Access Adv 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 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   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 Access_Adv