Learning Microsoft Access 2003

Learning Microsoft Access 2003 is suitable for use with Microsoft Access 2000, Microsoft Access XP and Microsoft Access 2003.

Prices

Download Product

Summary of Chapters

The following pages provide a summary of the skills developed and the types of databases produced in modules 1 and 2 of Learning Microsoft Access 2003.

Module 1

Chapter 1: Introduction to Microsoft Access

Demonstrates how to set up a simple table, add data to the table, edit data, delete records and print the data. The following is an example of a table produced:

Back to Microsoft Access | Top | Next

Chapter 2: Processing Data

This chapter provides activities on how to sort data into alphabetical, numerical or chronological order, how to filter information and how to search for information. For example, a table showing just the females sorted by date:

Back to Microsoft Access | Top | Previous | Next

Chapter 3: Introduction to Queries

This chapter provides activities on how to set up a query, how do calculations on the data, how to sort and filter the query, how to set up table relationships, how to use the query wizard and how to use interactive queries. For example, the following diagram shows a total pay calculation added to a database and wages over $600 displayed.

Back to Microsoft Access | Top | Previous | Next

Chapter 4: Creating Data Entry Forms

This chapter provides activities on how to create Forms. It includes how to insert fields, adjust field widths and positions, how to align fields and labels, how to change fields text and fill colours, how to insert graphics, add pop-up or menu lists and how to set the field entry order to produce forms similar to.

Back to Microsoft Access | Top | Previous | Next

Chapter 5: Reporting From Databases

This chapter provides activities on how to create Reports from databases. It includes how to layout a report, add calculations, how to format the report, how to add headers and footers, page numbers and how to use the report wizard. An example of a reported created is:

Back to Microsoft Access | Top | Previous | Next

Chapter 6: Creating User-Friendly Databases

This chapter demonstrates how to create user-friendly databases that links tables, queries, forms and reports together. It involves adding buttons, creating a switchboard form and setting passwords to the database. The following switchboard is created:

Back to Microsoft Access | Top | Previous | Next

Chapter 7: Reports That Total Items

This chapter provides activities that show the user how to include sub-totals and grand totals in reports. It covers how to set a group, add controls to the group, how to adjust the group footer and how the adjust the report footer to create reports such as:

Back to Microsoft Access | Top | Previous | Next

Module 2

Chapter 8: Using Macros

This chapter provides activities on how to create macros. It covers creating macros, assigning buttons to macros, editing macros, macro groups, setting an autoexec button and printing macro definitions.

Back to Microsoft Access | Top | Previous | Next

Chapter 9: Applying Rational Database Features

This chapter provides activities on how to create relational database systems. It covers defining relationships, setting match fields, setting a sub-form frame, allowing for cascade deletes and the advantages of relational database systems. The following form is created displaying data from two separate databases:

Back to Microsoft Access | Top | Previous | Next

Chapter 10: Creating a Business Invoice System

This chapter provides activities that apply the relational database concepts developed on the previous chapter to create a complete business invoice system. It covers creating the relationships, preparing the invoice, completing calculations, inserting a company logo and using the invoice. The following invoice is created:

Back to Microsoft Access | Top | Previous | Next

Chapter 11: Enhancing the Business Invoice System

This chapter demonstrates how to enhance the invoice created in the previous chapter. This includes creating reports, adding mailing labels, adding command buttons, creating a switchboard form and using the invoice system. The following summary report is created from the invoice data.

Back to Microsoft Access | Top | Previous | Next

Chapter 12: Useful Features

This chapter demonstrates some of the useful tools that Microsoft Access offers. For example, using Help features, creating Form Tabs, the Calendar Control, checking for Duplicate Records, Document Properties and Database Wizards.

Back to Microsoft Access | Top | Previous

Home | Products | Prices | Ordering | Podcasts | Downloads | Contact