Microsoft Access 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 Access 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 Access can stores data in its own format based on the Access Jet Database Engine.
Like all relational databases, Microsoft Access also allows you to link related information easily. For example, customer and order data.
However, Microsoft Access 2019 also complements other database products because it has several powerful connectivity features.
MS Access can also import or link directly to data stored in other applications and databases.
As its name implies, Microsoft Access 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 Access can be used with a wide variety of other data formats, including many other database file structures.
You can export Microsoft Access data to and import data from word processing files, spreadsheets, or database files directly.
MS Access 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 Access to develop many types of application software.
Microsoft Access Tables
Microsoft Access 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 Access 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.