Home  | Samples / Prices  | Courses  | What You Get  About Us  FAQs  Contact | ECDL / ICDL

             Cheltenham Courseware

UK Computer Courseware Irish Computer Courseware
Please select your region  
UK/Ireland | USA/Canada | Australia/International 


 

 COMPUTER COURSES

  MS Office 2010
  Courseware
  Word 2010 Foundation
  Word 2010 Intermediate
  Word 2010 Advanced
  Excel 2010 Foundation
  Excel 2010 Intermediate
  Excel 2010 Advanced
  Access 2010 Foundation
  Access 2010 Intermediate
  Access 2010 Advanced
  Outlook 2010 Basics
  PowerPoint 2010 Foundation
  PowerPoint 2010 Intermediate
  PowerPoint 2010 Advanced

  MS Office 2007
  Courseware

   Word 2007 Foundation

  Word 2007 Intermediate
  Word 2007 Advanced
  Excel 2007 Foundation
  Excel 2007 Intermediate
  Excel 2007 Advanced
  Access 2007 Foundation
  Access 2007 Intermediate
  Access 2007 Advanced
  Project 2007 Foundation
  Publisher 2007 Foundation
  Visio 2007 Foundation
  PowerPoint 2007 Foundation
  PowerPoint 2007 Intermediate
  PowerPoint 2007 Advanced
  Outlook 2007 Basics

  MS Office 2003 
  Courseware

   Word 2003 Foundation

  Word 2003 Intermediate
  Word 2003 Advanced
  Excel 2003 Foundation
  Excel 2003 Intermediate
  Excel 2003 Advanced
  Access 2003 Foundation
  Access 2003 Intermediate
  Access 2003 Advanced
  Access 2003 Basics
  Access 2003 Expert
  Project 2003 Foundation
  Publisher 2003 Foundation
  PowerPoint 2003 Foundation
  PowerPoint 2003 Intermediate
  PowerPoint 2003 Advanced
  Outlook 2003 Basics


  LONGER 2 LEVEL 
  COURSES

  MS Office 2010
  Courseware
 
  Word 2010 Basics
  Word 2010 Expert
  Excel 2010 Basics
  Excel 2010 Expert
  Access 2010 Basics
  Access 2010 Expert 
  Outlook 2010 Basics
  PowerPoint 2010 Basics
  PowerPoint 2010 Expert

  MS Office 2007
  Courseware


  Word 2007 Basics
  Word 2007 Expert
  Excel 2007 Basics
  Excel 2007 Expert
  Access 2007 Basics
  Access 2007 Expert
  Project 2007 Foundation
  Publisher 2007 Foundation
  Visio 2007 Foundation
  PowerPoint 2007 Basics
  PowerPoint 2007 Expert
  Outlook 2007 Basics

  MS Office 2003 
  Courseware


  Word 2003 Basics
  Word 2003 Expert
  Excel 2003 Basics
  Excel 2003 Expert
  Access 2003 Basics
  Access 2003 Expert
  Project 2003 Foundation
  Publisher 2003 Foundation
  PowerPoint 2003 Basics
  PowerPoint 2003 Expert


  ICT Courseware
  PC Basics
  Windows XP Basics
  Windows Vista Basics
  Windows 7 Basics
  Internet Explorer 8

 

Sample IT Training Materials

SEO training seminars, Perth, WA

 

Download MS Access 2010 Courseware SamplesMicrosoft Access 2010 Basics

Computer Courseware Training Materials for IT Trainers

Foundation / Intermediate level computer training materials for delivering training to your students, staff or clients.  A courseware site licence allows you to train an unlimited number of people, at your training center using these teaching resources.

Microsoft Access 2010 Basics CoursewareTraining Course Outlines 


DATABASE CONCEPTS

  • What is a database?
  • Database Examples
  • What is a relational database?
  • What is a table?
  • What is a record (row)?
  • What is a field (column)?
  • What is data?
  • The difference between data and information
  • Data types
  • Common uses of large-scale databases
  • Keeping data discrete
  • Each field should contain only one item
  • Database designers, database administrators and database users

OPENING A DATABASE & SECURITY ISSUES

  • Opening a database within your samples folder
  • Trusted Locations – Using the Trust Centre
  • Setting the default folder location within Access
  • Closing the Access program

TABLES, FIELDS AND FIELD TYPES

  • Creating a new blank database
  • Adding fields and setting the field type
  • About Access Data Types
  • Closing and naming a table

TABLE NAVIGATION & MODIFICATION

  • Opening a table within a database
  • Switching between ‘Datasheet View’ and ‘Design View’
  • Adding records to a table
  • Saving changes made to a table
  • Navigating through records within a table
  • Adjusting column width
  • Automatically resizing a column with to fit contents
  • Moving a column to rearrange the column order

FIELD PROPERTIES

  • Field Properties
  • Input Masks
  • Validating Numbers
  • Validating Dates
  • Data Entry Required / Not Required
  • Field Properties – Reference Materials
  • Field Properties – Logical Operators
  • Field Properties – Validation Rule Examples
  • Field Properties – General
  • Field Properties – Format
  • Field Properties – Input Mask Characters
  • Field Properties – Input Mask Examples

MANIPULATING TABLES & RECORDS

  • Renaming a table
  • Editing data within a record
  • Deleting data within a record
  • Using the Undo command
  • Deleting a single record
  • Deleting multiple records
  • Using Save As to backup the database using a different file name
  • Deleting a table

PRIMARY KEYS AND INDEXING

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

FILTERING

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

SORTING

  • Sorting Records A-Z
  • Sorting records Z-A
  • Removing a sort
  • Sorting on multiple fields

SEARCHING

  • Searching through records

RELATIONSHIPS

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

FORMS

  • Forms overview
  • Creating forms
  • Modifying forms
  • Modifying a form title
  • Changing a form logo
  • Modifying a form label
  • Saving a form
  • Form View
  • Adding and formatting attachments
  • Modifying data within records
  • Deleting records using a form
  • Adding records using a form
  • Adding or deleting text in a record using a form
  • Closing forms
  • Opening forms
  • Deleting a form
  • Filtering a form
  • Removing a filter form a form
  • Inserting and modifying a form header
  • Inserting and modifying a form footer

QUERIES

  • What are queries?
  • Creating a simple query
  • Adding (and removing) criteria to a query
  • Running a query
  • Editing criteria in a query
  • Saving a query
  • Creating a two table query and sorting the results
  • Refining your query
  • What are Wildcards?
  • Deleting a query
  • Hiding and un-hiding fields (columns) within a query

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 a logo to a report
  • Formatting a form using themes
  • Modifying field names within a report
  • Inserting and formatting the date & time
  • Adding existing fields to a report
  • Resizing reports for printing
  • Totals
  • Closing a report
  • Deleting a report

EXPORTING

  • What does exporting data mean?
  • What is a spread sheet format?
  • What is text only and CSV format?
  • What is a PDF file?
  • What is an XML file?
  • Exporting a table as an Excel file
  • Exporting a table as a text file (keeping data format & layout)
  • Exporting a table as a text CSV formatted file
  • Exporting a table as a PDF formatted file
  • Exporting a table as an XML formatted file

PRINTING

  • 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

Download Computer Courseware Samples REFERENCE: THE ACCESS 2010 INTERFACE

  • Opening the Access 2010 program
  • Opening a database within your samples folder
  • Opening a table
  • The Ribbon (Toolbar)
  • Ribbon tabs
  • Groups
  • Dialog box launcher
  • Navigating - Quick keys (shortcut keys)
  • Navigating – Pointer keys & quick keys
  • Contextual tabs
  • Minimizing the Ribbon
  • Quick Access Toolbar
  • The File tab
  • Microsoft Access Help
  • Closing Access 2010
  • Closing the Microsoft Access program
 
 

UK coursework   USA coursework Canada Australia coursework International Computer coursework  Privacy Policy
© 1995-2012 Cheltenham Courseware Pty. Ltd. All trademarks acknowledged. Terms & Conditions 
Course content subject to change without notice. Cheltenham Group | HTML Formatted Sample
Microsoft Word - Microsoft Excel - Microsoft Access - Microsoft PowerPoint - Microsoft Windows | Prices & Ordering | Computer Courseware Samples | FAQs | Cheltenham Group | About Us | Contact UsECDL UK Instructor-led Courseware  |  ECDL / ICDL International Courseware | Site Map | Home Page |  Perth SEO
SEO training seminars, Perth, WA
           
Computer Training resources for IT trainers inc Microsoft Office 2010


  Customisable Courseware
  No Annual Renewal Fees
  Unlimited Number of Users
  Unlimited Reprinting Rights
  PLUS Intranet Versions


Please select your region  
UK/Ireland | USA/Canada | Australia/International 

   Computer Training Courseware for IT Teaching Professionals
    Quality courseware materials for tutor-led computer training:  
    For schools, colleges, IT trainers, corporate training departments, & computer training companies.