Concept Of An Access Database

The invention of computer does not itself make it easy for human beings to work faster but it is the information stored in it is quite important than others. To store data and information in a computer database is used. A database is made to help store and manage all the information in a systematic way which in future could be retrieve easily for update. Database such as Microsoft Office Access 2007, helps you in processing information effectively for using various business needs. How an access database helps:1. It helps in adding and storing new data to an existing one.2. It enables the user to edit and delete the data.3. It helps in changing the location of an item and also removes the discarded item.4. With the help of this data can be organized and displayed in different views.5. You can also use these data with others by means of reports, intranet or internet.An access database has some basic components like tables, forms, reports, macros, modules and queries. The data is stored in rows and columns. Though tables are similar to spread sheets it could organize data in a more systematic manner than spread sheets do. The data entry screens or forms act as a user friendly interface that contains various commands and help control user interactions to work with the data. Macros in an access database are a simplified programming language which adds functionality to the database. These are also used to automate most database operations like opening a report, closing the database or running the query. Modules, which also help to add functions into the database, are written using the visual basic for applications programming language and are consists of declaration, statement and procedures.An access database helps in presenting data in a readable format like reports. The report which consists of current data can be viewed, printed and also export to others. To retrieve data from various tables and display it in a single datasheet queries are used. The other function of queries is to act as record source for forms and reports. However they can also be used to perform a task with data.The access database used different subject based tables to store data. In access 2007, data from multiple tables are linked and arranged in a logical manner by using primary key fields. A primary key which is a set of fields acts as a unique identifier for every row in a table. You must specify the unique identification number or the primary key fro a table. For example a students ID number could be used as a primary key in the students table. Operations such as searching, querying, and sorting can be speed up by using primary key of a table.Since data is stored in different tables, you can relate them by creating table relationships. The normalization rules applied to structure the tables to ensure information is divided in logical manner in various tables.