Ordering Details

web/2571
Access 2007 - Databases Using Access
£29
33 pages of worksheets + certificate
Available for immediate dispatch
Preview Add to basket
To order, contact us by:
T: 0117 950 3199   F: 0117 959 1695
E: orders@zigzageducation.co.uk
P: ZigZag Education, Unit 3, Greenway Business Centre, Doncaster Road, Bristol BS10 5PY

A cheque must accompany private postal orders. All prices are VAT zero-rated unless specifically stated otherwise. Unless stated otherwise, P&P is £3 per order (if within UK).

Pre-order Items

Pre-order resources will either have a single dispatch date or a date range. Where there is a date range:
  • The earlier date is the best-case scenario the date by which we aim to dispatch the resource to you, if the resource sails through quality and similar checks.
  • The later date is given to indicate the latest date by which you should expect the resource to be dispatched.

These dispatch dates may occasionally be moved back, in which case we will notify you. Conversely, publications are often delivered earlier than the dates shown.

For more information, and to see the full list of pre-order items for your subject, see the Future Publication Dates


Email Alerts

Register below to be told when new resources are available for preview and dispatch.
Close


The Access Range


Databases Using Access

This set of worksheets covers tables, forms & design, query basics, reports, mailing labels, normalisation, SQL and project ideas.

The resource has:
  • Helpful need to Know Sections
  • Tips! Boxes
  • Remember! Boxes
  • Know This! Boxes

This course of worksheets is designed to help you through A level Computing/ICT. By completing the exercises, you will gradually build up knowledge of Microsoft's database software package Access 2003. By the time you finish all the worksheets, you'll have created a working relational database.

Learning Access by Example:

Creates a library database with step-by-step instructions in a set of 10 worksheets. From the blank database at the beginning, to a complete fully functional database at the end. The resource covers: Creating & linking tables, forms, macros, queries, reports, searches and more!

Short Access Tasks

The collection of short tasks in this resource are progressively more difficult, taking from 10 to 30 minutes each.

Includes:
  • Hints encourage efficient approach
  • Extensions to stretch the most able
  • Fully Worked Solutions.

Names of tasks:

  • Creating a Table
  • Select Query: Viewing Data
  • Creating a Form to Append Data to a Table
  • Defining and Changing the Primary Key
  • Marking Relationships
  • Complex Query
  • Action Query: Update
  • Action Query: Delete, Append and Make-Table
  • Customising a Form (1)


  • Customising a Form (2)
  • Using Subforms
  • Creating Reports
  • Basic Macros and Command Buttons
  • Importing and Linking Data
  • Working on the Internet
  • Students Database (1)
  • Students Database (2)
  • PivotTables and PivotCharts (XP edition only)


"Enables students to learn by doing" G Solomon Head of ICT, Kings School.
"Excellent" ICT Co-ordinator. N Wood.



© ZigZag Education, Unit 3, Greenway Business Centre, Doncaster Road, Bristol BS10 5PY