2113 – Microsoft Access 2016 Core EssentialsDownload Course Outline
Title: Microsoft Access 2016 Core Essentials 2113; 2 Days, Instructor-led
Description: Access is Microsoft’s flagship database application that allows you to create and manage databases for all sorts of different purposes. This new version of Access incorporates a few new features and connectivity options in order to make databases more accessible to the everyday user. This course is intended to help all novice computer users get up to speed quickly. It will also help more experienced users who have little to no experience with Microsoft Access and databases in general.
At Course Completion:
Audience & Prerequisites:
Course Outline Details: Module 1: Getting Started with Access Orientation to Microsoft Access Creating a Simple Access Database Get Help in Microsoft Access Module 2: Working with Table Data Modify Table Data Work with Record Soft and Filter Records Create Lookups Module 3: Querying a Database Join data from different tables in a query Sort and filter data in a query Perform calculations in a query Module 4: Generating Reports Creating a Report Add Controls to a Report Enhance the Appearance of a Report Prepare a Report for print Module 5: Customizing the Access Environment The Access Options Dialog Box Module 6: Designing a Relational Database Relational Database Design Create a Table Modify a Table and Fields Create Table Relationships Module 7: Joining Tables Creating Query Joins Join Tables That Have No Common Fields Relate Data within a Table Work with Subdatasheets Create subqueries Module 8: Organizing a Database for Efficiency Database Normalization Create a Junction Table
Start Date: 07/15/2019
End Date: 07/16/2019