Introduction to Ms Access
INTRODUCTION
TO
MICROSOFT
ACCESS 2007
INTRODUCTION
Microsoft Access (usually abbreviated as MS Access) is an easy-to-use program for creating and maintaining databases. All database queries, forms, and reports are stored in the database, and in keeping with the ideals of the relational model. MS Access software used for creating databases * Quickly * Accurately * Using wizards and templates developed to maintain the integrity of your data
* Data are just information * Database * Collection of data * Related to a particular topic or project
Access has an .mdb extension by default in 2003 version. Early versions of Access cannot read .accdb extensions but Microsoft Access 2007 can read and change earlier versions of Access. The Microsoft Access Database is made up of 7 major components:
* Tables * Relationships * Queries * Forms * Reports * Macros * Modules
FEATURES 1- Compactness: where there is no need for the old paper files that has a big size.
2- Speed:
Because of the computer can restore the stored Data Base and upgrading it very fast than the normal human manual hand can do.
3- Accuracy:
There is accuracy in data or information used in database.
4- Currency:
The more specific you can have when you asking for a Data Base information.
5- Simplicity:
An easy way to collect, access-connects, and display information.
6- Stability:
To prevent unnecessary loss of data.
7- Security: To protect against unauthorized access to private data.
Manual Maintenance Systems (Paper Based)
Manual (paper based) preventative maintenance systems have been around for many years. Usually these are little more than a record of the planned maintenance done, with a card system being used to determine when it is next due.
In a typical manual or paper based maintenance system, each item of equipment or asset will have a
TO
MICROSOFT
ACCESS 2007
INTRODUCTION
Microsoft Access (usually abbreviated as MS Access) is an easy-to-use program for creating and maintaining databases. All database queries, forms, and reports are stored in the database, and in keeping with the ideals of the relational model. MS Access software used for creating databases * Quickly * Accurately * Using wizards and templates developed to maintain the integrity of your data
* Data are just information * Database * Collection of data * Related to a particular topic or project
Access has an .mdb extension by default in 2003 version. Early versions of Access cannot read .accdb extensions but Microsoft Access 2007 can read and change earlier versions of Access. The Microsoft Access Database is made up of 7 major components:
* Tables * Relationships * Queries * Forms * Reports * Macros * Modules
FEATURES 1- Compactness: where there is no need for the old paper files that has a big size.
2- Speed:
Because of the computer can restore the stored Data Base and upgrading it very fast than the normal human manual hand can do.
3- Accuracy:
There is accuracy in data or information used in database.
4- Currency:
The more specific you can have when you asking for a Data Base information.
5- Simplicity:
An easy way to collect, access-connects, and display information.
6- Stability:
To prevent unnecessary loss of data.
7- Security: To protect against unauthorized access to private data.
Manual Maintenance Systems (Paper Based)
Manual (paper based) preventative maintenance systems have been around for many years. Usually these are little more than a record of the planned maintenance done, with a card system being used to determine when it is next due.
In a typical manual or paper based maintenance system, each item of equipment or asset will have a