Rates are based on those published by the European Central Bank. Please note that these rates are indicative and may differ from those used to calculate prices on our site. If purchasing in GBP, EUR or USD on our site the rates listed on the product pages will be what is used at checkout.
MS Access 2013: Introduction
Price is per online user of this course. EU applicable VAT added.
In this introductory course you will become acquainted with the program environment and the used terminology. You will learn how to design tables and link the individual tables with each other via relations.
Having good Microsoft Access knowledge and skills is extremely beneficial to add to your CV and to demonstrate in the workplace.
In the Access Introduction course you will familiarise yourself with the terminology concerning relational databases and with the basics of working in the Access program. You will try various ways of creating tables and setting the properties of their fields. You will learn to further analyse the data in tables through select queries, including the creation of calculated fields in them. You will set relations between tables and ensure their referential integrity. You will also familiarise yourself with an easy way of creating simple forms and reports.
Introduction to databases and their objects
Creating a table in the Datasheet View
Design view of tables
Advanced field data types
Restricting data input in tables
Analysis of relationships between tables
Relationships between tables
Navigation in tables
Searching for records and editing them
Sorting and filtering data in tables
Creating a select query
Criteria in select queries
Calculated fields in queries
Joining tables for the purpose of a query
Lookup columns in tables
Editing a lookup column
Automatic creation of forms
For multiple purchase discounts or to find out if discounts are available on mixed course purchases please phone a customer advisor on 0844 854 9218.
Discounts are calculated during the checkout process.
The most straight forward method of payment is to select the number of users you require and add the product to your shopping cart by selecting Add to Cart. You will then be able to make payment using most credit and debit cards or a Paypal account. If you would like to pay by BACs transfer or by invoice please contact a customer advisor on 0844 854 9218 or email firstname.lastname@example.org.
Please note that there may be similar courses available with immediate access elsewhere on our site.
Receive Our Newsletter
Keep up to date with what’s happening in the world of education, training and skills. Receive details of offers and newly launched courses, and tips on effective online and blended learning practise by signing up to our monthly newsletter. We guarantee not to sell or pass on your details and you can unsubscribe at any time.