Training Course

Access Essentials An Introduction to Database Design

PDF
2 Days
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.

Public Scheduled Course Dates

Prices per delegate. All prices exclude VAT.
17 Oct - 18 Oct 2024
in
Durham
,
£685
02 Dec - 03 Dec 2024
Virtual Course
,
£585
10 Apr - 11 Apr 2025
Virtual Course
,
£585
23 Jul - 24 Jul 2025
Virtual Course
,
£585
16 Oct - 17 Oct 2025
in
Durham
,
£685
01 Dec - 02 Dec 2025
Virtual Course
,
£585

Private Training

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

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

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

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 Essentials An Introduction to Database Design 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 understanding 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 fields
    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 / No 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.
    Viewing and changing 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

 

Public Scheduled Course Dates

Prices per delegate. All prices exclude VAT.
17 Oct - 18 Oct 2024
in
Durham
,
£685
02 Dec - 03 Dec 2024
Virtual Course
,
£585
10 Apr - 11 Apr 2025
Virtual Course
,
£585
23 Jul - 24 Jul 2025
Virtual Course
,
£585
16 Oct - 17 Oct 2025
in
Durham
,
£685
01 Dec - 02 Dec 2025
Virtual Course
,
£585

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 Essentials An Introduction to 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

Brilliant course

M. William Smith, Access Essentials An Introduction to Database Design

Which part of the course did you find particularly valuable All of it was excellent

J.F. Encore Envelopes, Access Essentials An Introduction to Database Design

What other courses would you like to attend Stuart was very helpful and has a very good way of getting the point accross

J.F. Encore Envelopes, Access Essentials An Introduction to Database Design

Thoroughly enjoyed the course and everything about it. Location, content and of course the Trainer! Keep up the good work and I look forward to learning more through ITTS. Thankyou.

P.A. Nissan, Access Essentials An Introduction to Database Design

Which part of the course did you find particularly valuable All of it, as a project manager beginner most of the information was valuable and has improved my knowledge of project management

M. , Project Management Essentials

Extremely informative and very beneficial in enhancing my knowledge and skills

A.P. South Tyneside Council, Excel Level 2

Which part of the course did you find particularly valuable The practical aspect and being able to demonstrate skills learned on the day.

J.J. Thermo Fisher Scientific, Train the Trainer Training Skills for the Workplace

I was a complete beginner, but able to keep up with all the coursework so have experienced a lot of content. I will be using project going forward to manage my timelines so the overall understanding has helped.

S.C. Lansinoh, Microsoft Project Essentials

+ View More Training Reviews

 

Public Scheduled Course Dates

Prices per delegate. All prices exclude VAT.
17 Oct - 18 Oct 2024
in
Durham
,
£685
02 Dec - 03 Dec 2024
Virtual Course
,
£585
10 Apr - 11 Apr 2025
Virtual Course
,
£585
23 Jul - 24 Jul 2025
Virtual Course
,
£585
16 Oct - 17 Oct 2025
in
Durham
,
£685
01 Dec - 02 Dec 2025
Virtual Course
,
£585

Private Training

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

 

Please contact us to discuss your Access Essentials An Introduction to 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 Essentials An Introduction to 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 Essentials An Introduction to Database Design course.

General Information

Microsoft and Microsoft Access are Registered Trademarks Database Design course available throughout the North East including Durham, Newcastle, Washington, Darlington, Tyne and Wear, Gateshead and Sunderland. Access Database Design training courses available in Durham, Newcastle, Washington, Darlington, Sunderland, Tyneside, and throughout North East England. Database Design using Microsoft Access training courses.
IT Training Solutions Ltd
Oakville, 14 Durham Road West, Bowburn, Durham, DH6 5AU
0191 377 8377
ittrainingsolutions.co.uk
Printed:10/9/2024 1:16:15 AM