Professional Development of Bespoke Business Software and Database Specialists

You are here: Home » MS Office Training » Microsoft Access » Advanced

MS Office Training

Other pages in MS Office Training:

Latest templates added to the emporium

Advanced

Audience: This course is designed for existing Access users who need to start automating database tasks and constructing applications.
 
Access Advanced Course Objectives: After the course, you will be able to:
 
       Create and Apply Macros
       Understand Events
       Create Conditional and Named Macros
       Create Custom Toolbars and Menu's
       Use Startup Options
        
Requirements: You must have sound Access skills and understand key concepts of a database, equivalent to our intermediate course contents
 
Course Duration :This is a 1 day Access Advanced course. The course starts at 09:30 and runs until 16:30
 
Course Locations / Schedule : This course can be run at your premises (equipment must be provided) or at one of our training centres throughout the UK. The course is run on a date that suits you! We do not run public scheduled courses.
 
The following content applies broadly to all versions of Access. Some content may slightly differ, full course content packs are provided on the day. Remember courses can be customised to fit your exact needs.
 
Macros
       An Overview
       Creating Macros and Running Macros
       Various Macro Actions
Names Macros
       Using ^ + letter
       Using ^ + Number
       Function keys
Conditional Macros
       Msgbox
       Set value
       Using functions
Event Procedures
       On open/close
       On got/lost focus
Creating a Switchboard (User Interface)
       Designing a switchboard
       Using Macros associated with Command Buttons
       Using Macros associated with Code
       Formatting switchboard forms
       Creating a Splash Screen
       Using autoexec
       Custom toolbar
       Custom menu
       Start-up Menu
VBA
       Sample subroutine
Sample function

Software development company

At Mill House Data we are experts in the design and construction of bespoke software development solutions. With a high level of experience in application development for many industries, from small business to corporate clients, we are capable of designing and developing the perfect business software for your needs.

Our software development company utilizes MS Access which not only allows for multiple user ids but up to 2GB of data storage which is more than adequate for most business needs. Utilising this method of application development is the most economic route as only one Microsoft license is required, so we can provide your custom software development needs with a smaller budget than most other development houses.

Excellent customer service. Responded to all my enquiries in a very timely manner and were helpful throughout. They took time to understand my needs and delivered on time with everything I wanted and more!

Read more testimonials >