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 Bedford

With a population of 80,000 Bedford is a county town in Bedfordshire, England. The Offa of Mercia is said to be buried at Bedford. Built by Henry I , the Bedford Castle  saw its destruction in 1224. Bedford has been represented in Parliament since 1265. A significant part of the population of Bedford is Italian.

Bedford is named after a Saxon chief Beda, and a ford crossing the River Great Ouse. The subburb was known for its market since early Middle Ages.

 John Bunyan, wrote The Pilgrims Progress while in Bedford Gaol.  During this time brewing became a major industry in the town. Bedford became an engineering hub by the 19th century. Railways reached Bedford in 1846.

Transport

Bedford is linked to the town and other parts of England either by Bus or by Rail. The A6 road provides road access to the city. There and two railway stations and a network of bus services that serve the city’s transport system.

Bedford bus station

 

The Stagecoach in Bedford and Bedford Borough Council own the bus station at Bedford. It serves the population is located  in the city centre on All Hallows .

 

Religious Places

Christian Churches

  • The Civic and County Church of St Paul's 
  • The Church of St Peter's
  • Four churches from the New frontiers network
  • Polish and Italian Roman Catholic churches 
  • LDS (Mormon) meeting houses
  • Numerous independent churches

 

There are many Sikh temples in Bedford with one of them being in Kempston. It also houses temples of Guru Ravidass and Valmiki.

The following communities also meet in Bedford:

  • Quaker
  • Jehovah’s Witness
  • Wiccan

 

 

Filmography

  • During the 1970’s BBC TV aired the series “Some Mothers Do 'Ave 'Em” in and around Bedford.
  • In the 2005 “Batman Begins” movie some scenes were shot at the Cardington Sheds near Bedford . It’s sequel , 'The Dark Knight', was also partially filmed at the sheds using the fake working name 'Rory's First Kiss'
  • In the 2006 Comedy Central version of Outsourced, a good natured Bedfordian played a comic role in "I'm From England".

People from Bedford

  • John Bunyan – Author of “The Pilgrims Progress”
  • John Howard – Sherriff of Bedfordshire
  • John Oliver – Comedian
  • Joe Bugner – Heavyweight Boxer
  • Monty Panesor – Cricketer
  • Will Smith – Cricketer

 

 

 

More