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

Overview & Prerequisite

This course is designed for new users of Access 2007 who have attended a Windows Foundation course or who have previous experience in the use of Windows. This course is aimed at those people who will be designing the database

Course content

Getting Started with 2007
Using the Ribbon instead of menus
The Quick Access Toolbar
Command Tabs
Contextual Command Tabs
The New File Menu

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 2007

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

 


2000-2011 iTrain Scotland