A Quick Glance

  • black-arrow

    Know how to into import data from Excel into your database

  • black-arrow

    Create, save and open the Microsoft Access 2016 database

  • black-arrow

    Find out how to import data from Excel into your database

  • black-arrow

    Create, save and open the Microsoft Access 2016 database

This Microsoft Access 2016 Advanced course will teach delegate to design tables for enhanced accuracy in data entry by setting default values, study the numerous options to share data with other Microsoft applications such as Word and Excel.

Delegates will also explore how to automate cyclic task with the help of Macros, advanced form techniques with the help of Tab controls, Combo Box controls and Sub-Forms, Conditional Formatting,  and advanced report techniques using Sub-Reports, columns and insert charts.

Who should take this course

  • Users who have role of data administration
  • Users want to upgrade their knowledge
  • Data Analyst
  • Graduates
More

Prerequisites

It is essential that delegates must have completed Microsoft Access 2016 Intermediate course.

More

What Will You Learn

  • Understand essential concepts and terminologies of database
  • Explore about an MS Access user  interface
  • Know how to work with views of table views, reports, forms, queries, macros and modules.
  • Learn to plan a database.
  • Validate data entered into a database
  • Use advanced queries to manipulate data
  • Understand about relationships of database
  • Apply queries to fetch data
  • Learn database design fundamentals.
  • Know about Forms and the Form Wizard
More

What's included

  Course Overview

Delegates will explore a user interface of MS Access, create tables, create a basic database, reports, forms, and make use of queries to get results, do the calculation with dates, fields, and numbers, navigate and handle tables and the different data types.

This course will also impart knowledge about working with select queries, review and work with several reports and reporting features of this application of Microsoft, and review data entry forms and the many tools that go along with them.

shortcuts of MS Access 2016

More

  Course Content

Getting Started with MS Access 2016 User Interface 

  • Access Ribbon
    • Overview of FILE
    • Save a Database as a Template
    • HOME
    • CREATE
    • EXTERNAL DATA
    • DATABASE TOOLS
    • Contextual Tabs
  • Overview of Quick Access Toolbar
  • Object Navigation Pane
  • Access Work Surface
  • Access Options Dialog Box
  • Object Overview
    • Overview Tables
    • Reports
    • Understand Queries
    • Define Forms
    • Macros to do task and Modules
  • Process Overview
  • Build Database with the help of Wizard

Fundamentals

  • Basic questions
    • Know Purpose of the database
    • Various users of the database
    • Kind of output we need
  • Approaches to Design Database
    • Top-Down
    • Bottom-Up
  • Gather Information
    • Data Mapping
    • Sample Data Map
  • Naming Conventions
  • Normalization
    • 1st NF
    • 2nd NF
    • 3rd NF
  • Table Relationships
    • Different types of Relationships
    • Normalizing Data

Handling Queries

  • Building Simple Queries
  • Sorting and Filtering of Data in a Query
  • Performing Calculations
  • Learn Dynaset
  • Enter Criteria: Exact Match and Range Operators
  • Understand difference between AND versus OR
  • Use of Wild Cards
  • Learn about use Keywords
  • Sort and Hide Fields
  • Create Multi-Table Queries
  • Additional Tips

Handle Forms

  • Build Basic Access Forms
  • Work with Data on Access Forms

Generate Reports

  • Build a Report
  • Add Controls to a Report
  • Improve an Appearance of a Report
  • Preparing a Report for Print
  • Organise Report Information
  • Format Reports

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

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 Advanced Enquiry

 

Enquire Now


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

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

About Leeds

After London, Leeds is the largest legal and financial Centre in the UK. Pentagon Training is one of the lead providers of high-quality training courses in Leeds. The venue is equipped with the modern learning resources to help you enhance your skills which will take you ahead in your career. Pentagon Training makes sure that all of their instructors have enough knowledge and experience to conduct the training so that you get the best quality of training. If you are residing in Leeds and want to upgrade your skills, then this training centre is the right choice for you.

More