Training Course

Access Advanced Database Design

PDF
2 Days
This Microsoft Access course is for delegates who have sound skills in the use of MS Access and are now ready to expand their knowledge into some of the more specialised and advanced features of the software. This course will provide delegates with the skills needed to create complex queries, create macros to automate tasks, enhance forms and reports and use the Access programming language Visual Basic for Applications (VBA), enabling delegates to really take control of their databases.




Public Scheduled Course Dates

Prices per delegate. All prices exclude VAT.
19 Mar - 20 Mar 2025
Virtual Course
£685
31 Jul - 01 Aug 2025
Virtual Course
£685
30 Sep - 01 Oct 2025
Virtual Course
£685
04 Dec - 05 Dec 2025
in
Durham
£785

Private Training

Flexible dates, location and content. All prices exclude VAT.

Course Prerequisites

    • Delegates should understand database design and structure
    • Delegates should be able to create and manipulate Queries
    • This course assumes knowledge of how to create a database with many related tables
    • Delegates should have an up to date working knowledge of Access and have attended Access Essentials course or have equivalent knowledge and experience


Course Objectives

    • Put existing data into correctly designed tables and compact a database
    • Use a variety of techniques to summarise data
    • Create and edit Access macros
    • Create macros to automate tasks within a database
    • Use advanced features to enhance forms
    • Add security features to protect your database
    • Start creating programs in your database with Visual Basic for Applications (VBA)

Included with this course

    • Comprehensive course materials and exercises
    • Telephone and Email Support
    • Lunch and refreshments when training is delivered at our training venues

Access Advanced Database Design Course Content

  • Working with Action queries

    Update query
    Make Table query
    Find Duplicates query
    Append query
    Delete query

  • Advanced form design

    Unbound forms
    Command buttons
    Passing values to queries from a field on a form
    Creating Cascading Combo Boxes (The combo box filters the contents of another combo box)
    The Expression Builder
    Triggering Events on a form
    Using the data functions to return specific values, for example, DLookup, DSum, Dcount

  • Reports

    Grouping and sorting records
    Creating calculated fields
    Conditional formatting

  • Macros

    Creating macros
    Embedding Macros into buttons
    Message Boxes
    Macros in form events
    Passing values between forms to filter data
    Attaching macros to the quick access toolbar

  • Database utilities

    Configuring the Navigation Pane with custom groups
    Compacting and repairing a database
    Examining object dependencies
    Splitting a database into Front and back ends
    Creating Custom Ribbon Tabs
    Startup options and custom icons
    Protecting your database with a password

  • Introduction to programming in Access (VBA)

    This is a gentle introduction to programming in Access. It is where the real power lies when you create a database. Once you have mastered the user interface this is your next step. In this course we provide you with an ‘easy steps’ introduction to programming; you will learn how to:
    Use the programming environment
    Create your first program and attach it to a button
    Automate tasks such as:
    Open a form/ report, create your own switchboard
    How to run several queries at with the click of the button
    How to filter a form depending on the criteria chosen
    How to hide fields on a form
    How to display a message
    Once you have attended this course you will have the confidence to experiment and start learning how to program using VBA (Visual Basic for Applications). This part of the course gives you a taster of programming without you having to attend a full blown programmers course.

 

Public Scheduled Course Dates

Prices per delegate. All prices exclude VAT.
19 Mar - 20 Mar 2025
Virtual Course
£685
31 Jul - 01 Aug 2025
Virtual Course
£685
30 Sep - 01 Oct 2025
Virtual Course
£685
04 Dec - 05 Dec 2025
in
Durham
£785

Private Training

Flexible dates, location and content. All prices exclude VAT.
  • Call us on
    0191 377 8377
    to discuss your requirements.
    Mon-Fri 9am-5pm.
    Have a Question?
    Keep me up to date with offers and news
    By submitting this form, you consent to IT Training Solutions Ltd storing your information in order to respond to your request.
  • Access Advanced Database Design Course Options
    Public Scheduled
    Public Scheduled
    Fixed course content, fixed date, fixed location, fixed length, multiple organisations - All you need to do is choose which course you would like to attend and contact us to book!
    Private
    Private
    Flexible course content, flexible training date(s), flexible location(s), variable course length, private to your organisation - Courses can be held at one of our training venues or at another location convenient to you. Training can be set over a number of days or weeks to allow for practice time between training sessions.
    Bespoke
    Bespoke
    Bespoke private training can be based on an existing course or a number of lessons taken from several courses, we can also write bespoke courses for you based on your in-house systems or development program.
    Virtual
    Virtual
    These courses can be attended from anywhere.
  • Virtual Training

Any other comments or recommendations "Great use of workshop function rather than a 'talked at session' and good use of relating to own data"

J.C. , Access Advanced Database Design

"This course ran through plenty of examples and my questions were answered to help my understanding"

J.C. William Smith Group, Access Advanced Database Design

"Thoroughly enjoyed it! Clear and concise. Right up my street, can't wait to go away and practice. Once again, thank you for an enjoyable learning experience."

P.A. Nissan, Access Advanced Database Design

Following this training what are you going to do differently "Use the new skills I have learned today"

A.P. Teesworks SC, Word Essentials

"Fantastic course. Could be boring material but the teacher makes it fun and interactive and is enthusiastic about the subject matter"

C.C. Martell Real Estate, Excel Level 2

"Very friendly tutor"

E.R. CNTW, Adobe InDesign Level 1

"I will make some graphics myself rather than searching online and trying to edit those online. It will be much quicker for me just to make the visual I need."

G.A. Karbon homes, Adobe Illustrator Level 2

"Things I was doing on Excel that would take up hours of my day now only take 10 minutes."

S.B. THARSUS VISION LTD, Excel Level 2

 

Public Scheduled Course Dates

Prices per delegate. All prices exclude VAT.
19 Mar - 20 Mar 2025
Virtual Course
£685
31 Jul - 01 Aug 2025
Virtual Course
£685
30 Sep - 01 Oct 2025
Virtual Course
£685
04 Dec - 05 Dec 2025
in
Durham
£785

Private Training

Flexible dates, location and content. All prices exclude VAT.

 

Please contact us to discuss your Access Advanced Database Design course, we have many solutions available to ensure you receive the best training possible.
Your access course can be delivered online or in-person.  You can choose your learning path and delivery style.  Learn in-person or online with our virtual classrooms.  Your course can be delivered online, at your office or at one of our training venues, it's your choice. Small course sizes. Course materials included. Flexible Access Advanced Database Design course content. Expert trainers and tried & tested training methods. Many course materials available online using your personal training account.  You can master access, please contact us to book a place or request a quote for your Access Advanced Database Design course.

General Information

Microsoft and Microsoft Access are Registered Trademarks Advanced Microsoft Access Database Design Training Course available throughout North East England including Newcastle, Durham, Washington, Sunderland
IT Training Solutions Ltd
Oakville, 14 Durham Road West, Bowburn, Durham, DH6 5AU
0191 377 8377
ittrainingsolutions.co.uk
Printed:1/16/2025 4:34:00 PM