Access Foundation

Oak Tree Management & Training Ltd.
Birmingham, Bristol, Cambridge, Edinburgh, London, Manchester, Newcastle, Nottingham, United Kingdom

Course Format: Classroom | E-learning | Virtual Class | Online/Live | On-site/In-house | Blended | Self-paced

Course Description:

'' The course introduces the delegates to the fundamental skills required to build and use a simple Access database. It is specifically designed for the first time user and those that are self-taught. It will act as an ideal stepping-stone to attending the more task based Access courses we offer.

The foundation skills will be explored through the creation of an Access database encompassing several tables (not related) and forms for data entry and manipulation. Simple queries and reports will be used to select and print reports.

The course is designed to provide an understanding and use of the four main objects (Tables, Forms, Queries & Reports). Each section will provide the delegate with the knowledge to be able to be productive on their return to work.

A concentrated one day overview to be able to create and use a simple access database
Understand the Access environment
Be productive in Access fundamentals from day one
Provide the building blocks for the more detailed courses
From concept to reports in one day
Course Objectives
By the end of the course the delegate will be able to:

Understand the concept of database design
Create tables to store data
Produce forms for data entry
Append, find and edit data in a table and form
Produce queries to extract only specific records
Share the data with others on a report
Course Contents
Access Overview
What is a database
Object explanation
Role Definition
Access Objects
Moving between objects
Planning and Designing Databases
Database Objective
Scope Document
Planning and Designing Databases �Tables & Forms
Document table structure
Field Types - Text, Number, Date, Yes/No, Memo and AutoNumber
Identify Field Sizes
Identify the Primary Key
Form Considerations - Data Entry
Creating Tables
Building and Modifying Tables
Screen Familiarisation
Field Descriptions
Assigning the Primary Keys
Assigning Data Types
Assigning Field Sizes
Building and Modifying Forms
Create a form with the Form Wizard
Basic Editing of Forms
Data Management
Appending Records
Delete records
Editing Data
Views
Switching between Design and View
Finding, Filtering & Sorting
Find a record
Filter by selection
Sort records
Select Queries
Data Sources
Field Selection
Selection Criteria Overview
Show/Hide
Logical Operators
Reports
Create a report with the Report Wizard
Preview and print a report Screen Familiarity ...''

Elements of this syllabus are subject to change.

Phone:(01284) 763040

School Address/Venue(s):

Park Farm Business Centre
Fornham St Genevieve
Bury St Edmunds
Suffolk
United Kingdom
IP28 6TS

Jobs & Resumes: Birmingham, Bristol, Cambridge, Edinburgh, London, Manchester, Newcastle, Nottingham
Houses & Roommates: Birmingham, Bristol, Cambridge, Edinburgh, London, Manchester, Newcastle, Nottingham
Travel Agencies: Birmingham, Bristol, Cambridge, Edinburgh, London, Manchester, Nottingham

Search other schools for Access Foundation training resources.

Managing Office Safety & Display Screen Equipment Assessments
Lift Truck Operator
IOSH Supervising Safely Certificate
Fire Marshals & Fire Risk Assessment
Fire Marshal and Practical Fire Extinguisher
Cranes & Lifting Operation
Confined Spaces
Health and Safety in Health and Social Care
Health & Safety in the Workplace
Access Intermediate
Access VBA
Access Working with Queries
Acrobat
Illustrator CS
InDesign CS
PageMaker 7
Photoshop CS2

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: You do not need to register before you can use most of our services. You will get a code for each posting ever made on this website. It is the key for you to remove the posting anytime by yourself.