Access Essentials An Introduction to Database Design
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.
- 2 Days
- Online or in person
- Private courses available
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.
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.
Included
- Comprehensive course materials and exercises
- Telephone and Email Support
- Lunch and refreshments when training is delivered at our training venues
Course content Back to top
-
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 dates and prices Back to top
Prices are per delegate and exclude VAT.
-
Monday 30 November 2026
£585+ VAT
-
Tuesday 16 March 2027
£585+ VAT
-
Tuesday 16 March 2027
£685+ VAT
-
Tuesday 16 March 2027
£585+ VAT
-
Wednesday 21 July 2027
£585+ VAT
-
Wednesday 21 July 2027
£685+ VAT
-
Wednesday 21 July 2027
£585+ VAT
-
Monday 29 November 2027
£585+ VAT
-
Monday 29 November 2027
£685+ VAT
-
Monday 29 November 2027
£585+ VAT
Can't make these dates? Ask about a private course on a date that suits you.
Training a team?
Run this course privately, on your dates
What delegates say Back to top
“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.”
What other courses would you like to attend
“Stuart was very helpful and has a very good way of getting the point accross”
Which part of the course did you find particularly valuable
“All of it was excellent”
“Brilliant course”
Following this training what are you going to do differently
“Now feel confident to try out DAX in calculations and to make alterations to layouts, etc.”
“Honestly found everything on the course extremely useful. It has shown simpler, easier ways to create things in Excel and shown me how easy and useful Excel can be.”
“The course offers everything it says it does.”
“Everything was clear and straight forward”
Other courses in this series Back to top
- You are here Access Essentials An Introduction to Database Design
-
Access Advanced Database Design
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…
-
VBA Essentials using Access
This course is aimed at those who would like to develop their skills and knowledge of VBA programming in Access application development.
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 get a quote for your Access Essentials An Introduction to Database Design course.
Oakville, 14 Durham Road West, Bowburn, Durham, DH6 5AU
0191 377 8377
ittrainingsolutions.co.uk
Printed: 10/20/2026 10:16:15 PM