Professional Development of Bespoke Business Software and Database Specialists

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

MS Office Training

Other pages in MS Office Training:

Latest templates added to the emporium

Intermediate

Audience: This course is designed for existing Access users with sound basic skills. The course will focus on advancing basic query, form and report formulation. We also cover more advanced relationships.
 
Access Intermediate Course Objectives: After the course, you will be able to:
        
       Create Action Queries
       Create Advanced Forms
       Create Advanced Reports
       Understand and Create a Switchboard
 
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 training 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.
 
Relationships
       Why create relationships between tables?
       Different types of relationships
       Conditions for setting up a relationship
       Referential Integrity
       Cascade Update
       Cascade Delete
Advanced Queries
       Calculated fields
       Parameter Queries
       Summary Queries
       Crosstab Query Wizard
       Editing a Crosstab Query manually
       Top Values Query
       Make Table Query
       Append Query
       Delete Query
       Update Query
Advanced Forms
       Composite Forms including Main Form and sub forms
       Displaying Yes/No values
       Option groups
       Command buttons
       Setting form properties
       Calculations within Forms
       Combining Text Values
       Changing the data source
       Keyboard Short Cuts for Fields
       Tab Order
       Adding and Removing Filters(Selection and Forms)
       Defining Validation Rules
       Template Forms
Advanced Reports
       Using Expressions
       Adding Sub Reports
       Parameter reports
       Report Templates
       The Keep Together property
       Group on and group interval properties
       Advanced Grouping techniques
       Page setup
Charts and Pivots
       Formatting a chart
       Changing the type of chart
       Parameter chart Charting based on individual record
       Creating Pivots

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 >