Getting to Know Access 2016
- Understanding Microsoft Access 2016
- Starting Access From the Desktop
- Understanding the Start Screen
- Creating a New Blank Database
- Understanding the Backstage View
- Opening an Existing Database File
- Understanding the Access 2016 Screen
- Using the Ribbon
- Working With the Navigation Pane
- Adding Commands to the QAT
- Working With Touch Mode
- Working With a Table
- Working With Other Database Objects
- Closing a Database File
- Exiting From Access 2016
Designing a Lookup Database
- Understanding How Access Stores Data
- Understanding Access 2016 Data Types
- Scoping Your New Database
- Identifying Table Problems
- Refining Table Structures
- Finalising the Design
Creating a Lookup Database
- Creating a New Database File
- Creating the Lookup Table
- Defining the Primary Key
- Saving and Closing a Table
- Creating the Transaction Table
- Understanding Lookup Table Relationships
- Connecting to a Lookup Table
- Viewing Table Relationships
Modifying Table Structures
- Opening an Existing Table
- Adding Fields to an Existing Table
- Understanding Field Properties
- Changing Field Size
- Changing Field Names
- Changing Decimal Places
- Changing Date Formats
- Indexing Fields
- Deleting Fields From a Table
- Copying a Table Within a Database
- Deleting a Table From a Database File
Adding Records to a Table
- Typing Records in a Table
- Adding Records Using a Form
- Saving a Form Layout for Reuse
- Adding Records Using an Existing Form
- Adding Additional Records
- Importing From Microsoft Excel
Adding Transactional Records
- Typing Transactional Records
- Adding Transactional Records Using a Form
- Adding Additional Transactional Records
- Adding Records Using a Subdatasheet
- Removing a Subdatasheet
- Inserting a Subdatasheet
Working with Records
- Table Navigation
- Navigating to a Specific Record
- Editing a Record
- Deleting Record Data
- Undoing a Change
- Deleting a Record
- Deleting Several Records
- Searching in a Table
- Searching in a Field
- Finding and Replacing
- Printing Records From a Table
- Compacting a Database
Sorting and Filtering
- Simple Sorting
- Sorting on Several Fields
- Simple Filtering
- Working With Filters
- Filtering Between Dates
Creating Queries
- Understanding Queries
- Creating a Query Design
- Working With a Query
- Changing a Query Design
- Applying Record Criteria
- Clearing Selection Criteria
- Saving a Query
- Running Queries From the Navigation Pane
- Deleting a Query
- Creating Additional Queries
Creating and Using Reports
- Understanding Reporting in Access
- Creating a Basic Report
- Working With Existing Reports
- Previewing and Printing a Report
- Changing the Report Layout
- Using the Report Wizard
- Creating a Grouped Report
- Creating a Statistical Report
- Working With Grouped Reports
Creating and Using Forms
- Understanding Forms
- Creating a Basic Form
- Creating a Split Form
- Binding a Form to a Query
- Using the Form Wizard
- Working With Existing Forms
- Editing Records in a Form
- Deleting Records Through a Form
- Deleting an Unwanted Form