Introduction To A Microsoft Access Database

Introduction

A database is a collection of information organized as to make it easy to view it, search it, retrieve the right detail, and collect the necessary facts in an easier, timely, and effortless manner as possible.

Relational Database

An organized database is composed of inter-related parts. Since you define these parts, you also organize them in a manner that helps some parts of your database to supply specific information to others. In one part, you would cover one category of data, such as people's personal information (name, date of birth, salary, hobbies, etc), in another you would cover what they buy in a store.

Microsoft Access

Microsoft Access is a relational database used on desktop computers to manage information on different levels for different purposes.

Microsoft Access can be used for personal information management, in a small business to organize and manage all data, or in an enterprise to communicate with servers.

Database Management System (DBMS)

A database is an organized collection of data. Organization means method, it assumes discipline, it also anticipates efficient manner in using that information. Unless you are creating small applications for your personal use (and I don't think you are exclusively doing just that), you will usually need to share your data either with other people (users, DB developers, etc) or other machines. To make your job easier, Microsoft Access provides in one package the database information and the tools you need to use your database. To be organized, you will divide your database in different related parts. The method of management you will use makes Microsoft Access a Database Management System.

When you create a database in Microsoft Access, you create a database file that will include different parts of your database. These are referred to as tables, queries, forms, reports, etc.

Function-X