Microsoft Access 2003

Microsoft Access 2003 is a complete Database Management System (DBMS) package that allows searching, organizing, sorting and correcting data. This workshop is divided into six parts. Below is a description for each part.

Microsoft Access 2003 Part 1
Introduction to Access -- A database is any collection of interrelated information. Access is about design and management databases. In Part One, you will learn the fundamentals of Database Management Systems, including how to create and edit tables, how to work with items of a table, and how to use the Office Assistant.

Microsoft Access 2003 Part 2
Presenting Data -- Tables are the basic building block of a database. How effectively you administer your database depends on managing tables. In Part Two, you will learn how to work with tables, field properties, hyperlink field usage, including data finding and filtering.

Microsoft Access 2003 Part 3
Using Tables and Queries -- A query is a means of retrieving data from tables. Using queries, you can easily manipulate your database. In Part Three, you will learn how to use simple queries, use operators in queries, establish relationships among tables, and use the table analyzer.

Microsoft Access 2003 Part 4
Working with Queries-- In Part Four, you will learn how to create, design, and use action queries. Several queries of different purposes will be covered to make data retrieval more efficient. Also, you will learn how to use advanced query wizards to analyze and correct data errors.

Microsoft Access 2003 Part 5
Using Forms-- Once your information is stored in a table, Access allows you to display the data using forms. A form displays one or several records at a time, making it easier to read and input information. You will learn how to design forms by manipulating controls, creating functional controls, inserting pictures, and adding background colors.

Microsoft Access 2003 Part 6
Creating Reports-- A report is an effective way to present your data in a printed format. Because you have control over the size and appearance of a report, you can display the information the way you see fit. In the final part of the workshop, you will learn how to create reports, use charts, link/convert data, as well as how to import/export data between different applications, such as Word and Excel.