Microsoft Access 2016

Access 2016 Basic

1. Introduction Part1
2. Introduction Part2
3. Elements Part1
4. Elements Part2
5. Reviewing Data
6. Queries Part1
7. Queries Part2
8. Tracking Time Part1
9. Tracking Time Part2
10. Tracking Time Part3
11. Design Work With Forms

Access 2016 Intermediate

1. Relationships Part1
2. Relationships Part2
3. Changing Information
4. Loading Tables
5. Relating Invoices Part1
6. Relating Invoices Part2
7. Relating Invoices Part3
8. Relating Invoices Part4
9. Time Entry Form

Access 2016 Advanced

1. Queries Part1
2. Queries Part2
3. Queries Part3
4. Queries Part4
5. Reports Based On Queries
6. Adding Additional Information
7. Update Query Part1
8. Update Query Part2
9. Creating A Report From Scratch Part1
10. Creating A Report From Scratch Part2
11. Creating A Report From Scratch Part3

Microsoft Access 2016 earners have an understanding of the Access environment. They understand basic database design principles and the correct application of the principal features of Access 2016. Earners can create and maintain basic Access database objects including tables, relationships, data entry forms, multi-level reports, and multi-table queries. Access earners may include small business owners, mid-level managers, business professionals, students and others.

Microsoft Access (or MS Access) is bundled as part of the Microsoft Office suite. It is only available on the PC version.

Access has traditionally been known as a desktop database system because its functions are intended to be run from a single computer (as opposed to a client/server system where the database application is installed on a server, then accessed from multiple client machines) across a network.

However, Access also includes a web solution (for building “custom web apps”) that is integrated with SQL Server — a more powerful database product, also from Microsoft) — for a more robust solution.

When you save a database in Microsoft Access, it is saved with a .accdb extension. This is the file extension you will use the most when developing Access databases. Older Access databases used an .mdb extension or sometimes a .mde extension, but in 2007, Microsoft started to phase these out in favor of the .accdb extension. If you’re unable to open an older database, you may need to convert to .accdb first using an older version of Access.

The Microsoft Access 2016 Security Technical Implementation Guide (STIG) is published as a tool to improve the security of Department of Defense (DoD) information systems.

Data is everywhere. Whether you are at the grocery store, office, laboratory, classroom, or ballpark, you are awash in data: prices, schedules, performance measures, lab results, recipes, contact information, quality metrics, market indices, grades, and statistics.

Most job roles today involve some form of data management. In the case of data workers, it may be their primary job task. For some, such as research scientists and accountants, data management may be a strong component of the job. And for others, such as sales clerks or those in the skilled trades, data management may consist of an incidental job responsibility, for example, time reporting or recording a sale. Virtually everyone is affected in some way by the need to manage data.

A relational database application such as Microsoft® Office Access 2016 can help you and your organization collect and manage large amounts of data. Access is a versatile tool. You can use it as a personal data management tool (for your use alone), or you can use it as a construction set to develop applications for an entire department or organization. In this course, you will use Access 2016 to manage your data, including creating a new database; constructing tables; designing forms and reports; and creating queries to join, filter, and sort data.

In this course, you will create and manage an Access 2016 database.
You will:

1. Navigate within the Microsoft Access application environment, create a simple database, and customize Access configuration options.
2. Organize and manage data stored within Access tables.
3. Use queries to join, sort, and filter data from different tables.
4. Use forms to make it easier to view, access, and input data.
5. Create and format custom reports.