ACCESS INTERMEDIATE ALL VERSIONS

access.png

Included in the course

  •  A course attendance certificate
  •  Tea and Biscuits during breaks
  • Lunch
  •  A notepad and pen
  •  A manual and datafiles

Course Code: ACCESS-L2

Duration: 1 Day 

***Course Content is based on Access 2013***

In this course, you will expand your knowledge of relational database design, write advanced queries, structure existing data, share data across applications, and customize reports. Extending your knowledge of Microsoft Access will result in a robust, functional database for your users.


Study Methods available for this course;

   Classroom Training    Onsite Training
   Mentored Learning   Correspondence
   Virtual Classroom Training    Part Time Training
   E-Learning

GET A QUOTE NOW!


Name:*
E-mail:*
Phone:
-
Date:
Study Method:
Course Code:
Course Description:
No of Students:
Message:*
Course Content

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

Lesson 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

Lesson 3: Organizing a Database for Efficiency
   Topic A: Data Normalization
   Topic B: Create a Junction Table
   Topic C: Improve Table Structure

Lesson 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

Lesson 5: Advanced Reporting
   Topic A: Organize 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

Prerequisites
Target Student

Contact Information

Address

Durbanville, Cape Town

Call Us
021 065 0347
Email

info@idigisol.co.za

Subscribe to our mailing list

* indicates required

Live Help

Live Help

Quick Contact

Search