Description

Written in an upbeat, jargon-free style, it assumes no prior knowledge of Databases

Adopts a learn-by-doing approach

Contains lots of practical graded assignments taking the student from elementary level to advanced

Integrates both theory and practice but theory is supplied in manageable chunks

Symbols are used throughout to indicate learning objectives, useful tips and important points

Written specifically for Microsoft Office 2000 but assignments can also be completed using Office XP or Office 97

Includes a glossary of database terms, which can be used as a quick reference

Solutions to the assignments will be available on the Gill & Macmillan website (www.gillmacmillan.ie)

Author Biography
Alan Dillon teaches Information Technology in Roslyn Park College, Dublin. He has been teaching IT since 1993 but has also worked as a computer programmer.

Table of Contents
Section 1: Beginners Database Assignments
Includes four database assignments. In this section students will learn how to:
- Create a New Database Including a Table, a Form and a Number of
Queries
- Specify Data Types and Field Sizes in Table Design
- Enter Data Using a Form
- Use a Form to Find, Edit and Delete Records
- Create a Primary Key
- Change the Design of a Form
- Find Specific Records Using a Query
- Use Logical Operators in Query Conditions
- Define Database Structure
Section 2: Intermediate Database Assignments
Includes three database assignments. In this section students will learn how to:
- Create a Combo Box and List Boxes
- Change the Tab Order in a Form
- Create and Format Reports
- Format Labels and Text Boxes in a Form
- Create Address Labels Using a Report Wizard
- Use and/or in a Query
Section 3: Advanced Database Assignments
Includes three database assignments. In this section students will learn how to:
- Create a Parameter Query
- Merge a Database with a Word Document
- Sort a Report
- Perform calculations in a Report
- Use a Wild Card in a Query
- Use Validation Rules in a Table
- Create a Form Linked to a Query
- Create a Grouped Report
- Combine Labels and Text Boxes in a Report Title
- Use the Tab Control in a Form
- Create Functions in a Form
- Create a Crosstab Query
Section 4: Introduction to Relational Database
Includes one relational database assignment. In this section students will
learn how to:
- Create a Database Containing Multiple Tables
- Set Up Relationships Between Tables
- Create a Combo Box Linked to a Table
- Create a Form Linked to Multiple Tables
- Create a Macro to Speed Up Data Entry
- Develop Custom Database Menus
- Create a Query Linked to Another Query
- Create an Update Query
Section 5: Project Guidelines and Sample Exams