Microsoft Access (2016)

Pluralsight

Course Summary

In this course, you will use Microsoft Access to create a desktop-based database. Software required: Microsoft Access (2016).

+
Course Description

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).

Course Description

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).

+
Course Syllabus

Getting Started with Access 2016
- 57m 32s

—What Is Access? 3m 33s
—Getting Started 3m 17s
—Understanding the Access Environment 3m 51s
—Working with Backstage View 3m 31s
—Using the Navigation Pane 2m 39s
—Exploring Tables 2m 23s
—Exploring Queries 2m 52s
—Exploring Forms 3m 16s
—Exploring Reports 3m 30s
—Designing a Relational Database 5m 44s
—Creating a Desktop Database Using a Template 3m 46s
—Creating a Blank Desktop Database 1m 53s
—Creating a Table in Datasheet View 4m 20s
—Creating a Table in Table Design 3m 51s
—Designating Primary Keys 2m 34s
—Adding Records to a Table 3m 50s
—Modifying the Table Structure 2m 36s

Working with Tables
- 30m 28s

—Modifying Field Properties 6m 34s
—Modifying Table Layouts 4m 3s
—Navigating Around a Table 3m 28s
—Creating Table Relationships 4m 37s
—Working with Subdatasheets 2m 31s
—Finding and Replacing Data in Tables 2m 57s
—Sorting Data in Tables 2m 30s
—Filtering Data in Tables 3m 45s

Fields and Queries
- 1h 4m

—Creating a Lookup Field 3m 19s
—Creating a Calculated Field 3m 2s
—Adding Attachments 2m 53s
—Inserting an OLE Object 2m 40s
—Copying a Table 3m 4s
—Creating a Query Using the Simple Query Wizard 2m 44s
—Creating a Query in Query Design 2m 58s
—Adding, Deleting, and Rearranging Fields in a Query 2m 29s
—Sorting Records in a Query 3m 41s
—Specifying Criteria in a Query 5m 43s
—Copying and Changing a Query 3m 26s
—Showing Totals 3m 27s
—Creating Calculated Fields 3m 29s
—Performing Calculations on Grouped Records 3m 2s
—Creating a Query from a Query 4m 15s
—Using the Find Duplicates Query Wizard 3m 1s
—Using the Find Unmatched Query Wizard 3m 11s
—Using the Crosstab Query Wizard 2m 42s
—Designing a Make Table Query 2m 43s
—Creating a Delete Query 2m 35s

Advanced Queries and Form Building
- 54m 31s

—Designing an Update Query 3m 25s
—Creating an Append Query 2m 32s
—Creating a Parameter Query 3m 17s
—Creating a Top Values Query 2m 49s
—Creating a Form 3m 5s
—Creating a Form Using the Form Wizard 2m 59s
—Creating a Form in Form Design 4m 10s
—Using a Form to Add Records 3m 1s
—Finding and Modifying Records Using a Form 3m 30s
—Modifying a Form 2m 25s
—Formatting a Form 3m 17s
—Using Conditional Formatting 3m 43s
—Creating a Report 4m 37s
—Using the Report Wizard 3m 56s
—Creating a Report in Report Design 2m 59s
—Modifying a Report to Add and Arrange Controls 4m 38s

Formatting and Printing
- 43m 45s

—Adding a Calculated Control 5m 1s
—Adding Grouping and Sorting in Reports 3m 37s
—Adding Totals to a Report 6m 2s
—Reducing White Space and Aligning Fields in a Report 6m 22s
—Formatting Controls in a Report 5m 52s
—Adding Conditional Formatting to a Control 3m 18s
—Applying Themes to a Report 3m 7s
—Previewing and Printing Reports 6m 44s
—Creating Labels 3m 37s

Working with Data
- 16m 9s

—Importing Excel Data 3m 23s
—Linking Data 3m 30s
—Exporting Data to Excel 3m 13s
—Using Access Data with a Word Merge 3m 40s
—Backing up an Access Database 2m 21s