MICROSOFT ACCESS

Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Sed molestie, velit ut eleifend sollicitudin, neque orci tempor nulla, id sagittis nisi ante nec arcu.

INTRODUCTION TO DATABASE

    • Starting Access and Opening a Database
    • Understanding the Access Program Screen
    • Using Menus
    • Using Toolbars and Creating a New Workbook.

CREATING & WORKING WITH A DATABASE

    • Planning a Database 
    • Creating a Database Using the Database Wizard
    • Creating a Blank Database Creating a Table Using the Table Wizard 
    • Modifying a Table and Understanding Data Types 
    • Creating a New Table from Scratch.

WORKING WITH TABLES & FIELDS

  • Understanding Field Properties
  • Indexing a Field
  • Adding a Primary Key to a Table 
  • Inserting, Deleting, and Reordering Fields 
  • Changing a Field’s Data Type
  • Using Field Descriptions
  • Adding a Caption
  • Change the Field Size 
  • Formatting Number, Currency, and Date/Time Fields Formatting 
  • Formatting Text Fields
  • Setting a Default Value 
  • Requiring Data Entry
  • Validating Data 
  • Creating an Input Mask
  • Creating a Lookup Field
  • Creating a Value List 
  • Modifying a Lookup List

FINDING, FILTERING & FORMATTING DATA

  • Finding and Replacing Information 
  • Sorting Records 
  • Filtering by Selection 
  • Filtering by Form 
  • Creating an Advanced Filter 
  • Adjusting Row Height and Column Width 
  • Rearranging Columns 
  • Changing Gridline and Cell Effects 
  • Freezing a Field Hiding a Field Changing

NORMALIZING DATA

  • Setting a Primary Key 
  • Removing Non-related Data 
  • Removing Redundant Data 
  • Removing Repeating Data 
  • Setting Required Values in Columns 

ESTABLISHING RELATIONSHIP

  • Using the Relationship Tool 
  • Identifying a Related Table 
  • Creating Join Types 
  • Enforcing Referential Integrity 
  • Working with Cascading Updates and Deletes 

DESIGNING & WORKING WITH QUERIES

  • Creating Select Queries. 
  • Creating Update Queries 
  • Creating Delete Queries 
  • Creating Append Queries 
  • Creating Make-Table Queries 
  • Creating a One-Parameter Query 
  • Creating a Two-Parameter Query 
  • Creating Calculated Fields 
  • Using Common Functions in Calculated Fields
  • Using AND,OR Operators in Queries

DESIGNING & WORKING WITH FORMS

  • About Forms 
  • Choosing an Appropriate Control 
  • Placing Controls on a Form 
  • Moving a Control 
  • Resizing a Control 
  • Setting Control Properties 
  • Creating Page Headers and Footers 
  • Creating Form Headers and Footers 
  • Setting Form Properties 
  • Working with Identifiers 

WORKING WITH SUBFORMS

  • Creating a Subform 
  • Creating a Form with Two Subforms 
  • Creating Nested Subforms 
  • Deleting a Subform 

WORKING WITH STANDARD REPORTS

  • About Reports 
  • Placing Controls on a Report 
  • Moving a Control 
  • Resizing a Control 
  • Setting Control Properties 
  • Creating Page Headers and Footers 
  • Creating Report Headers and Footers 
  • Sorting Records on a Report 
  • Grouping Records on a Report 
  • Setting Report Properties 

WORKING WITH POP-UP REPORTS

  • Creating a Modal Pop-up Report 
  • Creating a Modeless Pop-up Report 

WORKING WITH SUB REPORTS

  • Creating a Subreport 
  • Creating a Report with Two Subreports 
  • Deleting a Subreport 

WORKING WITH REPORT SNAPSHOTS

  • Creating Report Snapshots 
  • Distributing Report Snapshots 

DEVELOPING DATA ACCESS PAGES

  • Using the New Data Access Page Wizard 
  • Defining a Data Source for a Stand-Alone Data Access Page 
  • Creating Stand-Alone Data Access Pages 

CREATING PIVOT TABLE & PIVOT CHARTS

  • Creating Pivot Tables 
  • Creating Pivot Charts 
  • Selecting Elements of a PivotT able 
  • Selecting Elements of a Pivot Chart 

CREATING PIVOT TABLE FORMS

  • Using the PivotTable AutoForm Wizard 
  • Deleting Items from a PivotTable 
  • Filtering Items in the Pivot Table List 
  • Using the AutoCalc Feature 
  • Displaying Subtotals 

CREATING PIVOT CHART FORMS

  • Using the Pivot Chart Auto Form Wizard 
  • Deleting Items from a PivotChart 
  • Filtering Items in the PivotChart List 
  • Changing Pivot Chart Types 

LINKING TO EXTERNAL DATA SOURCES

  • Linking to Text Files 
  • Linking to Microsoft Excel Spreadsheets 
  • Linking to HTML Files 
  • Linking to Other Access Databases 
  • Linking to a SQL Server ODBC Data Source 

IMPORTING DATA INTO ACCESS

  • Importing from Excel Files 
  • Importing from Other Access Databases 
  • Importing from ODBC Data Sources 

EXPORTING DATA FROM ACCESS

  • Exporting to Files 
  • Exporting to Access Databases 
  • Exporting to ODBC Data Sources 

USING THE EXPRESSION BUILDER

  • Using the Expression Builder in Queries 
  • Using the Expression Builder in Forms 
  • Using the Expression Builder in Reports 

USING COMMON BUILT-IN FUNCTIONS

  • Using Date/Time Functions 
  • Using Financial Functions 
  • Using Math Functions 
  • Using Text Functions 

USING THE MACRO BUILDER

  • Using the Macro Builder in Queries 
  • Using the Macro Builder in Forms 
  • Using the Macro Builder in Reports

INTRODUCTION TO VBA

  • What is VBA Programming?
  • Benefits of using Macro.
  • Recording Macro.
  • Running of Macro using an Object.
  • Editing Macro.

BASIC PROGRAMMING CONCEPT

  • Overview of different programming language
  • Operators
  • Decision making and looping
  • Functions

HOW VBA WORK WITH ACCESS

  • Working in Visual Basic Editor
  • Introducing the Access Object Model
  • VBA Sub and Function Procedures

USE VBA PROGRAMMING CONCEPT IN MACRO

  • Essential VBA Language elements
  • Working with Range objects
  • Using VBA and worksheet functions
  • Controlling program flow and making decisions; IF, If Else, Else If, Do While, Do Until Loop, Select Case
  • Automatic Procedures and Events
  • Error Handling Techniques

EXTERNAL CONNECTIVITY

  • Connecting to share point
  • Connecting to SAP
  • Connecting to web portals
  • Connecting to data base.

COMMUNICATING WITH YOUR USERS

  • Simple Dialog Boxes
  • User Form Basics
  • Designing User Form
  • Using User Form Controls
  • User Form Tricks and Techniques
  • Accessing the Macro through User Form
  • Linking one Form to another Form
  • Progress Indicator

PUTTING IT ALL TOGETHER

  • Creating worksheet functions and calling functions
  • Creating Access Add-Ins

COMPLETING THE PROJECT

  • Creating User Manuals
  • VBA Security Option
  • Delivering the project

CONTACT US

Free Courses

Duis egestas aliquet aliquet. Maecenas erat eros, fringilla et leo eget, viverra pretium nulla. Quisque sed augue tincidunt, posuere dui tempor.

Premium Courses

Duis egestas aliquet aliquet. Maecenas erat eros, fringilla et leo eget, viverra pretium nulla. Quisque sed augue tincidunt, posuere dui tempor.