We use cookies to offer you a better experience and to analyse how visitors use our site, you may consent to our cookies by continuing to use our site, or you may view more information and choose to reject cookies by clicking here. Thank you

Contact us online or call us on 0191 377 8377

  • Name*:*
  • Organisation:
  • Telephone:
  • Email:*
  • Message*:*
  • Send me a copy of this email
  • Send me course updates from time to time via email

    Your subscription will naturally terminate after your chosen time limit. We will get in touch just before the end so that you can subscribe again if you would like to continue receiving information after that point.

* Required Fields

PDF
Course Access Advanced Database Design
  • Public Scheduled Price£445 +VAT
  • Course Duration2 Days
  • Course Options
    Public Scheduled
    Public Scheduled
    Fixed 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 content, flexible date, flexible location, variable 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.
  • Latest Reviews
    "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

    "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

    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

Overview
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.
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


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)
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.

What's included
    • Laptops are available for training delivered at client's premises
    • Comprehensive course materials and exercises
    • Telephone and Email Support
    • Lunch and refreshments when training is delivered at our training venues

 

Latest Course Reviews
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

 

IT Training Solutions Ltd
Oakville, 14 Durham Road West, Bowburn, Durham, DH6 5AU
0191 377 8377
ittrainingsolutions.co.uk

Printed: 23 Oct 19

 

 

 

Contact us

  • Name*:*
  • Organisation:
  • Telephone:
  • Email:*
  • Message*:*
  • Send me a copy of this email
  • Send me course updates from time to time via email

    Your subscription will naturally terminate after your chosen time limit. We will get in touch just before the end so that you can subscribe again if you would like to continue receiving information after that point.

* Required Fields