MS Access overview


May 16, 2021 21:00 MS Access


Table of contents


Microsoft Access is a database management system (DBMS) from Microsoft that combines the relationship Microsoft Jet database engine with a graphical user interface and software development tools. /b10> It is a member of the Microsoft Office Suite application, both professional and later.

  • Microsoft Access is only part of Microsoft's overall data management product strategy.

  • It is based on the Access Jet database engine to store data in its own format.

  • Like a relationship database, Microsoft Access allows you to easily link relevant information. /b10> For example, customer and order data. H owever, Access 2013 complements other database products because it has several powerful connectivity features.

  • It can also import or link directly to data stored in other applications and databases.

  • As the name suggests, A ccess can work directly with data from other sources, including many popular PC database programs, many SQL (structured query language) databases on desktops, servers, small computers or mainfringers, and data stored on the Internet or Internet Web servers.

  • Access can also understand and use a variety of other data formats, including many other database file structures.

  • You can export data directly to and import data from word processing files, spreadsheets, or database files.

  • Access works with the most popular databases that support open database connectivity (ODBC) standards, including SQL Server, Oracle, and DB2.

  • Software developers can use Microsoft Access to develop applications.

Microsoft Access stores information called databases. To use MS Access, you need to follow these four steps -

  • Database Creation - Create a Microsoft Access database and specify the type of data to store.

  • Data Entry - After the database is created, data can be entered into the Access database every business day.

  • Query - This is a peculiar term that describes the process of retrieving information from a database.

  • Reports (optional) - Information from the database is organized into a beautiful presentation that can be printed in an Access report.

Structure

  • Access calls anything that can have a name object. /b10> In the Access desktop database, the main objects are tables, queries, forms, reports, macros, data macros, and modules.

  • If you use a different database system on your desktop computer, you may have seen the term database used to refer only to those files that store data.

  • However, in Access, the desktop database (.accdb) also includes all the primary objects associated with storing data, including the objects that you define for automatic use of the data.