Access Essentials An Introduction to Database Design
Course 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.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.
- 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 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
Included with this course
-
- Comprehensive course materials and exercises
- Telephone and Email Support
- Lunch and refreshments when training is delivered at our training venues
Public Scheduled Course Dates
Private Training
-
Public Dates
Prices per delegate. All prices exclude VAT.23 Jul - 24 Jul 2025Virtual£58516 Oct - 17 Oct 2025Durham£68501 Dec - 02 Dec 2025Virtual£585Private Courses
Private courseFlexible date and locationFrom£1690 +VAT for up to 8 delegates -
Access Essentials An Introduction to Database Design Course Options
Please contact us to discuss options for this coursePublic ScheduledPublic ScheduledFixed 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!PrivatePrivateFlexible 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.BespokeBespokeBespoke 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.VirtualVirtualThese courses can be attended from anywhere.
- Virtual Training
M. William Smith, Access Essentials An Introduction to Database Design
J.F. Encore Envelopes, Access Essentials An Introduction to Database Design
J.F. Encore Envelopes, Access Essentials An Introduction to Database Design
P.A. Nissan, Access Essentials An Introduction to Database Design
H.J. Innovation SuperNetwork, Adobe InDesign Level 1
N. Schlegel, Excel Level 1
J.I. NHS BSA, Microsoft Power BI Desktop
J.M. LSL Property Services, Excel Level 2
Public Scheduled Courses
Private Courses
Other Courses In This Training Series
Access Advanced Database Design Course Course 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 VBA Essentials using Access Course Course Overview: This course is aimed at those who would like to develop their skills and knowledge of VBA programming in Access application development.
Oakville, 14 Durham Road West, Bowburn, Durham, DH6 5AU
0191 377 8377
ittrainingsolutions.co.uk
Printed:7/11/2025 3:00:35 AM