Microsoft Access 2016 Intermediate

This course is aimed to demonstrate the concepts such as reporting, form,  and macros. After the completion of the course, delegates will understand the structure of MS Access and feel comfortable moving around in the program. Once delegates understand the basic structure, the course will give practical demonstrations of how MS Access can be used to complete tasks related to the database. At the end, of course, one will have a very great idea to use Microsoft Access  2016 which will eventually boost your productivity.

Delegates will learn about working with select queries, review and work with numerous reports and reporting features of the MS Access, and review data entry forms and the several tools that go along with them. MS Access 2016 will also allow sharing of data with other Microsoft applications and one will also get to know about Automate the cyclic process with the help of macros. 

Design a Relational Database using MS Access 2016

• Design Relational Database Design
• Build Table
• Build Table Relationships

Join Tables

• Create Query Joins
• Relate Data Within a Table
• Work with the Sub-datasheets

Data Validation

• Use of Field Validation
• Use of Form and Record Validation

Table Functions

• Importing Data
• Linking Tables from External Sources
• Import Tables from other Databases
• Tables from Templates and Application Parts
• Importing Data from Excel
• Exporting Data to Excel

Reports

• Design View
• Report Sections
• Report Header
• Understand Page Header
• Group Header
• Detail
• Learn Group Footer
• Page Footer
• Understand Report Footer
• Add a Report Header/Footer 
• Add a Logo to the Report Header 
• Add a Title to the Report Header 
• Add Fields to a Report
• Add Calculate Fields
• Arrange Fields on a Report
• Resize the Detail Section
• Eliminate Repeat Headings
• Set Margins
• Group and Sort
• Set Properties for a Report
• Report Property Sheet
• Object Property Sheet
• Section Property Sheet
• Add Record Counts
• Special Report Fields
• Dates
• Page Numbering
• Controls
• Printing a Report
• Sub-reports
• Application Parts
• Deletion of  a Report
• Formatting of  a Report
• Add a Background and Images
• Apply a Theme
• Create Reports

Forms

• Design View
  • Form Sections
  • Add a Header and Footer 
  • Add a Logo to the Header 
  • Add a Title to the Header 
  • Add Fields to a Form
  • Arrange Fields on a Form
  • Spacing Objects on a Form
• Format
• Tab Order
• Set Properties on a Form
• Controls
• Forms with Application Parts
• Create a Subform
• Alter a Form
  • Deleting Forms
  • Removing Form Controls
  • Formatting a Form

Advanced Queries

• Parameter Queries
• Summarize Data
• Subqueries
• Action Queries
• Unmatched and Duplicate Queries

Macros

• Macro Basics
  • Opening a Table, Form, and Report
  • Run a Query
  • Print a Report
• Run a Macro
• Create Simple Macros

Organising a Database for Efficiency

• Data Normalization
• Create a Junction Table
• Improve Table Structure

Advanced Reporting Techniques in MS Access 2016

• Include Control Formatting in a Report
• Insert a Calculated Field to a Report
• Insert a Sub-report to an Existing Report