A Quick Glance

  • black-arrow

    Design Tables for accuracy in Data Entry

  • black-arrow

    Sharing of Data with Other Applications

  • black-arrow

    Learn use of Action Queries

  • black-arrow

    Learn Advanced Query Techniques

  • black-arrow

    Automating Cyclic Processes with the help of Macros

  • black-arrow

    Advanced Forms

  • black-arrow

    Know Advanced Report Techniques

This Intermediate course of Microsoft Access 2016 that follows the Introduction course and is a prequel to the Advanced course, will teach delegate to design tables for improve efficiency in data entry by setting default values, understand the different options to share data with other applications such as Word and Excel. It will also help delegates to know about Action Queries to automate the process of updating, modify and delete data of the table, and review different advanced query techniques such as using Parameter queries, working with Crosstab queries, and Join Query.

The delegate will improve their knowledge about designing of the relational database, customise reports, structure existing data, write complex queries, and validation of data entered into a database. Delegates will also learn how to automate cyclic task with Macros, Combo Box controls and Sub-Forms, Conditional Formatting, and advanced reporting techniques using Sub-Reports, columns and insert charts.

Who should take this course

  • Users who want to upgrade their knowledge about MS Access 2016
  • Users who want to change to way of managing their data
  • Data Analyst
  • Programmers
More

Prerequisites

No Prerequisites are required for this course.

More

What Will You Learn

  • Learn about working how the menus and ribbons
  • Save all data at one place
  • Understanding about extracting only the information we want
  • Discover how having separate report formats reduces report preparation time
  • Learn how Access can work with other applications of MS Office
  • Design relational database
  • Join tables to get data from unrelated tables
  • Validate data entered into a database
  • Use advanced queries to manipulate data
  • Understand about relationships of database
  • Apply queries to fetch data
  • Use of macros
More

What's included

  Course Overview

MS Access 2016 course is designed to clarify the concepts such as reporting, forms,  and macros. At the end, of course, delegates will understand how MS Access was originated.

This course will give delegates a practical demos of how MS Access can be used to complete tasks such as managing the database and creating tables. It will impart knowledge related to working with select queries, review and work with several reports and reporting features, and review data entry forms.

It will also provide a feature to share data with other Microsoft applications, and one will also get to know about Automate the cyclic process with the help of macros.

diff between access 2013 and 2016

More

  Course Content

Designing a Relational Database using MS Access 2016

  • Design Relational Database Design
  • Create Table
  • Create 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

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

Reports

  • Design View
  • Report Sections
    • Report Header
    • Understand Page Header
    • Learn Group Header
    • Learn Group Footer
    • Page Footer
    • Understand Report Footer
    • Insert 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
More

Shortcuts of MS Access 2016

Shortcuts of MS Access:

Ctrl+N

New database

Ctrl+O

Open existing database

Ctrl+S/Shift+F12

Save Database

Tab

Move to next cell

F12

Open the Save As Box

Ctrl+P

Print the current object

Ctrl+F

Open Find tab in dialog box

Ctrl+H

Open Replace tab in dialog box

Arrow Down

To Move downline

Arrow Up

To Move Up  line

PgUp

To Move up  page

PgDn

Move down a page

F4

Switch to property sheet

F2

Switch between edit mode

F6

Switch windows

F5

Switch to form view

F7

Open VB Editor or Open Choose Builder dialog box

Alt+F11

Switch from the VB editor back to form

F11

Toggle between Navigation Pane

Ctrl+F6

Cycle b/w windows

Enter

Restore the window

Alt+Space

To Display Control Menu

ShortcutMenuKey

To Display shortcut menu

Alt+N

Move to next page of wizard

Alt+B

Move to the previous page of wizard

Alt+F

Complete the wizard

Home

Move to beginning

End

To Move End

Ctrl+Tab

Switch to  next tab in dialog box

Ctrl+Shift+Tab

Switch to  the previous tab in dialog box

Ctrl+C

Copy

Ctrl+V

Paste

Ctrl+X

Cut

Arrow Right/Ctrl+Arrow Right

Move to Right

Arrow Left/Ctrl+Arrow Left

Move to Left

Arrow Up/Ctrl+Arrow Up

Move to Up

Arrow Down/Ctrl+Arrow Down

Move to down

Shift+Arrow Down

Increase height

Shift+Arrow Up

Decrease height

Shift+Arrow Right

Increase width

Shift+Arrow Left

decrease  width

F2

Display complete hyperlink

F7

Check Spelling

Alt+Enter

Display Property Sheet

Alt+F4

Exit access 16

Ctrl+F2

Invoke builder

Shift+F2

Open the zoom box

Ctrl+Z/Alt+ Bkspace

Undo

Ctrl+Delete

Delete all character to the right

F5

Move the record number box



Microsoft Access 2016 Intermediate Enquiry

 

Enquire Now


----- OR -------

Reach us at +44 1344 961530 or info@pentagonit.co.uk for more information.

About Bournemouth

If any delegates want to enhance the skill set of any domain and get a good job, then Our modern training rooms are very much suitable for this purpose. If you are residing at the location of Bournemouth, then Pentagon training is an ideal place to do your course. Our trainers are very much experienced from the relevant industry. The courses that we include ITIL V3 Courses, APMP, PMP, Microsoft Technical, Lean Six Sigma, CISSP and so much more.

If you are interested in doing a certification with Pentagon Training, please call us on 0800 0355 832.

More