*Friday CLOSED

Timings 10.00 am - 08.00 pm

Call : 021-3455-6664, 0312-216-9325 DHA 021-35344-600, 03333808376, ISB 03333808376

Micorosft Access Database (for DBA)


Be the first to rate Micorosft Access Database
Or log in to access your purchased courses
by admin2
Price: 20,000
1 Month
0 Lessons

 

Microsoft DBA Course

The need for databases in increasingly growing. Microsoft Access database is one of the popular databases used in the industry today.
The Microsoft Access 2013 database can help you store and track a variety of information, such as inventory, contacts, or business processes. Logistically, it combines the relational Microsoft Jet Database Engine with a graphical user interface and software-development tools, and is a member of the Microsoft Office suite of applications.

[/vc_column_text]

About Course

Take your data management to the next level! This course will show you how to harness the full power of Microsoft Access. You will learn how to create and customize tables and have the opportunity to build relationships between your tables to eliminate redundancies and slash data entry time as well as discover how to achieve huge reductions in data entry errors by setting default values, creating validation rules, and building input masks. In addition, you will have the opportunity to make your database more user-friendly smart lists and other sophisticated controls. Learn how to start automating routine tasks with labor-saving macros. You will also receive tips and techniques for optimizing your database, including ways to build crosstab and summarize queries so you can access information quickly and easily as well as outer table joins that can make you queries more effective and reports using conditional formatting to highlight key data points.

Who should attend this course?

This course is appropriate for both those brand new to Microsoft Access or database technology, and for those who have been using Access database for their entire career wanting to improve their data management skills.

MS Access is used extensively in business for data management and storage. It is widely used to track and manage information company information so customers, contact details, order numbers and the like. It’s ability to hold, manage, present and summarise very large amounts of data quickly and simply mean that it is very widely used.
It contains a number of very useful templates which can save a lot of set up time for new databases. It contains a very good template for a CRM system which Access is frequently used to create. If you are looking to create a new CRM system which doesn’t have any strange requirements then it can now let you do so very quickly and it has improved a number of areas, like autocomplete, and offers a standardized framework which makes navigation significantly easier.

Course Benefits

-Course Manual

-Course Completion Certificate

Introduction

-Objectives

-Database Concepts

-RDBMS: Relational Database Management System

-Elements of an Access Database

-Tables, Forms, Queries & Reports

-A Database Plan

Forms

-Understanding AutoForms

-AutoForm: Columnar, Tabular, Datasheet

-Create a Single Table Form with Wizard

-Create a Multi Table Form with Wizard

-The Form Design View Window

-Properties Sheet Categories

-Customize a Form’s Layout

-Formatting Tips

-Add Fields to a Form

-Add Text to a Form

-Show a Yes/No Field as Check Box

-Use Combo Boxes and List Boxes

-Use Pictures, Lines and Boxes in a Form

-Use Tab Control

-Change the Record Source of Form

Queries

-Find Records with Select Queries

-What is a query?

-Types of Queries in Access

-Creating Single Table Queries

-Filtering and Sorting with Query By Example

-Look for Special Criteria

-OR Queries

-AND Queries

-Multi Table Queries

-Create Calculated Fields

-Parametric Queries

-Summarize Data with Simple Query Wizard

-Add Records from One Table to Another

-Update Records

-Delete Records with a Query

Switch Board

-Creating a Switch Board with Switch Board Manager

-Customizing Switch Boards

-Creating Switch Board Menus

-Setting Startup Options

Tables

-Access Field Types

-Create Table with Table Design View

-Creating Employee Database

-Establishing Relationship

-Field Properties

-Fill in Default Values

-Validation Rules

-Check Data Against Input Masks

-Valid Input Mask Characters

-Format Property (Numbers)

-Format Property (Date/Time)

-Format Property (Text)

-Lookup Values from a List or Table

-Setting Table Properties

Filters

-Difference between Filters and Queries

-Filter Records Using One Field

-Filter By Selection

-Filter Excluding Selection

-Filter For

-Filter by Form

-Filter Using Multiple Fields and Values (AND) (OR)

Reports

-Options for Creating a New Report

-Auto Reports (Columnar & Tabular)

-The Report Wizard

-A Single Table Report

-A Multi Table Report

-A Summary Report With Details

-Customize Reports

-Define A Calculated Field

-Define A Summary Field

  • Experienced & Accredited Trainers
  • Accredited Training Material
  • FREE Practice Examinations
  • Excellent first attempt pass ratio

FREE Practice Exam

  • Industry best Practice exams would be provided to students FREE of charges to ensure exam success


INTERNATIONAL STUDENT FEE; $150


Regular Course Fee in Pakistan;12,000 PKR



Flexible Class Options

  • Week End Classes For Professionals  SAT | SUN
  • Corporate Group Trainings Available
  • Online Classes – Live Virtual Class (L.V.C), Online Training

Practice Exam

Practice examinations are part of the training session


Assessment 

To be awarded the Certificate in  Micorosft Access Database participants will be required to successfully complete project work (100%).


TRAINING CERTIFICATE 

Omni Academy a Federal Government – Skill Development Council Partner Training Institute Diploma Certificate would be awarded to successful students.

  • Database Admin in Microsoft SQL Server

  • Database Programming with MySQL

  • Microsoft Tracks – MCSE

  • Microsoft Certification Tracks – MCSA

  • Microsoft Sharepoint Developer

Accredited Training Material

Online Classes For Out of City/ Country Students

High Exam Pass Rate

Course Training Manual & CD's

Accredited Trainers

FREE Practice Exam

Register Now

[/vc_column][/vc_row]

Lessons

Or log in to access your purchased courses
Micorosft Access Database
ABOUT US

OMNI ACADEMY & CONSULTING is one of the most prestigious Training & Consulting firm, founded in 2010, under MHSG Consulting Group aim to help our customers in transforming their people and business - be more engage with customers through digital transformation. Helping People to Get Valuable Skills and Get Jobs.

Read More

Contact Us

Get your self enrolled for unlimited learning 1000+ Courses, Corporate Group Training, Instructor led Class-Room and ONLINE learning options. Join Now!
  • Head Office: A-2/3 Westland Trade Centre, Shahra-e-Faisal PECHS Karachi 75350 Pakistan Call 0213-455-6664 WhatsApp 0334-318-2845, 0336-7222-191, +92 312 2169325
  • Gulshan Branch: A-242, Sardar Ali Sabri Rd. Block-2, Gulshan-e-Iqbal, Karachi-75300, Call/WhatsApp 0213-498-6664, 0331-3929-217, 0334-1757-521, 0312-2169325
  • ONLINE INQUIRY: Call/WhatsApp +92 312 2169325, 0334-318-2845, Lahore 0333-3808376, Islamabad 0331-3929217, Saudi Arabia 050 2283468
  • DHA Branch: 14-C, Saher Commercial Area, Phase VII, Defence Housing Authority, Karachi-75500 Pakistan. 0213-5344600, 0337-7222-191, 0333-3808-376
  • info@omni-academy.com
  • FREE Support | WhatsApp/Chat/Call : +92 312 2169325
WORKING HOURS

  • Monday10.00am - 7.00pm
  • Tuesday10.00am - 7.00pm
  • Wednesday10.00am - 7.00pm
  • Thursday10.00am - 7.00pm
  • FridayClosed
  • Saturday10.00am - 7.00pm
  • Sunday10.00am - 7.00pm
WhatsApp Us