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 Harrogate

Harrogate is a town in North Yorkshire. In the Equestrian of York-shire, the city is a traveller station. The city's visitor charismas contains its RHS Harlow Carr gardens and spa waters. Harrogate created out of two lesser payments. One is high Harrogate and other is low Harrogate. Since 2013, polls have dependably voted the town as the gladdest place to live in Britain.

Harrogate's spa water covers sulphur, iron and common salt. The city developed known as The English Spa in the Georgian era after its waters were exposed in the 16th century. In the 17th and 18th periods, its chalybeate waters were a health action. The influx of wealthy but cloying companies donated to the wealth of the town.

Governance:

In 1884, the area of Harrogate was shaped in the form of High Harrogate from the civil parish of Bilton to the civil parish of Pannal. The area engrossed adjacent areas that forms civil groups of Bilton and Starbuck. The civic area was detached in 1974 when Harrogate was inspired from the West Riding.

The MP for the Harrogate and Knaresborough electorate is Andrew Jones, Outdated. He was designated in 2010, banishing the Liberal Democrats who had won the seat in the preceding three general elections.

Geography:

This city is a hall town for commuters working in Leeds. Harrogate is wealthy and has some of the highest property values in England.

Harrogate is situated on the edge of the Yorkshire Dales. It has a dry and mild weather, typical of places in the rain shadow of the Pennines. It is on the A59 from Skipton to York. At an elevation of between 100 and 200 meters, Harrogate is advanced than many English settlements. It has an average minimum temperature in January of slightly below 0 °C and a regular supreme in July and August of 20 °C.

More