Microsoft Access Training
Excel is one of the most widely used software packages currently in use. The package can be used for a variety of tasks. On a basic level, you can use Excel for creating tables, storing data and setting up simple calculations like addition, multiplication, division or subtraction.
For more demanding uses, Excel can be used to create charts, automate spreadsheets, apply advanced formulas, create Pivot tables and much much more!
Please select the version that you’re interested in
Please select the version that you’re interested in
Microsoft Access 2016 Introduction
Course Overview
- Create and maintain spreadsheets
- Create and edit formulae and Functions
- Format and print worksheets
- Perform basic list management task
- Sharing and Tracking Workbooks
- Basic Charts
- Basic Conditional Formatting
- Basic Formula Auditing
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 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.