MS Access 97 Introduction Training Course in London
Our MS Access 97 Introduction course is aimed at novice users who are really complete beginners in using the Application. Our aim is to build a strong foundation in Access to provide new users with a good understanding of the basic concepts of Microsoft Access.
Our accessible but thorough approach to your training is designed to take you through the fundamentals principles of Access and leave you with a functional knowledge of the necessary skills for today’s workplace.
Unlike training companies offering scheduled courses, we offer the alternative of your Microsoft Access Training Course delivered in central London on a date of your choice, either onsite or at our offices near Moorgate, Bank or Liverpool Street either 1 to 1 or as part of a group.
If this sounds like the training course you require, then please contact us on 020 7920 9500 or click the Contact Me Now button below. A member of our team will get back to you asap.
Microsoft Access 97 Introduction
MS Access Introduction Training Course Contents
Duration - This is a 2 day course starting at 09:30 until 16:30 each day
Course Objectives -To understand the concept and purpose of a database and to gain a good working knowledge of Access to be able to create and edit Access databases.
Screen Layout
Navigating Microsoft Access
Access Overview
Database Container
Tables
Queries
Forms
Reports
Macros
Pages
Modules
Grouping Favourites
Planning a Database
Designing a Database
Normalisation
Relational Databases
Creating Tables
Create a Database
Designing a Table
Rules for entering Field Names
Enter data types, field descriptions
Setting a Primary Key
Setting Multiple Primary Keys
Removing a Primary Key
Table Properties and Structure
Defining Field Properties
Working with Input masks
The Input Mask Wizard
Validation Rule
Validation text
Other field Properties
Insert fields
Delete fields
Move Fields
Rename Fields
Table Wizards
Entering and Editing Data
Switching Views in Access
Enter data into a table
Modify data in a table
Working in Data Entry Mode
Sorting Data
Finding & Replacing Data
Hiding and Unhiding Fields
Importing and linking data
Importing from Access and Excel
Linking to an external Access Database Table
Linking to an Excel Workbook using the Wizard
Renaming and Copying Tables
Using Filters and Select Queries
Create a filter by selection
Create a filter by form
Save a filter by form as a select query
Running a Select Query
The Query Design Window
Creating a query from the query window
Adding fields to a query
Display/Suppress the display of a field
Removing fields from a query
Specifying Text, numeric, date, and logic criteria
Specifying sub string searches using wild Card Characters
Working with multiple criteria
Working with Conditions - BETWEEN, AND, OR, NOT, NULL
Calculated fields
Simple Query Wizard
Removing fields from a query
Specifying Text, numeric, date, and logic criteria
Specifying sub string searches using wild Card Characters
Working with multiple criteria
Working with Conditions - BETWEEN, AND, OR, NOT, NULL
Calculated fields
Simple Query Wizard
Relationships
Why create relationships between tables?
Different types of relationships
Conditions for setting up a relationship
Referential Integrity
Cascade Update
Cascade Delete
Relationships Report
Inserting Subdatasheets
Removing Subdatasheets
Expanding and Contracting Subdatasheets
Multi-Table Queries
Multiple Table Queries
Joining Tables for a query
Join Properties - Inner and Outer Joins
Find Unmatched Query Wizard
Find Duplicates Query Wizard
Creating Forms
Creating Forms using the Auto Form Tabular/Datasheet/Pivot Form wizard
1-to-1 training courses are charged at £450 per day. (Our offices or your venue)
All IT training courses at our offices are charged at a daily rate of £695 per day, for 2 to 8 delegates.
We also offer training at your venue for £595 per day. If required, laptops are available at an additional £150 per day.
For courses outside the M25, trainer travel and accomodation expenses are not included in the above prices but are charged at cost.
Build your course
With our course builder form, you can choose your own topics and build a course that suits your needs and your time scale. Select a application below to go to the Course Builder page
MS Access 97 Introduction Training Course in London
Microsoft Access 97 Introduction
