Microsoft Access 2016 Essentials

Regular price: $19.99
Sale price: $19.99
Regular price
Unit price: per

Quantity must be 1 or more

Learners will gain a fundamental understanding of this database application's environment and basic database principles. They will be able to demonstrate the correct use of key features and the ability to create and maintain tables, relationships, forms, reports, and queries.

ACCESS 2016 ESSENTIALS COURSE OUTLINE:

Module One: Create and Manage a Database

Create and Modify Databases
Create a blank desktop database
Create a database from a template
Create a database by using Import objects or data from other sources
Delete database objects
Manage Relationships and Keys
Create and modify relationships
Set the primary key
Enforce referential integrity
Set foreign keys, view relationships
Navigate through a Database
Navigate specific records
Create and modify a navigation form
Set a form as the startup option
Display objects in the Navigation Pane
Change views of objects
Protect and Maintain Databases
Compact a database
Repair a database, back up a database
Split a database
Encrypt a database with a password
Recover data from backup
Print and Export Data
Print reports
Print records
Save a database as a template
Export objects to alternative formats

Module Two: Build tables

Create a table
Import data into tables
Create linked tables from external sources
Import tables from other databases
Create a table from a template with application parts
Manage Tables
Hide fields in tables
Add total rows
Add table descriptions
Rename tables
Manage Records in Tables
Update records
Delete records
Append records from external data
Find and replace data
Sort records, filter records
Create and Modify Fields
Add fields to tables
Add validation rules to fields
Change field captions
Change field sizes
Change field data types
Configure fields to auto-increment
Set default values
Using input masks
Delete fields

Module Three: Create Queries

Create a Query
Run a query
Create a crosstab query
Create a parameter query
Create an action query
Create a multi-table query
Save a query
Modify a Query
Rename a query
Add fields, remove fields
Hide fields
Sort data within queries
Format fields within queries
Create Calculated Fields and Grouping within Queries
Add calculated fields
Set filtering criteria
Group and summarize data
Group data by using comparison operators
Group data by using arithmetic and logical operators

Module Four: Create Forms

Create a Form
Create a form
Create a form from a template with application parts
Save a form
Configure Form Controls
Move form controls
Add form controls
Modify data sources
Remove form controls
Set form control properties
Manage labels
Add sub-forms
Format a Form
Modify tab order
Configure Print settings
Sort records by form field
Apply a theme
Control form positioning
Insert backgrounds, insert headers and footers, insert images

Module Five: Create Reports

Create a Report
Create a report based on the query or table
Create a report in Design view
Create a report by using a wizard
Configure Report Controls
Group and sort fields
Modify data sources
Add report controls
Add and modify labels
Format a Report
Format a report into multiple columns
Add calculated fields
Control report positioning
Format report elements
Change report orientation
Insert header and footer information
Insert images
Apply a theme