course-premium

Level 2 Microsoft Access

4.6
5 reviews
  • I really loved that even though I was already aware of many subjects taught in the course, I really learnt more thing that I didn’t know of. So glad to have done this program, thanks so much to The Software Training Company and my classmates for making it easier!
    |
  • This course was so easy to do and I found it very informative. Now at work I can see how to apply everything I learnt from Heather, my tutor. She was great and absolutely into the course. She was patient, understanding and was always looking to explain according to everyone’s needs. This is why I will like to thank her and this centre for providing me with such a good experience.
    |
  • The Software Training Company Ltd has a great relationship with us for several years. The support and dedication they give to us on daily basis, by Heather’s hands is just amazing and this is why all the courses are so worth it. We really appreciate their support.
    |

Course

In Royal Leamington Spa

Price on request

Improve your professional career with this course!

  • Type

    Course

  • Methodology

    Inhouse

  • Location

    Royal leamington spa

  • Duration

    2 Days

  • Start date

    Different dates available

To develop topics covered in the previous course and to introduce more advanced Access commands and functions.
The course will provide the delegates with the opportunity to explore the more sophisticated features and facilities of
Access. They will learn how to use complex query techniques, create efficient forms and reports, and use macros to
automate their work.

Facilities

Location

Start date

Royal Leamington Spa (Warwickshire)
See map
Althorpe Enterprise Hub, Althorpe Street, , CV31 2GB

Start date

Different dates availableEnrolment now open

About this course

This course is designed for delegates who have a need to further their understanding of Access and identify how it can
be used to create a fully functional database system.

Delegates should have attended the 2 day Introduction to Access course or have gained thorough practical experience
and understanding of the basic design features of tables, forms, queries and reports.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

4.6
excellent
  • I really loved that even though I was already aware of many subjects taught in the course, I really learnt more thing that I didn’t know of. So glad to have done this program, thanks so much to The Software Training Company and my classmates for making it easier!
    |
  • This course was so easy to do and I found it very informative. Now at work I can see how to apply everything I learnt from Heather, my tutor. She was great and absolutely into the course. She was patient, understanding and was always looking to explain according to everyone’s needs. This is why I will like to thank her and this centre for providing me with such a good experience.
    |
  • The Software Training Company Ltd has a great relationship with us for several years. The support and dedication they give to us on daily basis, by Heather’s hands is just amazing and this is why all the courses are so worth it. We really appreciate their support.
    |
100%
4.4
fantastic

Course rating

Recommended

Centre rating

Babcock Aldershot

5.0
08/03/2020
About the course: I really loved that even though I was already aware of many subjects taught in the course, I really learnt more thing that I didn’t know of. So glad to have done this program, thanks so much to The Software Training Company and my classmates for making it easier!
Would you recommend this course?: Yes

Lorraine

4.0
08/03/2020
About the course: This course was so easy to do and I found it very informative. Now at work I can see how to apply everything I learnt from Heather, my tutor. She was great and absolutely into the course. She was patient, understanding and was always looking to explain according to everyone’s needs. This is why I will like to thank her and this centre for providing me with such a good experience.
Would you recommend this course?: Yes

Fraikin (HR)

5.0
07/03/2020
About the course: The Software Training Company Ltd has a great relationship with us for several years. The support and dedication they give to us on daily basis, by Heather’s hands is just amazing and this is why all the courses are so worth it. We really appreciate their support.
Would you recommend this course?: Yes

Air Tanker

4.0
07/03/2020
About the course: My tutor Heather was very passionate about the course, it inspired me! She was always giving us feedback and had the correct words for every question. Learnt some very useful tips as well as a very welcome recap of the Introduction course. I feel much more confident in applying calculations/formulae/functions to a spreadsheet
Would you recommend this course?: Yes

SFS

5.0
06/03/2020
About the course: After this training, I just got back to work and I can see how to apply the tricks and tips on the course in my day-to-day shores. I learnt much more than I thought I would and I can see the progress I made. Thanks so much for your help, I am happy to see the result!
Would you recommend this course?: Yes
*All reviews collected by Emagister & iAgora have been verified

Subjects

  • Powerpoint
  • Access
  • Database Design
  • Database
  • SQL
  • Database training
  • Computer Engineering
  • Design
  • IT Security
  • Microsoft Access
  • SQL Server
  • Queries
  • IT Systems
  • Computer Science
  • Office systems
  • IT
  • Access 2013
  • Computering
  • Microsoft
  • Mirosoft Access
  • Advanced Access

Course programme

Course content


Creating Powerful Tables

• Modify field and table properties

• Using validation rules

• Creating input masks

• Using lookups

Relational Database Summary

• The relational model

• Types of relationships

• Referential integrity

Advanced Queries

• Calculations using queries

• Performing custom calculations

• Parameter queries

• Table joins

• Finding unmatched and duplicate records

• Creating crosstab queries

• Common Access Functions


Advanced Form Design

• Creating and using sub forms

• Calculated fields and expressions

• The expression builder

• Combo and list boxes

• Page tabs

• Option groups and option fields

• Use of unbound fields

• Using sub reports

Reports Review

• Multiple table reports

• Parameter query reports

• Grouping and sorting data

• Adding calculated fields

Macros

• Creating and running a macro

• Command buttons

• Using macros in forms

• Grouping macros

• Using conditions in macros

• Synchronising forms

• Custom menus using menu builder

Events on Forms

• Form window events

• Keyboard events

• Data events

• Error and timing events

• Focus events

• Mouse events

• Attaching macros to events

Database Security

• Groups and users

• General approach

• Compacting, Repairing and encrypting databases

Level 2 Microsoft Access

Price on request