Microsoft Access 2013 (INTERMEDIATE)

Our Ration for the course : 4.7 Start Based on 24 users

Experienced and Friendly Expert Trainers

Practical hands-on Training

Interactive Training Experience

Name of Course	Scheduled Dates	Vanue	Registration Link
Microsoft Access 2013 (Intermediate)	To be determined	Baghdad, Iraq	Registration Now
Microsoft Access 2013 (Intermediate)	To be determined	Tehran, Iran	Registration Now
Microsoft Access 2013 (Intermediate)	To be determined	Jeddah, Suadi Arabia	Registration Now
Microsoft Access 2013 (Intermediate)	To be determined	Muscat, Oman	Registration Now
Microsoft Access 2013 (Intermediate)	To be determined	Beirut, Lebanon	Registration Now
Microsoft Access 2013 (Intermediate)	To be determined	Kuwait City, Kuwait	Registration Now
Microsoft Access 2013 (Intermediate)	To be determined	Manama, Bahrain	Registration Now
Microsoft Access 2013 (Intermediate)	To be determined	Dubai, UAE	Registration Now
Microsoft Access 2013 (Intermediate)	To be determined	Doha, Qatar	Registration Now
Microsoft Access 2013 (Intermediate)	To be determined	Jeddah, Suadi Arabia	Registration Now
Microsoft Access 2013 (Intermediate)	To be determined	Cairo, Egypt	Registration Now
Microsoft Access 2013 (Intermediate)	To be determined	Manama, Bahrain	Registration Now
Microsoft Access 2013 (Intermediate)	To be determined	Dubai, UAE	Registration Now
Microsoft Access 2013 (Intermediate)	To be determined	Chennai, India	Registration Now
Microsoft Access 2013 (Intermediate)	To be determined	Abu Dhabi, UAE	Registration Now
Microsoft Access 2013 (Intermediate)	To be determined	NBIZ Infosol Abu Dhabi	Registration Now
Microsoft Access 2013 (Intermediate)	To be determined	NBIZ Infosol Abu Dhabi	Registration Now
Microsoft Access 2013 (Intermediate)	To be determined	NBIZ Infosol Abu Dhabi	Registration Now
Microsoft Access 2013 (Intermediate)	To be determined	NBIZ Infosol Abu Dhabi	Registration Now

Introduction

This one-day instructor-led course provides students with an overview of the features and functions of Microsoft Office Access 2013. This course is intended for information workers who want to learn intermediate-level Access 2013 skills. Before attending this course, students must have basic computer knowledge, basic file-management skills, basic knowledge of the Access 2013 interface and database, table, and form creation and manipulation.

Course Objectives

After completing this course, students will know how to control the types of data that can be entered in a table, extract or manipulate data by using queries, and customize forms and reports to meet their needs. They will also know how to customize and maintain an Access database and how to prepare a database that will be used by other people. Specifically, they will be able to:

Restrict the type and amount of data in a field.
Specify the format of data in a field.
Restrict data by using validation rules.
Create a simple or multi-column lookup list.
Add controls to a form.
Enter data in a form by using VBA.
Create a form by using an Auto Form.
Add a sub form to a form.
Locate information that matches multiple criteria.
Create a query by using a wizard or manually.
Perform calculations by using a query.
Update information in a table.
Delete information from a table.
Create a report by using a wizard or manually.
Modify report design and content.
Add a sub report to a report.
Preview and print a report.
Make favorite Access commands quickly available.
Create custom categories.
Assign a password to a database.
Prevent database problems.
Create a switchboard.
Control the features available to database users.
Prevent changes to database code.
Secure a database for distribution.

Duration & Learning Level

Learning Level:

Duration:

Module 1: Data Integrity

Restricting the Type of Data in a Field
Restricting the Amount of Data in a Field
Specifying the Format of Data in a Field
Restricting Data by Using Validation Rules
Creating a Simple Lookup List
Creating a Multi-Column Lookup List

Module 2: Custom Forms

Adding Controls to a Form
Entering Data in a Form by Using VBA
Creating a Form by Using an AutoForm
Adding a Subform to a Form

Module 3: Queries

Locating Information That Matches Multiple Criteria
Creating a Query by Using a Wizard
Creating a Query Manually
Performing Calculations by Using a Query
Updating Information in a Table
Deleting Information from a Table

Module 4: Reports

Creating a Report by Using a Wizard
Modifying Report Design
Creating a Report Manually
Modifying Report Content
Adding a Sub report to a Report
Previewing and Printing a Report

Module 5: Database Management

Making Favorite Access Commands Quickly Available
Creating Custom Categories
Assigning a Password to a Database
Preventing Database Problems

Module 6: Database Distribution

Creating a Switchboard
Controlling the Features Available to Database Users
Preventing Changes to Database Code
Securing a Database for Distribution

Exam & Certificate

Upon completion of the training the participants will be provided a Certificate of Completion / Attendance.

Participants have the option to gain MOS - Microsoft Office Specialist Certification by clearing the required exam. Microsoft Office Specialist (MOS) Certification is granted to individuals who have excellent skills and expertise in using Microsoft Office applications. This is a comprehensive certification authorized by Microsoft and it validates your competency and knowledge in Microsoft Office. Details are available through this link.

Target Group

Regular Computer Users
Office Personnel
Sales Professionals
Participants who want to learn intermediate-level MSAccess
Supervisors and Managers

1. How do I enroll/register for the training course?

To enroll or register to any training course, you can use the registration page from training page or fill the request a call back form from each course pages. The following page will provide you a list of course and training that we are providing based on the category and from each course item you can see the course details.
URL: https://nbizinfosol.twtests.co.in/training.aspx
Another method is to fill a Request a call back form provided in each Training/Course pages.