Microsoft Access

VOCABULARY

Chapter 1 - Getting Started with Microsoft Access 2016

• Lesson 1 - Planning a Database
• Lesson 2 - Creating a Database with Access
• Lesson 4 - Modifying Fields in a Table
• Lesson 5 - Importing and Protecting Data
• Lesson 6 - Using Table Templates and Design View

Chapter 2 - Working with Queries

• Lesson 8 - Managing Relationships Between Tables
• Lesson 9 - Finding, Replacing, and Sorting Data
• Lesson 10 - Filtering Data
• Lesson 11 - Creating a Query in Design View
• Lesson 13 - Using Criteria in a Query
• Lesson 14, Lesson 15, Lesson 16 - Additional Terms

Chapter 3 - Working with Forms and Reports

• Lesson 18 - Working with a Form in Layout View
• Lesson 19 - Working with a Form in Design View
• Lesson 20 - Working with Form Sections
• Lesson 21 - Creating a Report

SLIDE PRESENTATION

Chapter 1: Getting Started with Microsoft Access 2016

• Lesson 1: Planning a Database
• Lesson 2: Creating a Database with Access
• Lesson 3: Modifying and Adding Data to a Table
• Lesson 4: Modifying Fields in a Table
• Lesson 5: Importing and Protecting Data
• Lesson 6: Using Table Templates and Design View
• Lesson 7: Creating Other Objects

Chapter 2: Working with Queries

• Lesson 8: Managing Relationships Between Tables
• Lesson 9: Finding, Replacing, and Sorting Data
• Lesson 10: Filtering Data
• Lesson 11: Creating a Query in Design View
• Lesson 12: Creating a Multi-Table Query
• Lesson 13: Using Criteria in a Query
• Lesson 14: Using Comparison Operators
• Lesson 15: Using Calculated Fields
• Lesson 16: Summarizing Data in Queries

Chapter 3: Working with Forms and Reports

• Lesson 17: Creating and Using a Form
• Lesson 18: Working with a Form in Layout View
• Lesson 19: Working with a Form in Design View
• Lesson 20: Working with Form Selections
• Lesson 21: Creating a Report
• Lesson 22: Modifying a Report in Design View
• Lesson 23: Creating Labels
• Lesson 24: Creating a Lookup List
• Lesson 25: Creating an Input Mask

ILLUSTRATED:

SLIDE PRESENTATION

Getting Started with Access 2016

Building and Using Queries

Using Forms

Using Reports

Modifying the Database Structure

Improving Queries

Enhancing Forms

Analyzing Data with Reports

Importing and Exporting Data

Creating Advanced Queries

Creating Advanced Reports

Creating Macros

Administering the Database

VIDEOS

(Video library courtesy of Lynda.com)

01 Getting Started

• Key Database Concepts
• Launching Access and the Backstage Screen
• Creating the Database File
• Understanding the Trust Center
• Digging into the Ribbon Tabs
• Using the Navigation Pane
• Using the Quick Access Toolbar

02 Creating Tables

• Understand Table Structure and Relationships
• Creating a Table and Setting Data Types
• Entering Data
• Understanding Primary and Foreign Keys
• Importing Tables

03 Setting Field Properties

• Establishing Relationships and Maintaining Referential Integrity
• Editing Table Structure in Design View
• Controlling Input with Masks
• Setting the Default Value
• Establishing Validation Rules
• Creating Lookup Tables
• Setting Additional Field Properties

04 Organizing Records

• Formatting Columns
• Sorting Table Data
• Filtering Table Data
• Searching and Replacing Values

05 Using Queries

• Understanding Queries
• Creating Queries with the Simple Query Wizard
• Building Queries in Design View
• Establishing Constraints with Criteria
• Specifying Criteria with Wildcards
• Leveraging Multiple Criteria with AND and OR statements
• Filtering with Mathematical Comparisons
• Creating Flexible Queries with Parameter Requests
• Building Expressions
• Obtaining Summary Statistics

06 Working with Specialty Queries

• Using Update Queries
• Using Make Table Queries
• Using Delete Queries
• Using Append Queries
• Getting a Different Look with Crosstab Queries
• Creating a Union Query in SQL View

07 Creating Forms

• Understanding the Role of Forms
• Generating Forms from Tables
• Adjusting Form Elements in Layout View
• Using the Form Wizard

08 Designing Forms

• Creating Forms in Design View
• Exploring the Form Property Sheet
• Setting Data Sources
• Adding Components with Form Controls
• Understanding Input Boxes
• Recording Navigation
• Adding Buttons
• Assigning Tab Order
• Checking Out the More Forms Option
• Creating a Navigation Form

09 Creating Reports

• Introducing Reports
• Using the Report Wizard
• Creating a Report in Design View
• Grouping and Sorting Records
• Creating Calculated Totals
• Applying Conditional Formatting
• Creating Labels
• Adjusting Print Settings

10 Working with Macros

• Creating Macros
• Embedding Macros into Buttons
• Attaching Data Macros to Tables
• Launching Macros at Startup

11 Maintaining the Database

• Organizing the navigation Pane with Custom Groups
• Compacting and Repairing the Database
• Examining Database Object Relationships
• Documenting Your Work
• Printing the Blueprint of Your Database with the Database Documenter
• Splitting a Database into Front and Back Ends
• Protecting the Database with a Password
• Creating Custom Ribbon Tabs
• Setting Startup Options and Custom Icons

Video Exercise Files