Basic concepts of data

Introduction

A database can store and manage information in a systematic way. A database such as Microsoft Office Access 2007 allows you to easily retrieve and update corporate data. It also helps to process information effectively to meet business needs.

Benefits of an Access database

An Access database allows you to add new data to a database. It also enables you to edit and delete existing data. For example, you can change the location ofan item or remove information on an item dropped. It allows you to organize and display data in different ways. You can also share data with others by relationships with the intranet or Internet.

Components of an Access database

The basic components of an Access database including tables, forms, reports, queries, macros and modules. A database table stores data in rows and columns. The tables are similar to spreadsheets. However, unlikespreadsheets, charts to organize data in a systematic way. Forms, also called data entry screens, acting as a user-friendly to work with your data. They contain various commands and user interactions to help control

Reports in an Access database to help the data in a readable format. A relationship always has the data in the database. You can view, print and export report. Query help you to recover data from different tables and display it in a sheet. They alsoact as a record source for forms and reports. You can also use the query to perform a task with the data

In an Access database, macros act as a simplified programming language and allow you to add functionality to the database. You can use multiple databases to automate tasks such as opening a report, run a query, or closing the database. The modules also allow you to add functionality to the database. The modules are written using Visual Basic for Applications (VBA) programminglanguage. A module is composed of declarations, statements and procedures.

Primary keys

In an Access database, the data are stored in different tables by topic. Access 2007 uses the primary key fields to link data from multiple tables and organized logically. A primary key is defined as a field or set of fields that functions as a unique identifier for each row in a table.

You must specify the primary key for a table. A unique identification number, as aidentification number, can serve as the primary key in a table. For example, a student unique identification number and a student may be the primary key of STUDENT table. Primary keys will help speed up database operations such as query, the search and sorting. A primary key of a table can be a foreign key in any other table.

Relationships between tables and normalization

In an Access database, the data is stored in various tables. You need to create relationships between tables to relate data in different tables.In addition, you can apply normalization rules to structure the tables and make sure you have divided the information in a meaningful and effective in various tables.

pc game conference calling