We use cookies to provide you with the best possible experience. Please carry on browsing if you're happy with this or click here to find out more about how we use cookies and how to manage your preferences.

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
Course Access Essentials An Introduction to Database Design
  • Public Scheduled Price£395 +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.
Overview
This Access course enables delegates to progress from the one level databases associated with holding data in Microsoft Excel, to multiple table relational databases, covering all the basics including the advantages and disadvantages. This course is a perfect starting point for a future in data manipulation.

Prerequisites
    • Delegates should be familiar with using a computer and have used a mouse and keyboard. Familiarity with the list-related tools in Microsoft Excel such as sorting and filtering would be beneficial
Objectives
    • Understand the principles of database design and importance of planning a database.
    • Explain the advantages of using different data types within a database to change the way data can be input.
    • Understand table structure and relationships within databases
    • Create a form for users to enter data more easily.
    • Access information from a database by creating and saving queries within a database.
    • Produce accurate, informative and well-presented reports.
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
Course Content
    • Database theory
      Explanation of the components that make up a database
    • Tables
      Table creation methods
      Primary Keys
      Choosing data types
      Field properties and Validation options
      Adding a Lookup field to a table, exploring different methods
    • Relationships
      Understanding Normalisation and Table structure
      Deciding on the correct Relationship type and understand the options available
      Creating links between Tables
      When to use Referential Integrity and cascade / delete related records
    • Queries
      Creating a selection query using the Query-By-Example Window (QBE)
      Specifying criteria with wildcards, how to filter the data to show just what you want
      Sorting the results of a query by one or more field
      Using multiple criteria with And and Or
      Changing the join type of the relationship between tables of a query
      Parameter queries, supplying the criteria for a query at run time
      Calculations in queries
      Joining/Editing fields in queries
    • Forms
      Understanding the use of Forms
      Methods for Form creation
      Exploring the Form properties
      Setting data sources. How to change where a form gets its data from.
      Controlling layout using Tables
      Adding a Form header or footer
      Drop down list boxes in a form
      Option boxes and yes
      o boxes
      Adding text boxes and Pictures
      Tab order. Controls which text box will get the focus when the user presses the TAB key on the keyboard.
      Creating a Sub Form. A sub form allows the user to see records related to the main form that are held in another table
      Creating Tabbed Forms. Split your form into overlapping sections, to make it easier to use.
      View/change data in your database using forms
      Adding buttons using the wizard
    • Reports
      Creating reports from your database using the report Wizard
      Portrait or Landscape layout
      Editing the layout of a Report once created
      Printing Reports

 

 

 

 

 

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