Computer – Microsoft Access

Microsoft Access is a relational database management system that combines the relational Microsoft Jet Database Engine with a graphical user interface and software development tools.

·         It stores data in its own format based on the Access Jet Databases.

·         It can also import or link directly to data stored in other Access databases.

·         A database is a collection of data of a particular type.

·         Data in a database is stored in the form of tables.

·         A table is a row and column arrangement of information.

·         A table is also called a Relation.

·         The table contains data organized under specific categories.

·         Each such category is arranged vertically in a table and is called a Column.

·         Every column in a table has a unique name.

·         A column can also be referred to as a field.

·         Data organized horizontally is termed as a row.

·         Relational Database Management System (RDBMS) is a multi-table database where the tables in the database have to be related for storing or retrieving data.

·         Microsoft Access is an RDBMS that enable to manage relational database in a windows environment.

·         MS Access enable you to enter, retrieve and modify data and also create forms and reports.

Database Objects

a) Table  : They store data in a row and column format similar to spreadsheets.

b) Queries : They enable you to view data from a table.

c) Forms : They enable you to enter, view and modify in a table.

d) Reports : They enable you to generate reports based on tables and query results.

e) Data Access Page : They are web pages to view data from the internet where the data is stored in an Access database.

f) Macros : They are a series of commands and functions that can be executed whenever a task is needed to perform.

g) Modules  : They are a set visual basic procedures and declarations stored as one unit.