Microsoft Accesss is a Database Management System (DBMS) from Microsoft that combines the relational Microsoft Jet Database Engine
with a graphical user interface and softwaredevelopment tools. It is a member of the Microsoft Office suite of applications,
included in the professional and higher editions.
Microsoft Accesss is just one part of Microsoft’s overall data management product strategy. Microsoft also offer SQL Server, Azure SQL
ASP.NET database and data management software.
Microsoft Accesss can stores data in its own format based on the Accesss Jet Database Engine.
Like all relational databases, Microsoft Accesss also allows you to link related information easily. For example, customer and order data.
However, Microsoft Accesss 2019 also complements other database products because it has several powerful connectivity features.
MS Accesss can also import or link directly to data stored in other applications and databases.
As its name implies, Microsoft Accesss can work directly with data from other sources, including many popular computer 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
an organization's intranet web servers.
MS Accesss can be used with a wide variety of other data formats, including many other database file structures.
You can export Microsoft Accesss data to and import data from word processing files, spreadsheets, or database files directly.
MS Accesss can work with most popular databases that support the Open Database Connectivity (ODBC) standard, including SQL Server, Oracle, and DB2.
Because the program is so flexible, software developers can use Microsoft Accesss to develop many types of application software.
Microsoft Accesss Tables
Microsoft Accesss tables are bothe the backbone + the storage container of the data entered into the database. If the tables are not set up
correctly, with the correct relationships, then the database may be slow, give you the wrong results or not react the way you expect. So, take
a bit of time when setting up your tables.
Note: Queries, forms, reports and many other entities within an Accesss database are typcially based on a table.
The tables that contain data look a bit like a Microsoft Word table or a Microsoft Excel Spreadsheet, when opened. They have columns and rows as does a
table in Microsoft Word and an Excel worksheet. Each of the columns will have a field name at the top and each of the rows will represent a record.