The need for databases is 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.
Take your data management to the next level! This course will show you how to harness the full power of Microsoft Access 2013. 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. You will also 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 using 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 your queries more effective and reports using conditional formatting to highlight key data points.
MS Access is used extensively in business for data management and storage. It is widely used to track and manage information such as company information, customer details, contact information, and order numbers. Its ability to hold, manage, present, and summarize very large amounts of data quickly and simply means that it is very widely used.
It contains a number of very useful templates which can save a lot of setup 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 that doesn’t have any strange requirements, then it can now let you do so very quickly. It has improved a number of areas, like autocomplete, and offers a standardized framework that makes navigation significantly easier.
Basic knowledge in Microsoft Windows 7 or 8
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.
| Objectives |
| Database Concepts |
| RDBMS: Relational Database Management System |
| Elements of an Access Database |
| Tables, Forms, Queries & Reports |
| A Database Plan |
| 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 |
| 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 |
| Creating a Switch Board with Switch Board Manager |
| Customizing Switch Boards |
| Creating Switch Board Menus |
| Setting Startup Options |
| 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 |
| 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) |
| 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 |
Duration: One Month
Timing: 7:00pm to 9:00pm
Days: Three Days a Week (Alternate)
Course Fee: Rs.8,000/-
OraSoft Training Institute has been developing the IT workforce in Karachi and Pakistan for 26 years, focusing on facilities, technology, and people to uphold its reputation for excellence in technology training.
OraSoft Training Institute, Copyright © 1999 - 2025, All rights reserved.
Design By Visual Innovative
