MS Access

Microsoft Access 2010 gives you a powerful set of tools that are sophisticated enough for professional developers, yet easy for new users to learn. Create powerful database solutions that make organizing, accessing, and sharing information easier than ever. This course teaches you how to use some advanced commands to work on various progarms & manipulating queries. It also introduces students to integrating Access data with other applications such as Microsoft Office Word or Excel. It is designed for computer users who are familiar with Access and now want to explore some of the intermediate to advanced skill sets.

Overview

ADV. ACCESS

Data is everywhere. Whether you are at the grocery store, office, laboratory, classroom, or ballpark, you are awash in data: prices, schedules, performance measures, lab results, recipes, contact information, quality metrics, market indices, grades, and statistics.

Most job roles today involve some form of data management. In the case of data workers, it may be their primary job task. For some, like research scientists and accountants, data management may be a strong component of the job. And for others, such as sales clerks or those in the skilled trades, data management may consist of an incidental job responsibility such as time reporting or recording a sale. But virtually everyone is affected in some way by the need to manage data.


Course Objectives

  1. identify the components of the Microsoft Access 2010 environment.
  2. identify the components of a database.
  3. organize data in tables.
  4. view data in tables.
  5. query a database.
  6. design forms.
  7. generate reports.
  8. streamline data entry and maintain data integrity.
  9. join tables to retrieve data from unrelated tables.
  10. create flexible queries to display specified records, allow for user-determined query criteria, and modify data using queries.
  11. improve forms.
  12. customize reports to organize the displayed information and produce specific print layouts.
  13. share data between Access and other applications.
  14. How to get started
  15. Get knowledge of working with Procedures and Functions
  16. Understanding Objects
  17. Learn how to Using Expressions, Vaiables, and Intrinsic Functions
  18. Controlling Program Execution
  19. Working with Recordsets
  20. Debugging Code
  21. How to handling Errors

Prerequisites

Appropriate introductory and advanced courses plus several weeks of practice. No programming experience is required.


Adv. Access Training Duration

Regular classroom based training: 12 Weeks, 60 minutes of theory & practical session per day.

Modules

Course Content

  1. Orientation to Microsoft Access
  2. Create a Simple Access Database
  3. Get Help in Microsoft Access
  1. Modify Table Data
  2. Sort and Filter Records
  3. Create Lookups
  1. Join Data from Different Tables in a Query
  2. Sort and Filter Data in a Query
  3. Perform Calculations in a Query
  1. Create Parameter Queries
  2. Create Action Queries
  3. Create Unmatched and Duplicate Queries
  4. Summarize Data
  1. Create a Report
  2. Add Controls to a Report
  3. Enhance the Appearance of a Report
  4. Prepare a Report for Print
  1. The Access Options Dialog Box
  1. Relational Database Design
  2. Create a Table
  3. Create Table Relationships
  1. Create Query Joins
  2. Join Tables That Have No Common Fields
  3. Relate Data within a Table
  4. Work with Subdatasheets
  5. Create Subqueries
  1. Data Normalization
  2. Create a Junction Table
  3. Improve Table Structure
  1. Import Data into Access
  2. Export Data to Text File Formats
  3. Export Access Data to Excel
  4. Create a Mail Merge
  1. Organize Report Information
  2. Format Reports
  3. Include Charts in a Report
  4. Add a Calculated Field to a Report
  5. Add a Subreport to an Existing Report
  1. Adding Controls to Forms
  2. Creating Subforms
  3. Organizing Information with Tab Pages
  4. Displaying a Summary of Data in a Form
  5. Applying Conditional Formatting
  1. Field and Record Validation
  2. Form Validation
  1. Creating a Macro
  2. Restricting Records Using a Condition
  3. Validating Data Using a Macro
  4. Automating Data Entry Using a Macro
  5. Converting a Macro to VBA
  1. Linking Tables to External Data Sources
  2. Managing a Database
  3. Determining Object Dependency
  4. Documenting a Database
  5. Analyzing the Performance of a Database
  1. Preparing a Database for Multiple User Access
  2. Implementing Security
  3. Setting Passwords
  4. Converting an Access Database to an ACCDE File
  5. Packaging a Database with a Digital Signature
  1. Creating a Database Switchboard
  2. Modifying a Database Switchboard
  3. Setting Startup Options
  1. Introduction to Programming in Access
  2. Why Program in Access?
  3. Understanding the Development Environment
  4. Using Visual Basic Help
  1. Understanding Modules
  2. Creating a Standard Module
  3. Understanding Procedures
  4. Creating a Sub Procedure
  5. Calling Procedures
  6. Using the Immediate Window to Call Procedures
  7. Creating a Function Procedure
  8. Naming Procedures
  9. Organizing Code and Procedures
  10. Working with the Code Editor
  1. Understanding Classes and Objects
  2. Navigating the Access Object Hierarchy
  3. Understanding Collections
  4. Using the Object Browser
  5. Working with the Application Object
  6. Understanding the Form Object
  7. Working with Properties
  8. Using the With Statement
  9. Working with Methods
  10. Understanding the DoCmd Object
  11. Working with Events
  12. Understanding the Order of Events
  1. Understanding Expressions and Statements
  2. Declaring Variables
  3. Understanding Data Types
  4. Working with Variable Scope
  5. Working with Variable Lifetime
  6. Considering Variable Scope and Lifetime Together
  7. Using Intrinsic Functions
  8. Understanding Constants
  9. Using Intrinsic Constants
  10. Using Message Boxes
  11. Using Input Boxes
  1. Understanding Control-of-Flow Structures
  2. Working with Boolean Expressions
  3. Using the If...End If Decision Structures
  4. Using the Select Case...End Select Structure
  5. Using the For...Next Structure
  6. Using the For Each...Next Structure
  7. Using the Do...Loop Structure
  8. Guidelines for use of Branching Structures
  1. Declaring and Creating Object Variables
  2. Working with the DAO Recordset Object
  1. Understanding Errors
  2. Using Debugging Tools
  3. Setting Breakpoints
  4. Setting Break Expressions
  5. Using Break Mode during Run Mode
  6. Stepping through Code
  7. Determining the Value of Expressions
  1. Understanding Error Handling
  2. Understanding VBA's Error Trapping Options
  3. Trapping Errors with the On Error Statement
  4. Understanding the Err Object
  5. Writing an Error-Handling Routine
  6. Working with Inline Error Handling
Post an Enquiry

Post an Enquiry

Address

1/583, ECR, KOTTIVAKKAM
CHENNAI / TAMIL NADU / INDIA

E-mail

astroinfo@astrotech.in
astroeq.com@gmail.com

Contact No.

+91 9710107874
(044) 438 55 773