Microsoft Access

CloudLabs

Projects

Assignment

24x7 Support

Lifetime Access

.

Course Overview

Microsoft Access, also known as Microsoft Office Access, is a database management system from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software-development tools. Microsoft Access is a very powerful database application designed to save you time and make creating relational databases easier

At the end of the training, participants will be able to:

Pre-requisite

All attendees should have a basic knowledge of data base.

Duarion

5 days

Course Outline

  1. Introduction to Databases
  2. What’s New in Access 2010
  3. Understanding the Access Program Screen
  4. Working with Database Objects
  5. Tour of a Table
  6. Adding, Editing, and Deleting Records
  7. Tour of a Form
  8. Tour of a Query
  9. Tour of a Report
  10. Selecting Data
  11. Using the Zoom Box
  1. Planning a Database
  2. Creating a New Database
  3. Creating a Table
  4. Modifying a Table
  5. Creating a Query
  6. Sorting a Query
  7. Using AND and OR Operators in a Query
  8. Creating a Form with the Form Wizard
  9. Creating a Report with the Report Wizard
  10. Creating Mailing Labels with the Label Wizard
  11. Converting an Access Database
  1. Finding and Replacing Data
  2. Sorting Records
  3. Using Common Filters
  4. Filtering by Selection
  5. Filtering by Form
  6. Creating an Advanced Filters
  7. Adjusting and Rearranging Rows and Columns
  8. Changing Gridline and Cell Effects
  9. Changing the Datasheet Font
  10. Freezing a Column
  11. Hiding a Column
  1. Understanding Field Properties
  2. Indexing a Field
  3. Adding a Primary Key to a Table
  4. Inserting, Deleting, and Reordering Fields
  5. Adding Field Descriptions and Captions
  6. Changing the Field Size
  7. Formatting Number, Currency, and Date/Time Fields
  8. Formatting Number, Currency, and Date/Time Fields by Hand
  9. Formatting Text Fields
  10. Setting a Default Value
  11. Requiring Data Entry
  12. Validating Data
  13. Creating an Input Mask
  14. Creating a Lookup Field
  15. Creating a Value List
  16. Modifying a Lookup List
  1. Understanding Table Relationships
  2. Creating Relationships Between Tables
  3. Enforcing Referential Integrity
  4. Printing and Deleting Relationships
  5. Understanding Relationship Types
  1. Understanding Different Types of Queries
  2. Creating a Multiple Table Query
  3. Creating a Calculated Field
  4. Working with Expressions and the Expression Builder
  5. Using an IF Function
  6. Summarizing Groups of Records
  7. Display Top or Bottom Values
  8. Parameter Queries
  9. Finding Duplicate Records
  10. Finding Unmatched Records
  11. Crosstab Queries
  12. Delete Queries
  13. Append Queries
  14. Make-Table Queries
  15. Update Queries
  1. Creating and Using a Form
  2. Understanding Form Views
  3. Modifying a Form in Layout View
  4. Form Design View Basics
  5. Changing Tab Order
  6. Working with Control Properties
  7. Control Property Reference
  8. Working with Form Properties
  9. Form Property Reference
  10. Changing a Control’s Data Source
  11. Creating a Calculated Control
  12. Changing a Control’s Default Value
  13. Creating a Subform
  14. Modifying and Working with Subforms
  1. Creating a Report
  2. Working in Layout View
  3. Adding a Logo
  4. Working in Design View
  5. Adjusting Page Margins and Orientation
  6. Adding Page Numbers and Dates
  7. Grouping and Sorting
  8. Summarize Data using Totals
  9. Understanding Report Sections
  1. Using Conditional Formatting
  2. Working with Number Formatting
  3. Using Themes
  4. Importing Information
  5. Exporting Information
  6. Displaying Database Object Dependencies
  7. Compacting and Repairing a Database

Reviews