Database Concepts

Introduction

A database helps store and manage information in a systematic way. A database, such As Microsoft Office Access 2007, you can easily retrieve and update your business data. It also helps you to process information effectively to meet the various business needs.

Benefits of an Access database

An Access database helps you to add new data to a database. In addition, allows you to edit and delete existing data. ForFor example you can change the position of an item or remove information about a discarded element. It allows you to organize and display data in different views. You can also exchange data with other users by using reports, intranet or the Internet.

Components of an Access database

The basic components of an Access database tables, forms, reports, queries, macros and modules. A database table stores data in rows and columns. Tablesare similar to spreadsheets. In contrast to tables, tables to organize data in a systematic way. Forms, also known as data entry screens, as a user interface for working with your data. They contain various commands and monitor user interactions

Reports in an Access database to help represent data in a readable format. A report always displays the current data in the database. You can view, print and export a report. Queries help to integrate data from differentTables and displays them in a single sheet. They also act as a data source for forms and reports. You can also make requests to a task with data

In an Access database, macros help act as a simplified programming language and to extend the functionality of the database. You can automate them for most of database operations that contribute, such as opening a report with a query, or closing the database. Modules also help to extend the functionality of the database.The modules are written using Visual Basic for Applications (VBA) programming language. A module consists of declarations, statements and procedures.

Primary Keys

In an Access database, data is stored in different compartments tables. Access 2007 uses the primary key to link data from multiple tables and arrange them in a logical manner. A primary key is set a field or a number of fields, which as a unique identifier for each row in a table.

Youmust specify the primary key for a table. A unique identification number, such as an ID number that can be used as primary key in a table. For example, a student ID is a unique registration number of the primary key in the STUDENTS table. Primary key to an acceleration of database operations such as queries, searching and sorting. A primary key of a table can be a foreign key in another table.

Table Relationships and Normalization

In an Access database, the datastored in different tables. You need to create relationships between tables to relate data in different tables. Additionally, you can apply to ensure the rules for normalization structure of tables and that you have divided the information into a logical and efficient manner in different tables.

Digital Timer Ski Pants