Microsoft Access– a part of the Microsoft 365 office suite– offers a robust desktop-class relational database that does not need a server to run. Access databases work from a fixed file on your hard drive or a network share and uses sophisticated tools for creating tables, questions, kinds, and reports.
Getting Started and Important Terms in Access
Launch Microsoft Access. From the 
A Database Attribute Defines the Properties of a Table
Relationships of Objects in Access
All tables connect to one another through a series of relationships. Microsoft Access is a relational database management system, which implies that it imposes guidelines that govern how data in one table associates with information in another table.
Creating Database Relationships in AccessIntroduction to Database Relationships
How to Use Forms in Access
Use a form to facilitate the orderly inputting of records into the database. Forms are graphical tools optimized to support data entry. Instead of adding information to the table directly, users will enter it into a form, which is easier to navigate and read.
Use Access Input Forms to Enter and Modify Data
Queries in Access
The results of a query don’t completely match the results of a table. Instead, an inquiry draws from one or more tables utilizing advanced filtering and sorting rules to return a table-like outcome that feeds a report or a structured export file.
Creating a Simple Query in Access
Reports in Access
Use a report to take the results of an inquiry or the contents of a table and produce a legible version that you can easily print or share on a screen. Reports sum up all or part of a table’s contents.
Microsoft Access Database Reports Tutorial
Unique Data Sources in Access
Microsoft Access is a front-end reporting tool that draws information from test files, Excel spreadsheets, SQL or Azure databases, Microsoft Outlook, or dozens of other sources of details. By importing connected tables or imported information sources, you’re complimentary to use Access as a querying tool and reporting representative. Gain access to also supports publishing reports and data to other databases and the Microsoft SharePoint platform.
Output Formats in Access
For the most part, info within an Access database stays within it. However, inquiries and reports export cleanly out of the database in Excel, plain text, XML, PDF, or XPS formats. In addition, Access feeds Microsoft Outlook and Microsoft Word circulation lists.
