Leadership Program 941-328-3247

Leadership Program Leadership Program

Call Us Now

Home > Courses > Microsoft Applications Training > Microsoft Office 2013 > Microsoft Office Access 2013 Level 2

Microsoft Office Access 2013 Level 2

Code: ACC13L2

Duration: Days 1

Delivery methods: Classroom, Virtual Learning, Onsite Event

Price per delegate: $400.00

Microsoft Silver Partner

Trained over 60000 delegates

Delivered by world class instructors

Highly competitive pricing

Capped class sizes

Post course support

Course Description

Further enhance Access Database skills looking at database design and more advanced queries.

Target Student:

This course is designed for delegates wishing to gain intermediate-level skills or individuals whose job roles include constructing relational databases, performing database maintenance, creating advanced queries and reports, or integrating Access with other programs.

Prerequisites:

Your training and experience using Microsoft Access 2013 has given you basic database management skills such as creating tables, designing forms and reports, and building queries. In this course, you will expand your knowledge of relational database design, write advanced queries, structure existing data, share data across applications, and customise reports.

Performance-Based Objectives

Design a relational database
Join tables to retrieve data from unrelated tables
Streamline data entry and maintain data integrity
Share data across applications
Customise reports to organise and format the displayed information

Course Content

Module 1: Designing a Relational Database

Topic A: Relational Database Design
Topic B: Create a Table
Topic C: Create Table Relationships

Module 2: Joining Tables

Topic A: Create Query Joins
Topic B: Join Tables That Have No Common Fields
Topic C: Relate Data within a Table
Topic D: Work with Subdatasheets
Topic E: Create Subqueries

Module 3: Organising a Database for Efficiency

Topic A: Data Normalisation
Topic B: Create a Junction Table
Topic C: Improve Table Structure

Module 4: Sharing Data Across Applications

Topic A: Import Data into Access
Topic B: Export Data to Text File Formats
Topic C: Export Access Data to Excel
Topic D: Create a Mail Merge

Module 5: Advanced Reporting

Topic A: Organise Report Information
Topic B: Format Reports
Topic C: Include Control Formatting in a Report
Topic D: Add a Calculated Field to a Report
Topic E: Add a Subreport to an Existing Report

Request More Infomation

Learn how Elite helped Aimbridge Hospitality stay ahead of the competition.

Elite Training & Consultancy USA

© 2024 elitetcusa.com