Course
Access Essentials An Introduction to Database Design
Course Duration
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 Dates
<<
<
>
Public scheduled prices per delegate +VAT
Private courses start from £1490 for up to 8 delegates
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.
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
-
- Comprehensive course materials and exercises
- Telephone and Email Support
- Lunch and refreshments when training is delivered at our training venues
Course Content
-
Database theoryExplanation of the components that make up a database
-
TablesTable creation methods
Primary Keys
Choosing data types
Field properties and Validation options
Adding a Lookup field to a table, exploring different methods
-
RelationshipsUnderstanding 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 -
QueriesCreating 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 -
FormsUnderstanding 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 -
ReportsCreating reports from your database using the report Wizard
Portrait or Landscape layout
Editing the layout of a Report once created
Printing Reports
"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
Other Courses In This Series
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 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 This course is aimed at those who would like to develop their skills and knowledge of VBA programming in Access application development.
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 class sizes. Course materials included. Flexible course content. Expert trainers and tried & tested training methods. Course materials available online using your personal training account.
You can master access, please contact us to book a place or request a quote.
-
Course Options
Please contact us to discuss options for this coursePublic ScheduledPublic ScheduledFixed 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 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.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
IT Training Solutions Ltd
Oakville, 14 Durham Road West, Bowburn, Durham, DH6 5AU
0191 377 8377
ittrainingsolutions.co.uk
Printed:4/26/2024 5:52:54 AM
Oakville, 14 Durham Road West, Bowburn, Durham, DH6 5AU
0191 377 8377
ittrainingsolutions.co.uk
Printed:4/26/2024 5:52:54 AM