side bar:  IT Training, computer training in Scotland, Edinburgh iTrain Scotland Logo:  Phone us on 07711 341 320. Superior computer training for microsoft word, excel, access, office 97, office 2000, office xp, macromedia dreamweaver, fireworks, web design side bar:  IT Training, computer training in Scotland, Edinburgh
Go Back to courses
   
Access 2010: Intermediate
   

Overview & Prerequisite

This course is designed for existing users of Access 2010 or those who have attended a foundation course. This course is aimed at those people who will be designing the database.

Course content

Getting Started with 2010
Using the Ribbon instead of menus
The Quick Access Toolbar
Command Tabs
Contextual Command Tabs
Microsoft Back Office replaces the File menu

Customise the Ribbon!


Query
Action Query
Parameter Query
Crosstab Query
Ad hoc Joins
Setting Counter
Calculated Fields

Introduction to Relational Database
Concepts
Basic Relationships
Referential Integrity
One-to-One
One-to-Many
Cascade Delete
Cascade Update

Book Now or Enquire


Advanced Form
Main/Sub
Lookup
Command Buttons
Combo Boxes
Calculated Fields

Reports
Design
Mailing Labels
Group/Sort
Word Mail Merge
Analysis with Excel
Create Chart

New Features of Access 2010

New General Features
Getting Started Window
Navigation Pane
Status Bar
Tabbed documents
File Type
Help
Security
Formatting
New Table Features
Sorting and Filtering
Field Enhancements
Data Type Recognition
Datasheet Total Row
Adding Fields
New Form and Report Features
Quick Create
New Layout Views
New Report View
Split Forms
Group and Sort
Stacked and Tabular Layouts
New Integration Features
Import and Export Wizards
Data Collection
SharePoint Services

Book Now or Enquire


 

| home | why choose us | courses | contact us |
2000-2011 iTrain Scotland - Site Last Updated: September 29, 2010