MS Access Overview - MS Access

What are the features of MS Access?

Microsoft Access is a Database Management System (DBMS) from Microsoft which combines the relational Microsoft Jet Database Engine with a graphical user interface and software development tools. It is a part of Microsoft Office suite of applications, included in the professional and higher editions.

  • Microsoft Access is a part of Microsoft’s overall data management product strategy.
  • It will store data in its own format based on the Access Jet Database Engine.
  • Like other relational databases, Microsoft Access helps in linking related information easily. For example, customer and order data. However, Access 2013 also complements other database products as it has several powerful connectivity features.
  • It can also import or link directly to data stored in other applications and databases.
  • As its name indicates, Access works directly with data from other sources including many popular PC database programs, with many SQL (Structured Query Language) databases on the desktop, on servers, on minicomputers, or on mainframes, and with data stored on Internet or intranet web servers.
  • Access can understand and use wide variety of other data formats including many other database file structures.
  • Data can be exported and imported from word processing files, spreadsheets, or database files directly.
  • Access can work with most popular databases which support Open Database Connectivity (ODBC) standard, including SQL Server, Oracle, and DB2.
  • Software developers can use Microsoft Access for developing application software.

Microsoft Access stores information which is called a database. To use MS Access, you have to below four steps

  • Database Creation − Create a Microsoft Access database and specify what type of data to be stored.
  • Data Input − After creating the database, data of every business day can be entered into the Access database.
  • Query – This describes the process of retrieving information from the database.
  • Report (optional) − Information from the database will be organized in a nice presentation which is printed in an Access Report.

Architecture

  • Access calls anything which can have a name as an object. Within an Access desktop database, main objects are tables, queries, forms, reports, macros, data macros, and modules.
  • If you have worked with other database systems on desktop computers, you might have seen the term database which is used to refer to only those files in which you store data.
  • But in Access, a desktop database (.accdb) will also include all the major objects related to the stored data, including objects you define to automate the usage of the data.


All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd DMCA.com Protection Status

MS Access Topics