Come out of the Dilemma: Switch To Government Jobs
Switch to Govt Jobs

Understanding the concept of MS-Access

Introduction 


Microsoft Office Access, previously known as Microsoft Access, is a relational database management system from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software development tools.

MS-Access


  • Access is a member of the Microsoft Office suite of applications and is included in the professional and higher versions for windows and also sold separately.
  • There is no version for MacOs or for Microsoft Office Mobíle.
  •  Access stores data in its own format based on the Access Jet Đatabase Engine
  • Access can also import or link directly to data stored in other Access databases, Excel, SharePoint lists, text, XML, Outlook, HTML, dBase, Paradox, Lotus 1-2-3 or any ODBC-compliant data container including Microsoft SQL Server, Oracle, MySQL, and PostgreSQL. Software developers and data architects can use it to develop application software and non-programmer "power users" can use it to build simple applications.
  • Access supports some object-oriented techniques but falls short of being a fully object-oriented development tool.


Database Management System (DBMS)


  • A database is a collection of data of a particular type.
  • A DBMS is an organized collection of data viewed as a whole, instead of a group of separate unrelated files
  • Data in a database is stored in the form of tables.
  • A table is a row and column arrangement of information.
  • A DBMS is a collection of interrelated data and a set of programs to retrieve data from a database.


MS-Access

Relational Database Management System (RDBMS)



  • A RDBMS is a multi-table database where the tables in the database have to be related to storing or retrieving data.
  • A RDBMS is used to create and maintain relational databases.

Components of a Table



  • Each table in a database has a unique name that identifies the contents
  • 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.

Type of Database Objects


Tables:

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

Queries:

They enable you to view data from a table based on a specified criterion.

Forms:

They enable you to enter, view and modify in a table.

Reports:

They enable you to generate reports based on tables and query results.

Data Access Pages:

They are web pages that enable you to view data from the internet where the data is stored in an Access Data Access Pages database.

Macros:

They are a series of commands and functions that can be executed whenever you need to perform a task.

Modules:

They are a set of Visual Basic procedures and declarations stored as one unit.



Data Types


A data type is used to store different types of values in a column in a table. 

Text: 

It stores text or a combination of text and numbers.

Memo:

It stores a large number of text and numeric characters.

Number:

It stores numeric data that is used for mathematical calculation.

Data Time:

It stores data and time values.

Currency:

It stores currency values.

Auto Number:

It enables the user to automatically insert numbers in a sequential or random number.

Yes/NO:

It is used for fields that can contain YES/NO, TRUE/FALSE and ON/OFF values.


Ole Object:

It enables to store object, like word documents, Excel spreadsheets, pictures or sounds.

Hyperlink:

It enables to store a hyperlink like an e-mail address a web site address.

Lookup Wizard:

It enables to select a field from another table.