Microsoft Access 2016
BEGINNING
Introduction: Office 2016 and Windows 10: Essential Concepts and Skill
OBJECTIVE:
•Use a touch screen
•Perform basic mouse operations
•Start Windows and sign in to an account
•Identify the objects in the Windows 10 desktop
•Identify the apps in and versions of Microsoft Office 2016
•Run an app
•Identify the components of the Microsoft Office ribbon
•Create folders
•Save files
•Change screen resolution
•Perform basic tasks in Microsoft Office apps
•Manage files
•Use Microsoft Office Help and Windows Help
•Use a touch screen
•Perform basic mouse operations
•Start Windows and sign in to an account
•Identify the objects in the Windows 10 desktop
•Identify the apps in and versions of Microsoft Office 2016
•Run an app
•Identify the components of the Microsoft Office ribbon
•Create folders
•Save files
•Change screen resolution
•Perform basic tasks in Microsoft Office apps
•Manage files
•Use Microsoft Office Help and Windows Help
Module 1: Databases and Database Objects: An Introduction
OBJECTIVE:
•Describe the features of the Access window
•Create a database
•Create tables in Datasheet and Design views
•Add records to a table
•Close a database
•Open a database
•Print the contents of a table
•Create and use a query
•Create and use a form
•Create and print custom reports
•Modify a report in Layout view
•Perform special database operations
•Design a database to satisfy a collection of requirements
•Describe the features of the Access window
•Create a database
•Create tables in Datasheet and Design views
•Add records to a table
•Close a database
•Open a database
•Print the contents of a table
•Create and use a query
•Create and use a form
•Create and print custom reports
•Modify a report in Layout view
•Perform special database operations
•Design a database to satisfy a collection of requirements
Module 2: Querying a Database
OBJECTIVE:
•Create queries using Design view
•Include fields in the design grid
•Use text and numeric data in criteria
•Save a query and use the saved query
•Create and use parameter queries
•Use compound criteria in queries
•Sort data in queries
•Join tables in queries
•Create a report and a form from a query
•Export data from a query to another application
•Perform calculations and calculate statistics in queries
•Create crosstab queries
•Customize the Navigation Pane
•Create queries using Design view
•Include fields in the design grid
•Use text and numeric data in criteria
•Save a query and use the saved query
•Create and use parameter queries
•Use compound criteria in queries
•Sort data in queries
•Join tables in queries
•Create a report and a form from a query
•Export data from a query to another application
•Perform calculations and calculate statistics in queries
•Create crosstab queries
•Customize the Navigation Pane
Module 3: Maintaining a Database
OBJECTIVE:
•Add, change, and delete records
•Search for records
•Filter records
•Update a table design
•Use action queries to update records
•Use delete queries to delete records
•Specify validation rules, default values, and formats
•Create and use single-valued lookup fields
•Create and use multivalued lookup fields
•Add new fields to an existing report
•Format a datasheet
•Specify referential integrity
•Use a subdatasheet
•Sort records
•Add, change, and delete records
•Search for records
•Filter records
•Update a table design
•Use action queries to update records
•Use delete queries to delete records
•Specify validation rules, default values, and formats
•Create and use single-valued lookup fields
•Create and use multivalued lookup fields
•Add new fields to an existing report
•Format a datasheet
•Specify referential integrity
•Use a subdatasheet
•Sort records
Module 4: Creating Reports and Forms
OBJECTIVE:
•Create reports and forms using wizards
•Modify reports and forms in Layout view
•Group and sort data in a report
•Add totals and subtotals to a report
•Conditionally format controls
•Resize columns
•Filter records in reports and forms
•Print reports and forms
•Apply themes
•Add a field to a report or form
•Add a date
•Change the format of a control
•Move controls
•Create and print mailing labels
•Create reports and forms using wizards
•Modify reports and forms in Layout view
•Group and sort data in a report
•Add totals and subtotals to a report
•Conditionally format controls
•Resize columns
•Filter records in reports and forms
•Print reports and forms
•Apply themes
•Add a field to a report or form
•Add a date
•Change the format of a control
•Move controls
•Create and print mailing labels
INTERMEDIATE
Module 5: Multiple-Table Forms
OBJECTIVE:
•Add Yes/No, Long Text, OLE Object, and Attachment fields
•Use the Input Mask Wizard
•Update fields and enter data
•Change row and column size
•Create a form with a subform in Design view
•Modify a subform and form design
•Enhance the form title
•Change tab stops and tab order
•Use the form to view data and attachments
•View object dependencies
•Use Date/Time, Long Text, and Yes/No fields in a query
•Create a form with a datasheet
•Add Yes/No, Long Text, OLE Object, and Attachment fields
•Use the Input Mask Wizard
•Update fields and enter data
•Change row and column size
•Create a form with a subform in Design view
•Modify a subform and form design
•Enhance the form title
•Change tab stops and tab order
•Use the form to view data and attachments
•View object dependencies
•Use Date/Time, Long Text, and Yes/No fields in a query
•Create a form with a datasheet
Module 6: Advanced Report Techniques
OBJECTIVE:
•Create and relate additional tables
•Create queries for reports
•Create reports in Design view
•Add fields and text boxes to a report
•Format report controls
•Group and ungroup report controls
•Update multiple report controls
•Add and modify a subreport
•Modify section properties
•Add a title, page number, and date to a report
•Preview, print, and publish a report
•Add totals and subtotals to a report
•Include a conditional value in a report
•Create and relate additional tables
•Create queries for reports
•Create reports in Design view
•Add fields and text boxes to a report
•Format report controls
•Group and ungroup report controls
•Update multiple report controls
•Add and modify a subreport
•Modify section properties
•Add a title, page number, and date to a report
•Preview, print, and publish a report
•Add totals and subtotals to a report
•Include a conditional value in a report
Module 7: Advanced Form Techniques
OBJECTIVE:
•Add combo boxes that include selection lists
•Add combo boxes for searching
•Format and resize controls
•Apply formatting characteristics with the Format Painter
•Add command buttons
•Modify buttons and combo boxes
•Add a calculated field
•Use tab controls to create a multipage form
•Add and modify a subform
•Insert charts
•Modify a chart type
•Format a chart
•Add combo boxes that include selection lists
•Add combo boxes for searching
•Format and resize controls
•Apply formatting characteristics with the Format Painter
•Add command buttons
•Modify buttons and combo boxes
•Add a calculated field
•Use tab controls to create a multipage form
•Add and modify a subform
•Insert charts
•Modify a chart type
•Format a chart
Module 8: Macros, Navigation Forms, and Control Layouts
OBJECTIVE:
•Create and modify macros and submacros
•Create a menu form with command buttons
•Create a menu form with an option group
•Create a macro for the option group
•Use an IF statement in a macro
•Create datasheet forms
•Create user interface (UI) macros
•Create navigation forms
•Add tabs to a navigation form
•Create data macros
•Create and remove control layouts
•Use the Arrange tab to modify control layouts on forms and reports
•Create and modify macros and submacros
•Create a menu form with command buttons
•Create a menu form with an option group
•Create a macro for the option group
•Use an IF statement in a macro
•Create datasheet forms
•Create user interface (UI) macros
•Create navigation forms
•Add tabs to a navigation form
•Create data macros
•Create and remove control layouts
•Use the Arrange tab to modify control layouts on forms and reports
ADVANCED
Module 9: Administering a Database
OBJECTIVE:
•Convert a database to and from earlier versions of Access
•Use the Table Analyzer, Performance Analyzer, and Documenter
•Create custom categories and groups in the Navigation Pane
•Use table, database, and field properties
•Create indexes
•Enable and use automatic error checking
•Create custom data type parts
•Create a database for a template
•Create a custom template
•Encrypt a database and set a password
•Lock a database and split a database
•Create a custom web app
•Create custom views for a web app
•Convert a database to and from earlier versions of Access
•Use the Table Analyzer, Performance Analyzer, and Documenter
•Create custom categories and groups in the Navigation Pane
•Use table, database, and field properties
•Create indexes
•Enable and use automatic error checking
•Create custom data type parts
•Create a database for a template
•Create a custom template
•Encrypt a database and set a password
•Lock a database and split a database
•Create a custom web app
•Create custom views for a web app
Module 10: Using SQL
OBJECTIVE:
•Understand the SQL language and how to use it
•Change the font or font size for queries
•Create SQL queries
•Include fields in SQL queries
•Include simple and compound criteria in SQL queries
•Use computed fields and built-in functions in SQL queries
•Sort the results in SQL queries
•Use aggregate functions in SQL queries
•Group the results in SQL queries
•Join tables in SQL queries
•Use subqueries
•Compare SQL queries with Access-generated SQL
•Use INSERT, UPDATE, and DELETE queries to update a database
•Understand the SQL language and how to use it
•Change the font or font size for queries
•Create SQL queries
•Include fields in SQL queries
•Include simple and compound criteria in SQL queries
•Use computed fields and built-in functions in SQL queries
•Sort the results in SQL queries
•Use aggregate functions in SQL queries
•Group the results in SQL queries
•Join tables in SQL queries
•Use subqueries
•Compare SQL queries with Access-generated SQL
•Use INSERT, UPDATE, and DELETE queries to update a database
Module 11: Database Design
OBJECTIVE:
•Understand the terms entity, attribute, and relationship
•Understand the terms relation and relational database
•Understand functional dependence and identify when one column is functionally dependent on another
•Understand the term primary key and identify primary keys in tables
•Design a database to satisfy a set of requirements
•Convert an unnormalized relation to first normal form
•Convert tables from first normal form to second normal form
•Convert tables from second normal form to third normal form
•Understand how to represent the design of a database using diagrams
•Understand the terms entity, attribute, and relationship
•Understand the terms relation and relational database
•Understand functional dependence and identify when one column is functionally dependent on another
•Understand the term primary key and identify primary keys in tables
•Design a database to satisfy a set of requirements
•Convert an unnormalized relation to first normal form
•Convert tables from first normal form to second normal form
•Convert tables from second normal form to third normal form
•Understand how to represent the design of a database using diagrams