Access Intermediate

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:

'' With the increase in the use of databases to store data, end users are creating tables with no formal understanding or appreciation of the bigger picture which can result in unusable, time-consuming systems being created. Any database system is only as good as the person who created the tables. Getting this wrong is an expensive business as the data may have to be manipulated several times before it can become useful. It pays to get table design right before creating more complex forms and reports.

A focused course on Table design
Understand the theory behind table design best practice
Understand specification for good form design
Transferable skills to other database applications as the principals are the same
Reduce or eliminate repetitive data through table relationships
Practical examples of good and bad report or form design
Course Objectives
By the end of the course the delegate will be able to:

Explain and Implement design theory
Create table structure documents
Normalise tables
Understand and create relationships
Implement good Form design techniques
Create usable reports
Course Contents
(Course Topics may vary at the Trainer’s Discretion)

Screen Familiarity
Planning and Designing Databases
Database Objective
Scope Document
Planning and Designing Databases - Tables
Review existing data sources
Normalisation
Field Types - Text, Number, Date, Yes/No, Memo and AutoNumber
OLE & Hyperlink Field Types
Identify Field Sizes
Identify the Primary Key
Identify Field Properties
Define table relationships
Creating Tables
Building and Modifying Tables
Assigning the Primary Keys
Identifying Foreign Keys
Field Properties - All
Data Validation - including logical
Lookup Wizard with Values
Indexing
Testing tables with Data Entry
Table Relationships
â™?Create Relationships
Enforce referential integrity
Planning and Designing Databases - Forms
Form Considerations - Data Entry
Form Considerations - Menu
Proto Types
Identify Data Sources
Building and Modifying Forms
Create a form with the Form Wizard
Use the Control Toolbox to add controls
Moving and resizing Objects
Modify Format Properties (font, style, font size, colour, caption, etc.) of controls
Use form sections (headers, footers, and detail)
Yes/No Alternatives
Tab Order
Enable and Locked Control
Adding Pages/Tabs
Adding Graphics to a Form
Creating Subforms
Reports
Create a Report with the Report Wizard
Move and resize a control
Modify Format Properties (font, style, font size, color, caption, etc.)
Calculated Reports
Use report sections (headers, footers, and detail) + Page Breaks
Adding graphics to a Report
Sort Options
Sub-Reports
Using Access Tools
Print Table Designs - Reporter
Back-up and restore a database
Compact A Database
Repair a Database
Importing data from Excel and Text files ...''

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 Intermediate 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 Foundation
Access VBA
Access Working with Queries
Acrobat
Illustrator CS
InDesign CS
PageMaker 7
Photoshop CS2
Crystal Reports - Advanced

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: If you can not find a training course suitable for you instantly, you can leave your training request here and let trainers contact you later.