You are viewing our UK computer training courseware site    

Cheltenham Courseware | Training materials for IT trainers, schools & ICDL / ECDL training

  Training Materials for:
  Microsoft Windows Vista  Windows Vista 
  Microsoft Windows XP  Windows XP 
  Microsoft Word 2007  Microsoft Word 2007 
  Microsoft Excel 2007  Microsoft Excel 2007 
  PowerPoint 2007 courseware materials PowerPoint 2007 
  Microsoft Access 2007  Microsoft Access 2007 
  Internet Explorer 7 Internet Explorer 7 
  Microsoft Outlook 2007  Outlook 2007 
  Expression Web
  Microsoft Project Microsoft Project
  Microsoft Publisher Microsoft Publisher
  Microsoft FrontPage Microsoft FrontPage
  Microsoft Visio Microsoft Visio
  Computer Concepts
  ECDL and ICDL - European Computer Driving Licence ECDL / ICDL Downloads
     
      PLUS MANY MORE ...

Download Computer Training Sample Courses
Complementary computer training materials.
About Cheltenham Courseware
ECDL & ICDL Courseware Materials
All these cousres are contained within the IT Courseware Library
Price List
Educational Discounts
ECDL Foundation Approved
Call us
Clients

ECDL / ICDL Module 5 (Syllabus Four) using Microsoft Access 2007
Databases Courseware

 

PLEASE NOTE: The ECDL / ICDL Courseware Library includes versions for Office 2000, Office XP, Office 2003 & Office 2007. Plus versions for Windows 2000, Windows XP and Windows Vista

 

ECDL / ICDL Courseware Training Manual

ACCESS 2007 DATABASE CONCEPTS

  • What is a database?
  • What is a relational database?
  • What is a table?
  • What is a record (row)?
  • What is a field (column)?
  • What is data?
  • Data types

 

A FIRST LOOK AT ACCESS 2007

  • Opening Access 2007
  • Exploring the Access 2007 window
  • The Ribbon (Toolbar)
  • Ribbon tabs
  • Groups & Dialog Box Launcher
  • Navigating - Quick keys (shortcut keys)
  • Navigating – Pointer keys & quick keys
  • Navigating – Mouse wheel
  • Contextual tabs
  • Minimising the Ribbon
  • Quick Access Toolbar
  • The Office Button
  • Microsoft Access Help

 

OPENING A DATABASE & SECURITY ISSUES

  • Opening a database
  • Security warnings
  • Trusted Locations - Trust Centre
  • Setting the default folder location within Access

 

CREATING A DATABASE & USING VIEWS

  • Creating a new database
  • Creating a new blank database
  • Saving a table
  • Adding and renaming fields
  • Using Datasheet View
  • Using Design View
  • Changing the view

 

TABLE MODIFICATION AND NAVIGATION

  • Adding Fields - Design View
  • Data Type - Overview
  • Data Type - Descriptions
  • Using the Attachment data type
  • Adjusting column width
  • Moving a column to rearrange the column order
  • Adding records to a table
  • Navigating through records within a table
  • Closing a database
  • Navigation Pane

 

FIELD PROPERTIES, VALIDATION & INPUT MASKS

  • Field Properties
  • Input Mask
  • Validation Rules
  • Field Properties - Guides Tables

 

MANIPULATING RECORDS & TABLES

  • Closing an Object - Table
  • Renaming an Object - Table
  • Editing data within a record
  • Deleting data within a record
  • Using the Undo command
  • Deleting a single record
  • Deleting multiple records
  • Save As – Database Object
  • Deleting a table

 

PRIMARY KEYS AND INDEXING

  • Defining a Primary Key
  • Indexing
  • Creating a single-field Index
  • Creating a multiple-field Index
  • Deleting multi-field indexes

 

FILTERING & SORTING

  • Text Filters
  • Applying a single filter
  • Clearing a single filter
  • Creating multiple filters
  • Clearing multiple filters
  • Sorting

 

RELATIONSHIPS

  • Table relationships
  • One-to-many relationship
  • Many-to-many relationship
  • One-to-one relationships
  • Creating relationships between tables
  • Referential integrity
  • Cascade options
  • Cascade update related fields
  • Cascade delete related records
  • Enabling cascade options
  • Deleting relationships

 

ACCESS 2007 FORMS

  • Forms overview
  • Creating forms
  • Modifying forms
  • Modifying a form title
  • Modifying a form logo
  • Modifying a form label
  • Saving a form
  • Form View
  • Adding and formatting attachments
  • Modifying records
  • Deleting records
  • Adding records
  • Closing forms
  • Opening forms
  • Deleting a form

 

ACCESS 2007 QUERIES

  • What are queries?
  • Creating a simple query
  • Adding criteria to a query
  • Running a query
  • Editing criteria in a query
  • Saving a query
  • Creating a two table query and sorting the results
  • Deleting a query

 

ACCESS 2007 REPORTS

  • What are reports?
  • Creating a simple report
  • Using the Report Wizard
  • Modifying the layout of a report
  • Widening a report column
  • Modifying the report title
  • Adding logos to a report
  • Autoformating a report
  • Modifying field names within a report
  • Inserting and formatting the date & time
  • Adding available fields to a report
  • Resizing reports for printing
  • Closing a report
  • Deleting a report

 

ACCESS 2007 PRINTING ISSUES

  • Considerations before printing
  • Print previewing
  • Which orientation, portrait or landscape?
  • Adjusting layout in Print Preview
  • Setting margins
  • Printing a complete table
  • Printing selected records
  • Printing a query or reports
  • Printing forms

ICDL downloads

ECDL | European Computer Driving Licence
ICDL | International Computer Driving Licence

Other ECDL / ICDL Courseware Training materials

 

 


   Home | Download Computer Courseware Samples | IT Course Outlines | ECDL / ICDL Courseware | Site Map | FAQs 
    What's New | Download Sample ECDL / ICDL Training Materials | NewsletterContact UsAbout Us

    UK   USA Canada Australia International  
   © 1995-2008 Cheltenham Courseware Pty. Ltd. All trademarks acknowledged.  Terms & Conditions
   Course content subject to change without notice.

Now download complete samples of all our courses
Download Computer Training Sample Courses


   
Consider the benefits of investing in quality computer courseware materials:  
    For schools, colleges, professional IT trainers & computer training companies

   
You get  duplication rights for all 150+ computer courses when you invest in the 'Courseware Library'