Microsoft Access Training – Introduction / Intermediate
Course
In London
Description
-
Type
Course
-
Location
London
This introductory Microsoft Access training course will teach you the fundamentals of using Access.
Microsoft Access is a popular database programme enabling the user to manipulate data in a number of ways. Data can be analysed and sorted, specific information can be searched for, and the results can be used to produce reports, lists and more.
This course is instructor led, involves the use of a number of examples and exercises in a workshop environment to bring the classroom teaching to life. The course is led by an experienced Access trainer.
Facilities
Location
Start date
Start date
About this course
Our two day Microsoft Access Introduction / Intermediate course will equip you with the skills to create your own databases to manage your information more effectively. By the end of this training course, students will be able to describe and create databases, access, view and process data using queries, produce forms for data entry and view data in report format. You will be a confident user of Access.
At the completion of this course you should be able to:
understand how Access is used and how to navigate around it
design a database with lookup tables
create a database structure using Access
modify the structure of an existing table
set table relationships and join tables together
add records to a new table
add transactional records to a lookup database
use various data validation features in Access to protect data
work with the records in a database table
format the data in a table
sort and filter records in a table
export records to and import records from a wide variety of sources and applications
create simple and effective queries
perform more advanced queries using a variety of querying techniques
create queries based on one or more tables
create and use parameter queries
create calculated queries
create meaningful reports from tables
create and use forms.
It is assumed that delegates have little or no knowledge of the software. However, it would be beneficial to have a general understanding of personal computers and the Windows operating system environment
Our courses run from 9.30 am to approximately 4.15pm. While you are with us we are focused on offering you a relaxed and productive learning environment. When you book a course with use you get the following:
A full colour training manual/book.
The exercises that you have worked on during your course to allow you to practice afterwards.
USB stick to take the exercises away.
Certificate of attendance
Freshly prepared lunch.
Refreshments throughout the day.
Training in fully air conditioned facilities from an experienced instructor.
Reviews
-
.
← | →
Course rating
Recommended
Centre rating
Jackie Joseph
This centre's achievements
All courses are up to date
The average rating is higher than 3.7
More than 50 reviews in the last 12 months
This centre has featured on Emagister for 10 years
Subjects
- MS Excel
- Printing
- Microsoft Excel
- Excel
- Access
- Windows
- Database
- Database training
- Teaching
- Basic Skills
- Design
- Typing
- Microsoft excel training
- Microsoft Access
Course programme
- Understanding Microsoft Access
- Starting Access From the Windows Start Screen
- Starting Access From the Desktop
- Understanding the Start Screen
- Creating a New Blank Database
- Understanding the Backstage View
- Opening an Existing Database File
- Understanding the Access 2013 Screen
- Using the Ribbon
- Working With the Navigation Pane
- Adding Commands to the QAT
- Working With Touch Mode
- Working With a Table
- Working With Other Database Objects
- Closing a Database File
- Exiting From Access
- Understanding How Access Stores Data
- Understanding Access Data Types
- Scoping Your New Database
- Identifying Table Problems
- Refining Table Structures
- Finalising the Design
- Creating A New Database File
- Creating the Lookup Table
- Defining the Primary Key
- Saving and Closing A Table
- Creating the Transaction Table
- Understanding Lookup Table Relationships
- Connecting To A Lookup Table
- Viewing Table Relationships
- Opening an Existing Table
- Adding Fields to an Existing Table
- Understanding Field Properties
- Changing Field Size
- Changing Field Names
- Changing Decimal Places
- Changing Date Formats
- Indexing Fields
- Deleting Fields From a Table
- Copying a Table Within a Database
- Deleting a Table From a Database File
- Understanding Table Relationships
- Understanding Lookup Relationships
- Looking Up the Employees Table
- Looking Up the Expense Types Table
- Viewing Table Relationships
- Understanding Table Joins
- Editing the Employee Table Join
- Editing the Expense Type Table Join
- Creating a New Join
- Creating a Relationship Report
- Typing Records In A Table
- Adding Records Using A Form
- Saving A Form Layout For Reuse
- Adding Records Using An Existing Form
- Assignment – Adding Records
- Importing From Microsoft Excel
- Typing Transactional Records
- Transactional Records Using A Form
- Assignment – Adding Transactional Records
- Adding Records Using A Subdatasheet
- Removing A Subdatasheet
- Inserting A Subdatasheet
- Assigning Default Values
- Validation Rules and Text
- Validating Numbers
- Setting Required Fields
- Working With Validations
- Table Navigation
- Navigating to a Specific Record
- Editing a Record
- Deleting Record Data
- Undoing a Change
- Deleting a Record
- Deleting Several Records
- Searching in a Table
- Searching in a Field
- Finding and Replacing
- Printing Records From a Table
- Compacting a Database
- Changing Column Widths
- Formatting Cells In The Table
- Changing Fonts
- Moving Columns In A Table
- Freezing Columns In A Table
- Hiding Columns In A Table
- Unhiding Columns
- Simple Sorting
- Sorting On Several Fields
- Simple Filtering
- Working With Filters
- Exporting Records to Microsoft Excel
- Exporting Records to a Text File
- Importing From Microsoft Excel
- Importing From a Text File
- Linking to an External Source
- Understanding Queries
- Creating A Query Design
- Working With A Query
- Changing A Query Design
- Applying Record Criteria
- Clearing Selection Criteria
- Saving A Query
- Running Queries Via The Navigation Pane
- Deleting A Query
- Assignment – Creating Queries
- Modifying A Saved Query
- Creating AND Queries
- Creating OR Queries
- Querying Numeric Data
- Querying Dates
- Using A Range Expression
- Querying Opposite Values
- Moving Fields In A Query
- Sorting Query Data
- Removing Fields From A Query
- Querying Using Wildcards
- Problem Characters
- Querying With A Lookup Table
- Sorting Query Data Numerically
- Displaying NULL Values
- Querying for Uniqueness
- Understanding Relational Queries
- Creating a Relational Query Design
- Filtering a Relational Query
- Filtering Related Fields
- Adding More Tables and Fields
- Utilising Hidden Fields
- Understanding Query Joins
- Creating an Inner Join
- Creating a Left Outer Join
- Creating a Right Outer Join
- Creating a Parameter Query
- Displaying All Using Parameters to Display a Range
- Using Parameters in Expressions
- Using Parameters With Wildcards
- Creating a Calculated Field
- Formatting Calculated Fields
- Summarising Data Using a Query
- Changing the Grouping
- Calculating With Dates
- Using Criteria in Calculations
- Concatenating String Fields
- Understanding Reporting In Access
- Creating A Basic Report
- Working With Existing Reports
- Previewing and Printing A Report
- Changing The Report Layout
- Using The Report Wizard
- Creating A Grouped Report
- Creating A Statistical Report
- Working With Grouped Reports
- Understanding Forms
- Creating A Basic Form
- Creating A Split Form
- Binding A Form To A Query
- Using The Form Wizard
- Working With Existing Forms
- Editing Records In A Form
- Deleting Records Through A Form
- Deleting An Unwanted Form
Microsoft Access Training – Introduction / Intermediate