Access Data Management
Training
In London
Description
-
Type
Training
-
Location
London
-
Duration
1 Day
To give users an introduction to Access. Delegates will gain an understanding of some of the major features and functions within Access and the advantages of using a relational database running under Windows. Suitable for: This course is suitable for new, recent or intending users of Access who have little or no existing database knowledge.
Facilities
Location
Start date
Start date
About this course
A basic understanding of Windows is required, gained either by previous experience or by attendance on an Windows/Internet - Easy Start course.
Reviews
Course programme
Delegate numbers are restricted to 8, to ensure personal attention from the trainer.
Access data management (introduction)
Course outlines
Introduction To Databasees
What is a Database?
Computerising a Database
Designing an Access Database
Defining a Data Store
Populating a Database
Extracting Information Form a Database
Reporting Data
Getting Started with Access
Starting Access
Access Opening Screen
The Title Bar
The Menu Bar
Toolbars
Menus and Submenus
Speedkeys
The Database Window
The Database Window Toolbar
Scroll Bars
Exciting Access
Getting Assistance with Access
Using the Office Assistant
Getting Help without the Office Assistant
Manipulating the Help Window
Help for Screen Objects – Screentips
Creating Tables and Adding Records
Creating a Table Using the Table Wizard
Datasheet View
Adding a Record
Saving Changes
Moving Around the Datasheet
Finding a Record
Modifying Records
Deleting a Record
Designing Table Structures
Table Design – Hints and Tips
Creating Tables
Switching Between Views
Saving Tables
Field Properties
Field Size Property
Working With Data
Sorting Data
Filtering Data
Simple Select Queries
What is a Query?
Creating a Query
Modifying a Query
Restricting Records Returned by a Query
Summary Queries
Forms
What is a Form?
Using Autoform to Design Forms
Using Wizards to Design Forms
Entering Data Using a Form
Simple Reports
Printing Form Datasheet View
Autoreports
Designing a Report Using Report
Wizards
Label Reports
Modifying Reports
Access Tools
Backing up and Restoring a Database
Compacting And Reparing A Database
Price: £220+VAT
Additional information
Payment options: All Courses can be held privately at our premises or otherwise.
Access Data Management