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 Liverpool

Liverpool

With estimated population of 478,580 (in 2015), Liverpool is the city in the North West of England. It is the fifth largest metropolitan area in the UK with more than 2.24 million people in 2011. Liverpool City Council is the local authority and is the most populous local government district. Liverpool is located near Mersey Estuary. It turns out to be a borough in 1207 and a city in 1880. It became a county borough independent of Lancashire in 1889.

Government

There are two types of government in Liverpool i.e. the Mayor and Local Council. They are also the stakeholders in the Liverpool City Region Combined Authority, the European Parliament and The National Government. Unitary Authority officially governed Liverpool as when Merseyside Country Council was disabled civil functions were returned to a district borough level.  However, services like Police and Fire and Recuse Service are still run at a county-wide level.

Economy

Locating at the centre of one of the two core economics, Liverpool has one of the largest economies in the UK. The GVA of Liverpool in 2006 was £7,626 million that was above North West average. Since the mid-1990s, the economy has been very strong with its GVA 71.8% in between 1995 and 2006 and employment 12% between 1998 and 2006. The economy of Liverpool is dominated by both public and private service sector industries.  Over 60percentage of employment in the city was in the public administration, banking, finance, health, insurance and education sectors. 

Landmarks

The history of Liverpool contains a variety of architectural styles (16th century Tudor building to modern-day architectures). The present buildings are of the period when the city attains powers in the British Empire. The history of Liverpool contains a variety of architectural styles (16th century Tudor building to modern-day architectures). The present buildings are of the period when the city attains powers in the British Empire. Also, the city has several public sculptures. The English Heritage describes the richness of architecture.

More