Microsoft Access 2002 Tutorial

Peter Kitson

ISBN : -

Order a printed copy of this book from Amazon --UNAVAILABLE--


Cover Design - Microsoft Access 2002 Tutorial
  

For your free electronic copy of this book please verify the numbers below. 

(We need to do this to make sure you're a person and not a malicious script)

Numbers

 



Sample Chapter From Microsoft Access 2002 Tutorial
     Copyright © American University of Beirut



1. Microsoft Access Definition:

Whether you want to organize your educational records, maintain departmental information, or coordinate class projects, an Access 2002 database provides the structure and flexibility you need. You can store all kinds of information in an Access 2002 database, use queries to analyze the data, and create professional reports with customized layout and graphics.

When you are finished with this lesson you will have a database to store census information. In the process you will learn to:
  • Use the Table Design Wizard.
  • Add Fields to the Table.
  • Add Data to the Table.
  • Use a Form to view and add data to your table.
  • Query a database for specific information.
  • Customize a report on data in a database.

Your students can benefit from using a database for many classes or school projects:
  • In a science class, design a database with data you collect when performing experiments and then create a key word search.
  • In a history class, create a simple database with information about significant individuals or events and then use reports to analyze the information.
  • In a math class, use a database to calculate statistical information.
  • In a business class, create a database on the international market, including the gross national product, import and export patterns, and unemployment rates.
  • In your school, create a database to track a school fundraiser. Use Data Access
  • Pages so all the classes at your school can add information on their progress from the Web.
  • Using the Access 2002 database, you can organize school information. Examples of databases you can use include:
  • Library resources, including books, magazines, and audio information. When you use Data Access Pages and copy the database to your school network, you can peruse library holdings from the Web.
  • Student information, such as name and student number, academic records, contact information, records of disciplinary action, and medical needs or restrictions.
  • Classroom resources including curriculum objectives, text books, supplementary texts, student learning activities, and district standards.
  • Departmental information, such as the course taught, by whom, in which classroom, and when.