Course
Skills
Microsoft Access (2016)
In this course, you will use Microsoft Access to create a desktop-based database. Software required: Microsoft Access (2016).
What you'll learn
Do you have to create a desktop database? Microsoft Access 2016 is the tool for you. You will start with a brief introduction to Access 2016, before you get into tables, fields, queries, and form building. This course will teach you how to create browser-based databases with scalable and usable data. Software required: Microsoft Access (2016).
Table of contents
Getting Started with Access 2016
57mins
- What Is Access? 4m
- Getting Started 3m
- Understanding the Access Environment 4m
- Working with Backstage View 4m
- Using the Navigation Pane 3m
- Exploring Tables 2m
- Exploring Queries 3m
- Exploring Forms 3m
- Exploring Reports 4m
- Designing a Relational Database 6m
- Creating a Desktop Database Using a Template 4m
- Creating a Blank Desktop Database 2m
- Creating a Table in Datasheet View 4m
- Creating a Table in Table Design 4m
- Designating Primary Keys 3m
- Adding Records to a Table 4m
- Modifying the Table Structure 3m
Working with Tables
30mins
Fields and Queries
64mins
- Creating a Lookup Field 3m
- Creating a Calculated Field 3m
- Adding Attachments 3m
- Inserting an OLE Object 3m
- Copying a Table 3m
- Creating a Query Using the Simple Query Wizard 3m
- Creating a Query in Query Design 3m
- Adding, Deleting, and Rearranging Fields in a Query 2m
- Sorting Records in a Query 4m
- Specifying Criteria in a Query 6m
- Copying and Changing a Query 3m
- Showing Totals 3m
- Creating Calculated Fields 3m
- Performing Calculations on Grouped Records 3m
- Creating a Query from a Query 4m
- Using the Find Duplicates Query Wizard 3m
- Using the Find Unmatched Query Wizard 3m
- Using the Crosstab Query Wizard 3m
- Designing a Make Table Query 3m
- Creating a Delete Query 3m
Advanced Queries and Form Building
54mins
- Designing an Update Query 3m
- Creating an Append Query 3m
- Creating a Parameter Query 3m
- Creating a Top Values Query 3m
- Creating a Form 3m
- Creating a Form Using the Form Wizard 3m
- Creating a Form in Form Design 4m
- Using a Form to Add Records 3m
- Finding and Modifying Records Using a Form 4m
- Modifying a Form 2m
- Formatting a Form 3m
- Using Conditional Formatting 4m
- Creating a Report 5m
- Using the Report Wizard 4m
- Creating a Report in Report Design 3m
- Modifying a Report to Add and Arrange Controls 5m
Formatting and Printing
43mins
- Adding a Calculated Control 5m
- Adding Grouping and Sorting in Reports 4m
- Adding Totals to a Report 6m
- Reducing White Space and Aligning Fields in a Report 6m
- Formatting Controls in a Report 6m
- Adding Conditional Formatting to a Control 3m
- Applying Themes to a Report 3m
- Previewing and Printing Reports 7m
- Creating Labels 4m
