In this lesson, you will become familiar with the general capabilities of the Office app Microsoft® Access®, and with the user interface, by working with a completed version of the database you will develop.

You have navigated within an existing Microsoft® Access® database and have become familiar with the various components used to construct a database, including tables, queries, forms, and reports. Now you will create your own Access database, starting out by planning the database design. Then you will create a database file and tables, and populate those tables with data.

You have created a database, populated tables, and made updates to database content in Microsoft® Access®. You have searched, sorted, and filtered datasheets. As powerful as those features are, however, they are limited. They are temporary and easily overwritten. In this lesson, you will see how queries enable you to create reusable instructions that perform complex operations on dynamic table data fast and precisely the same way each time.

You have worked with data through tables and queries in Microsoft® Access®, and now you will see how to use forms to access data. Forms present the data in an interface that make it easier to view. In this lesson, you will create a form and then experience how it can improve the way users work with data.

You created a database and managed its content by using a variety of tools provided by Microsoft® Access®. For many, the ultimate reason to collect and organize data is to produce a report. In this lesson, you will create a report, add controls and change the report's layout, apply themes and layout options, prepare a report to be printed, organize report information, and format reports.

You'll wrap things up and then validate what you've learned in this course by taking an assessment.