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: Foundation
   

Overview & Prerequisite

This course is designed for new users of Access 2010. 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!


Getting Started
Concepts
Screen Layout
Toolbar
Views
Creating Tables
Wizard
New Table
Field Names
Data Types
Primary Key
Properties
Save Table
Print Definition

Datasheet view
Record Entry
Cancel Record
Modify Record
Delete Record
Format Datasheet
Print/Preview
Hide/Show
Sort
Find

Filters
Edit/Sort
Apply
Field Selection

Book Now or Enquire


Form
Wizard
Create
Auto Form
Add Record
Views
Design Form
Design Layout
Toolbars
Controls
Selection Techniques
Align Control
Align Text
Vertical Spacing
Horizontal Spacing
Grids
Colour Palette
Adjust Tab Entry

Enhancing the Form
Adding Fields
Combo Boxes
List Boxes
Calculated Fields
Modify Properties

Basic Query
Select Query
Totals
Print Query

Basic Reports
Using Wizards

New Features of Access 2010

New General Features
Getting Started Window
Office Backstage View
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