Day 18

 

Introduction to

Microsoft Access 2000

MOUS Class Syllabus

Microsoft Access is a powerful database management system that functions in the Windows’ environment.   

Key Features:

Data Entry and update:  Access provides easy mechanisms for adding, changing, or deleting data. 

Queries: These allow the user to search a large database and find the records that he/she needs.

Forms:  It is now easy to create forms that allow you view or update data.

Reports: these are a way to present your data in an attractive fashion.

Web Support:  Access allows you to save your work as a web page.

 

Key Terms:

Database: This is a collection of data, which is organized in such a way as to render it easy to search. 

Record: A collection of fields, which contain information about one person or entity.  A record would contain the name, address, and phone number of one person, for example.

Field: An area that contains a specific piece of information about one person or entity within a record. A field would contain only the name, or address, or the phone number of one person, for example.

A note for new students:

The textbook is: TEXT: Microsoft Office 2000 Introductory Concepts and Techniques by Gary B. Shelly Thomas J. Cashman Misty E. Vermaat
ISBN: 0-7895-4635-3

 The data to be used in these assignments can be found at: http://www.scsite.com/viewtitle.cfm?isbn=0-7895-4635-3

 

This textbook is divided into applications and projects. It starts on the basics and goes on from there, with each project using the skills learnt in the earlier projects.

 

Construction of the class session

 

 

 

Lab Work:

Project 1

Problem 1 on page A 1.55-6, Problem 1 on page A 1.57-8, problem 2 on page A1.59 and the first three Cases and Places.

You will need the document:

SideWalk Scrapers , click here to download it now.

 

All projects must be either e-mail to me at

selmateacher@yahoo.com

or

given to me directly by the test day (Day 9)