0
SUBTOTAL :
empty cartcheckout
Micorosft Access Database (for DBA)

Micorosft Access Database (for DBA)

Size
Price:
Add to CartProduct Added View Cart Checkout
Product Tags:

Read more

 1Month/10 Hours                                                  Price:25,000

                                                                                      20,000

Micorosft Access Database (for DBA)


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.

Key Learnings:

 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 Content:

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


INTERNATIONAL STUDENT FEE; $150


Job Interview Preparation  (Soft Skills Questions & Answers)


0 Reviews

Contact form

Name

Email *

Message *