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

Prerequisites

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

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

  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 Dereham

Dereham is situated on the A47 road as a city and civil parish in the English county of Norfolk. Dereham falls within and is the centre of administration for, the district of Breckland. Don't get confused with the Norfolk village of West Dereham that is about 25 miles away.

Since 1983 Dereham has been acting as a twin city with the town of Rüthen in North Rhine-Westphalia, Germany. It is also a sister-town of Caudebec-lès-Elbeuf, France.

Transport

Rail

In 1847, the railroad arrived in Dereham with a single track line to Wymondham. A second line was laid in 1848 to King's Lynn. Dereham connected to Fakenham in 1849 with a line that extended to Wells-On-Sea by 1857. In 1862 the city's railways were acquired by the Great Eastern Railway. To manage the increasing traffic, the rail line from Dereham to Wymondham was doubled in 1882.

In 1964 rail services between Dereham and Wells were withdrawn, and the track between Fakenham and Wells was also lifted. In 1965 the Dereham to Wymondham track was returned to a single track, and in 1968 the King's Lynn line was closed. The last passenger train on the Dereham to Wymondham line ran in 1969 despite the railway keeping the track open for freight services until 1989.

The Wars

World War I

Dereham was the victim of a Zeppelin air raid on 8 September 1915. The buildings damaged during this First World War attack on Dereham included the headquarters of the 5th Territorial Battalion of the Norfolk Regiment. The old Vicarage was used as a Red Cross hospital.

World War II

Dereham was declared as a Nodal Point in the Second World War. It was also fortified to slow down any advances the Germans made while invading the English county. Today even there is a pill box, in the railway station yard, that is preserved as a memorial by the Royal British Legion.

More