MS Access Database Design

Microsoft Access is an application for quickly creating databases that help you run your business. It has been a part of the Microsoft Office Suite since the beginning and is still part of Office 2021 and Microsoft 365. Microsoft continues to champion this product. If you’ve been storing your data in Excel, in time you’ll find that you’ll need to move your data to something more robust. Microsoft Access is a Relational Database that can store significantly more data than Excel in a format that’s much easier to maintain. In addition to Microsoft Access training, we also offer Database Design courses and can assist you in developing your own database.

Microsoft Access 2021 Courses

Access 2021 Level 1 Course Content (PDF File)
Access 2021 Level 1 Design Course Content (PDF File)
Access 2021 Level 2 Course Content (PDF File)

Microsoft Access 2019 Courses

Access 2019 Level 1 Course Content (PDF File)
Access 2019 Level 1 Design Course Content (PDF File)
Access 2019 Level 2 Course Content (PDF File)

Microsoft Access 2016 Courses

Access 2016 Level 1 Course Content (PDF file)
Access 2016 Level 1 Design Course Content (PDF file)
Access 2016 Level 2 Course Content (PDF file)

Microsoft Access is easy to learn and use. Once you have installed the program, you can start using it right away with very little training. It has many features that allow you to customize the way you work: You can choose different views of the data, change colours, fonts, and other formatting options. You can also import and export files into and out of the database.

Microsoft Access has a runtime version that is free to download and install so you can use databases created by others without purchasing the Professional version of Office desktop.

Product Features:

  • Create a database using any combination of data sources such as Excel spreadsheets, text files, or connections to other ODBC-compliant databases.
  • Import data into Access databases from a variety of data sources including text files, Excel spreadsheets, web pages, databases, and ODBC connections.
  • Use SQL statements to build complex queries that retrieve information from different data sources.
  • Build relationships between records using foreign keys.
  • Add new records (rows) using Insert/Update/Delete commands.
  • Export data to XML, CSV, HTML, and PDF formats as well as SharePoint and the new Dataverse format that allows you to manipulate data with Microsoft Power Apps.
  • Generate reports that summarize data in an attractive format.
  • Create dynamic dashboards that display real-time data.
  • Automatically generate forms based on database tables.
  • Customize form layouts using Visual Basic for Applications.
  • Create user defined functions to perform calculations on data.

What is a Relational Database?

Relational databases are used to store information that can be accessed through queries. They are based on the concept of relationships between data items. A relational database stores data in tables, where each row represents a record and columns represent attributes of that record. Microsoft Access tables can be linked to SharePoint or the Dataverse to allow them to work with cloud storage.

What is Dataverse?

Dataverse lets you store and manage data in the cloud where it can be manipulated by Power Apps and integrated with Microsoft Dynamix or accessed through Microsoft Power BI. Data stored in standard and/or custom tables in Dataverse are easy to manage and secure.