Microsoft Access Training
At a basic level, you can use Access to develop simple, personal database-management systems. Some people accululate everything from their wine collections to their home finances.
Companies use Access to develop Customer Databases, Asset Databases and many more. Access makes it easier to not only store information but also to create user forms to suit the user run queries on the stored data and run reports.
Good database design will make a difference for the end user and the amount of effort required in finding the necessary information.
With the help of our excellent trainers, you can learn how to design database that will suit your requirements. From small, one table database design to big databases with multiple tables linked together and automated actions created in Visual Basics, we will be happy to assist with all aspects of database creation.
Please select the version that you’re interested from below:
Please select the level that you’re interested in
Microsoft Access 2016 Introduction
Course Overview
- Understand Database Concepts and Objects
- Create, Edit and Maintain Tables
- Create Queries
- Create Forms
- Create Reports
- Create Relational Tables, Forms, Queries and Reports
Audience:
This course is designed for new or self-taught Microsoft Access users. It covers all aspects of database design and objects.
Prerequisite:
No Prior experience or knowledge of databases is required to attend this course. You must have good basic Microsoft Windows, keyboard and mouse skills.
Duration:
This is a 2 day MS Access Introduction course. The course starts at 09:30 and runs until 16:30. Alternate timings can be arranged upon request. The course can be held on a date that suits you.
Location:
Our Microsoft Access Introduction course can be run at our training venue near Liverpool Street (London) or any preferred location in the UK or Europe.
Access 2016 Introduction Course Outline
ACCESS BASICSFamiliarity with access screen Ribbon and toolbar explanations Prebuilt database template access and creation Database Terms Planning An explanation of databases in general, database objects within access and terminology Plan your Database (Tables, Queries, Forms, Reports, Macros, Pages and Modules) Plan a database structure (tables) (normalisation techniques) Create a new database file WORKING WITH TABLESDesign a table, conventions for entering naming objects and fields (Design View) Create a table in datasheet view and edit field names Select data types and enter field descriptions Set a Primary Key Remove a Primary Key Define field properties (Default values, Input masks, Validation rules and format options) Insert, Delete, Move and Rename Fields (design view and datasheet view) Create a table with a wizard Using the ribbon to set field properties Entering and Editing Data Accessing objects through the navigation pane Switch between object Tabs Switch Views in Access (design, layout and data entry) Entering and Editing Data (Records & Fields) Navigating the datasheet Working in Data Entry Mode Sorting Data, Finding & Replacing Data Hiding and Unhiding Fields Create multiple tables to normalise data Relationships RELATIONSHIPS EXPLAINEDDifferent types of relationships Conditions needed for setting up a relationship Ensuring Referential Integrity Printing Relationships in a Report Insert Sub Datasheets into a table Change or remove Sub Datasheets from a table Expand and Contract Sub Datasheets Enter data in related tables QUERIES & FILTERSCreate a filter by selection Create a filter by form Use AND/ OR options Save a filter as a select query Run a Select Query Build a query from the create ribbon Creating a query using a wizard | Build a query using the Query Design Window Adding fields to a query, choose which fields to showRemoving fields from a query Sort data in a select query Enter Text, numeric, date, and logic criteria Enter sub string searches using wild Card Characters Use the BETWEEN, AND, OR, NOT, NULL criteria in your query Calculate a field Concatenate text Save and name a query Rename, edit or delete a query Multi Table Queries Build a query across more than one table Joining Tables for a query (more relationships) Setting Join Properties – Inner and Outer Joins Find Unmatched records Query Wizard Find Duplicate records Query Wizard CREATING FORMSCreate a Form using the Auto Form tool Tabular/Datasheet/Pivot Form wizard Create a Form using the Form Wizard Create a form in design view Create a form in layout view Understand the views and switch between them Setting data source for a form Setting the data source using SQL source code The Field List Resizing Forms Control types Adding controls Resize and Move Controls Changing control properties Selecting Controls Formatting Controls Use the Format Painter and AutoFormat Set basic form properties Data Entry in Forms Navigation in data entry view Add, edit, delete a record in form view REPORTSStandard Reports using Wizard Insert, Move, Size and delete controls Editing record source Page setup Print your report |
One to One
(which includes a tailor-made training programme for the individual where they can mix and match the topics from various levels to get the most cost-effective training
Group for up to 8 learners
What Our Clients Say
Extras
This is a sample of some of the Short training videos. Please note that you can get access to many more, once you have done a course with us and are registered as one of our delegates.