Microsoft Acces 2013

Apply now for our Microsoft Acces 2013 Course



  • Work with Table Data and Query a Database
  • Create Advanced Queries and Generate Reports
  • Customize the Access Environment and Design a Relational Database
  • Join Tables and Organize a Database for Efficiency
  • Use Macros to Improve User Interface Design
  • Distribute and Secure a Database
  • Use Advanced Database Management and Share Data Across Applicatim
  • Implement Advanced Form Design and Using Data Validation


Course Details and Pricing


Instructor Led Learning


  Duration: 2 Days

  Registration Open Now!

Video Learning


  Duration: 2 Days

  Registration Open Now!

Call us : 0861 111 460

Microsoft Acces 2013 overview

Microsoft Acces 2013 Course overview

Part 1:
In this course, students will learn how to use Access 2013 to manage data, including creating a new database; constructing tables; designing forms and reports; and creating queries to join, filter, and sort data.

Part 2:
In this course, students learn advanced Access features such as database management, advanced form design, packaging a database, encrypting a database, preparing a database for multi-user access and more.





Microsoft Acces Course capetown south africa

Who Should Attend Microsoft Access Course:

Part 1:
This course is designed for students who wish to establish a foundational understanding of Microsoft Office Access 2013, including the skills necessary to create a new database, construct data tables, design forms and reports, and create queries.

Part 2:

Students taking this course are database administrators or prospective database administrators who have experience working with Access 2013 and need to learn advanced skills. This course is also for students who seek the Microsoft Office Specialist (MOS) certification and who want to prepare for Exam 77-885, Microsoft Office 2013.

Microsoft Project 2013 Course capetown south africa

Microsoft Access 2013 courses | Online & Classroom Training

Microsoft Access 2013 courses will provide you with the basic skills required to work with Microsoft Access 2013 databases, including the creating and interacting with the Access tables, relationships, queries, forms and reports.



Microsoft Access 2013 is a relational database application in the Microsoft 2013 office suite that lets you enter, manage and run reports on large amounts of data. Microsoft Access 2013 also provides you with more knowledge on how to rich platform for developing database management solutions with easy-to-use customization tools.

Improve your career, and get your training here! MasterGrade IT Offers Online Access training.





Microsoft Acces Course capetown south africa, it training Microsoft, Microsoft training

3 Steps to Master Microsoft Acces 2013

01

Take a
course

02

Write an
Exam

03

Get
Certified

What you will learn
Microsoft Acces 2013 Training Course


      Level 1

    • Orientation Lesson Welcome to MastergradeIT
    • Lesson 1Getting Started with Access
    • Lesson 2Working with Table Data
    • Lesson 3 Querying a Database
    • Lesson 4Creating Advanced Queries
    • Lesson 5 Generating Reports
    • Lesson 6 Customizing the Access Environment
    • Lesson 7 Designing a Relational Database
    • Lesson 8 Joining Tables
    • Lesson 9 Organizing a Database for Efficiency
    • Lesson 10Sharing Data Across Applications
    • Lesson 11Advanced Reporting

    Level 2 

  • Lesson 1 Implementing Advanced Form Design
  • Lesson 2Using Data Validation
  • Lesson 3 Using Macros to Improve User Interface Design
  • Lesson 4 Using Advanced Database Management
  • Lesson 5 Distributing and Securing a Database
  • Lesson 6 Managing Switchboards

Full course outline
Microsoft 2013 Project Training Course

Microsoft Access 2013 Part 1

Lesson 1: Getting Started with Access

  • Orientation to Microsoft Access
  • Create a Simple Access Database
  • Get Help in Microsoft Access

Lesson 2: Working with Table Data

  • Modify Table Data
  • Sort and Filter Records
  • Create Lookups

Lesson 3: Querying a Database

  • Join Data from Different Tables in a Query
  • Sort and Filter Data in a Query
  • Perform Calculations in a Query

Lesson 4: Creating Advanced Queries

  • Create Parameter Queries
  • Create Action Queries
  • Create Unmatched and Duplicate Queries
  • Summarize Data

Lesson 5: Generating Reports

  • Create a Report
  • Add Controls to a Report
  • Enhance the Appearance of a Report
  • Prepare a Report for Print

Lesson 6: Customizing the Access Environment

  • The Access Options Dialog Box

Lesson 7: Designing a Relational Database

  • Relational Database Design
  • Create a Table
  • Create Table Relationships

Lesson 8: Joining Tables

  • Create Query Joins
  • Join Tables That Have No Common Fields
  • Relate Data within a Table
  • Work with Subdatasheets
  • Create Subqueries

Lesson 9: Organizing a Database for Efficiency

  • Data Normalization
  • Create a Junction Table
  • Improve Table Structure

Lesson 10: Sharing Data Across Applications

  • Import Data into Access
  • Export Data to Text File Formats
  • Export Access Data to Excel
  • Create a Mail Merge

Lesson 11: Advanced Reporting

  • Organize Report Information
  • Format Reports
  • Include Control Formatting in a Report
  • Add a Calculated Field to a Report
  • Add a Subreport to an Existing Report

Microsoft Access 2013 Part 2

Lesson 1: Implementing Advanced Form Design

  • Add Controls to Forms
  • Create Subforms
  • Organize Information with Tab Pages
  • Enhance Navigation of Forms
  • Apply Conditional Formatting

Lesson 2: Using Data Validation

  • Field and Record Validation
  • Form Validation

Lesson 3: Using Macros to Improve User Interface Design

  • Create a Macro
  • Restrict Records Using a Condition
  • Validate Data Using a Macro
  • Automate Data Entry Using a Macro
  • Convert a Macro to VBA

Lesson 4: Using Advanced Database Management

  • Link Tables to External Data Sources
  • Manage a Database
  • Determine Object Dependency
  • Document a Database
  • Analyze the Performance of a Database

Lesson 5: Distributing and Securing a Database

  • Splitting a Database for Multiple User Access
  • Implement Security
  • Set Passwords
  • Convert an Access Database to an ACCDE File
  • Package a Database with a Digital Signature

Lesson 6: Managing Switchboards

  • Create a Database Switchboard
  • Modify a Database Switchboard
  • Set Startup Options

Are you ready to become a Microsoft Access expert?