Sara's One Stop Computer Shop
COME SOCIALIZE WITH US!
  • Home
    • Contact Us
    • Inside My Store
    • Terabit T-Rex
    • Staff Login
  • Our Services
    • Take A Class
    • Repairs and Maintenance
    • Virus Removal
    • Website Design
  • Support
    • Worry-Free Support
    • Tips & Tricks >
      • iCloud
      • Backing Up Your Computer
    • LastPass
    • Remote Help
  • Online Classes
  • Test Your Skills

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

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

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

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

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

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

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

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

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

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

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

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

Sara's One Stop Computer Shop
24056 State Road 35 / 70
Siren, WI 54872

715-349-GEEK (4335)
EMAIL US
CONTACT US
Apple®, iPad® and iPhone® are trademarks of Apple Inc., registered in the U.S. and other countries.
Google®, Gmail®, Drive®, Docs®, Sheets® are trademarks of Google Inc., registered in the U.S. and other countries