Per a beginner the term database may sound too technical Or complicated. But once you understand the concept behind this term,you will find it very simple.Letus first describe what a database is. It has been defined in several ways. a simple definition would be the database is an organized collection of related information (data) that can be accessed easily for various purposes. The database is a file composed of records, each contaning fields. A record is a complete set if related information that corresponds to one row of information in the database.Field is a category of information which corresponds to one coloum of informaion in the database. Data are nothing but the collection of facts and figures specified under particular heading or field.
Databases are used are used in our day to day life. The dictionary is one of the most common examples of databases where words are arranged alphabetically. The telephone directory is another exa,ple of databse, where the names of telephone subscribers are given in alphabetical order. Similarly, schools maintais student's database in order to get quick information about the student's name, address , telephone no., Guardians name, etc. In order to analyze, search, etc. The database records stored in the electronic database file, we need to take the help of Database Management System. (DBMS). Here Database management system is a software that is used to create, store, oganize, analyze, search updates, retrieve information, and print the database. Some examples of DBMS (Database Management System's) are:
=>1. MS Access,
=>2. dBASE,
=>3. FoxPro etc.
MICROSOFT ACCESS
Microsoft Access is a computer application used to create and manage computer based databases on desktop computeres and/or connected computers on a network. It is a powerful programme to create and manage databases. It has many built in features to assist you in constructing and viweing your information. Microsoft Access can be used for personal information Management (PIM), in a small buisness yo orgnize and manage all data, or in an interprise to communicate with servers.
in this ;esson you will learn different activities related with database using Ms Access. Database Management System Software. First of all you need to understand how Microsoft Access breaks down a database.
some keywords involved on this process are :
Database Files, Table, Record, Field, Datatype.
Here is the hierarchy that Microsofe Access uses in breaking down a databases.
Fig1.1 Hierarchy that Microsoft Access uses in breaking down a Database
