Remote/Online Microsoft Access Training Courses Learn how to create Desktop databases for business solutions
Due to COVID-19 we are now offering our courses remotely helping you structure your day and focus on learning a new skill. Courses are small - up to 4 delegates only. We post your course materials out to you and then send course joining instructions ensuring you have everything you need for a successful and engaging day.
Would you like to gain the skills to create a database to store your information, then analyse and build reporting from it?
Whether you're planning for one or several people using the database, we will provide you with the skills to optimise, protect and administer your database with ease.
Understanding the concepts of database design is as important as understanding how to use the Microsoft Access software. Our trainers deliver training in a way you'll understand IT.
If a date we're advertising doesn't suit you, then please do ask as we may be able to run the course on dates that you require.
Microsoft Access Introduction Course - 2 Day Course
A comprehensive 2-day Microsoft Access training course suitable for complete beginners to Microsoft Access. After the training you will able to create a database from scratch. You will understand and be able to build tables, fields and records, set the rules for entering data and
create forms for input.
Also, you'll learn how to extract information in the form of simple queries and reports and export to Excel, PDF and mail merge. Our course also covers database design - essential knowledge when learning to build efficient databases and understanding how they work.
Prerequisite for attending this course: Must be comfortable with using a computer.
Microsoft Access Introduction training course outline - Two Day Course
Getting Started and Table Design
Create a new database
Overview of the Microsoft Access Environment
Object Naming conventions
Create new tables
Set field names
Choose data types
Consider and set field properties
Create a drop down list
Understanding Relationships
Create One to Many Relationships
Create One to One Relationships
Change Relationship Properties
Delete relationships between tables
Understand Referential Integrity
Work with Forms
Create a standard Form
Create a Form using the Wizard
Re-design a Form
Create a Form with a sub-form
Input data using Forms
Work with Queries
Create and save standard Queries
Sort data within a Query
Set criteria for Queries
Work with Operators and Expressions
Concatenate data within a Query
Create calculations in a Query
Use Parameter Query
Work with Reports
Create a report from Table data
Create a report from Query data
Group Information in a Report
Re-design Report elements
Create Mailing Labels
Export data from Microsoft Access
Export information to Microsoft Excel
Export information to Microsoft Word
Export information to a PDF file
Use the Mail Merge feature
Training Dates Delivered Live Online - 2 day course
Thu 28th & Fri 29th April 2022
Wed 29th & Thu 30th June 2022
Dates are not always set in stone, so if you can't make a date above, or would prefer something sooner, contact us anyway and we'll see what we can do for you. Training is delivered live online or at your company offices.
Microsoft Access Intermediate Course - 1 Day Course
A full day designed for those users who wish to step up their current knowledge of Microsoft Access to take advantage of the more complex features.
Learn to build a database application in a multi-user environment. Create advanced queries and reporting, working with interaction between Microsoft Access objects. Understand the power of macros for automation on this in-depth one day training course.
Prerequisite for attending this course: Delegates must have either attended our Introduction to Microsoft Access training course, or be comfortable with those topics covered at Introduction level.
Microsoft Access Intermediate training course outline - One Day Course
Design a Database
Understand and perform Normalisation
Create a new database
Understand relationship types
Know how to resolve a many to many relationship Import Data
Import data from Excel
Import data from a text file
Analyse imported data
Create an Interface
Create navigation forms
Use command buttons
Display a form at database start up Work with Forms
Insert Sub-Forms
Create Combo-boxes
Work with Attachment data types
Work with Queries and Reports
Create Action Queries
Use Functions in Queries
Supply parameters to a form from a Query
Use the Expression Builder
Change Query Joins Types
Create Cross-tab Queries
Create Total Queries
Build reports and summarise data Manage a Database
Back up a Database
Compact and Repair a Database
Password protect a Database
You have built databases to store and retrieve data. Now you may want to plan, design and administer your own database as a working system. A well-designed database allows easy maintenance and quick access of data. In this course, you will plan, design, create and administer a functional and efficient relational database which includes taking bookings, generating invoices and producing reports. You will learn to lock down the database and split into back end and front end. Our Microsoft Access Advanced course also includes function and macro design.
This course is suitable for those who have either attended our Microsoft Access Intermediate level training course or have a sound knowledge of database design and Microsoft Access.
Microsoft Access Advanced training course outline - Two Day Course
Design a Database
Perform Normalisation of data
Create a new database
Set relationships
Resolve a Many to Many and work with a junction table
Import data Work with Forms
Create a Combo Box Control
Create a List Box Control
Create an Option Group Control
Create a Tabbed Control and manage elements
Insert sub-forms on tabbed control with links
Identify and understand Form Properties Create Documents from a system
Build Queries to interact with other Access objects
Work with reports
Use unbound controls
Use bound controls
Write functions
Work with Macros
Create Macros to manage behaviour
Create Macros to Export
Use Macros to provide system messages
Assign Macros to database events
Work with Queries
Use Date Functions
Work with other Functions within Queries
Use Queries to generate data for Forms
Write Queries to generate data for Reports Database Management and Security
Set a database password
Discuss database security
Set the database start-up options
Split a database for use as a back-end and front end databases
Save a database as ACCDE
Training Dates
Please contact us and we'll arrange a course date to suit you
Would you like to gain the skills to create a database to store your information, then analyse and build reporting from it?
Whether you're planning for one or several people to use the database, we will provide you with the skills to build, optimise, protect and administer your database with ease.
Understanding the concepts of database design is as important as understanding how to use the Microsoft Access software.
Our trainers deliver IT training in a way you'll understand IT.
What our customers say
Book/Enquiry - Microsoft Access Training Course
Note: We will endeavour to book you on your desired course date, but if not, we will offer an alternative date.
Coronavirus - Remote / Online IT Training
In the current climate, we are offering training remotely.
Our experts will hook up with you via a remote connection and the course will be delivered this way.
Many companies are adopting this delivery method and it's working well to keep structure whilst working from home and providing something positive to focus on.
You can have a group session, or one to one, or attend a public course on which we are only enrolling 4 delegates.
You still have our after course support service for 1 year after delivery.
We will post out to you the course materials to work with during the training session.
Please contact us for further details: E: info@tcstraining.co.uk T: 02380 527816