Microsoft Access Course

Microsoft Access training course is targeted towards making students familiar with database management that combines relational Microsoft jet data base engine with a graphical user interface and software development tools.

It teaches students creation of quick and easy databases, produces adaptable and flexible data base system and produces very user-friendly application through its comprehensive programming language.

This course provides a clear picture with Microsoft access with hands-on to create and modify new database and their various projects. This course teaches how to handle data with consistency and accuracy. This course explains students how to import or link directly to data stored in other applications and databases.

The students must have sufficient knowledge of the basic skills of working with excel to advance excel. They must be familiar with advanced formulas, pivot Tables and other such important functions. Pupil must also have sufficient knowledge of how to validate and standardize table data.

Target Students:

All working professionals who wish to learn how to create and manage database are the most suitable person for this course. They must possess technical know-how and familiarity with excel. Pupil who wish to learn how to manage data by themselves can also enroll for this course.

MS Access Course Outline:

• Introduction to Access
• Getting familiarize with Access
• Planning, Designing, Handling Database
• Play with Database
• Creating Database and Updating using templates
• Using Pivot Table in Access (And Via Excel)
• Creating Pivot Tables Within Access
• Using Access Pivot Tables
• Using the Navigation Pane
• Tables and Related Views
• Navigation Pane Objects
• Custom Groups
• Introducing Access Macros and VBA
• Just what is a Macro?
• Macro Review
• Creating and Editing Macros
• Enhancing Macros with TempVars
• Adding Conditions to Macros
• Introducing Access VBA
• Adding Conditions to Macros
• Introducing Access VBA
• Validating and Standardising Table Data
• Setting Default Values
• Defining Field Validation
• Requiring a Field to be Completed
• Adding Date Picker to Date Fields
• Using Rich Text Formatting (Memo Fields)
• Table Validation Rules
• Advanced Form Design
• GUI Design
• Designing a Standardised User Interface Model
• Working with Form Filters
• Validating Form Data
• Cascading Combo Boxes
• Setting Table Relationships
• Locating Orphan Records
• Cascading Updates and Deletes
• Join Types
• Designing with Layout View
• A Quick Look at Layout View
• Creating a Form Using the Quick Form Tool
• Introducing Access SQL
• Commonly used SQL Keywords
• Advanced Reports
• No Data Event
• Show/Hide Report Sections based on User Selections
• Add Running Sums to Report Sections
• Add a Watermark to a Report
• Advanced Select Queries
• Using Left
• Using Mid
• Using the LEN Function
• Using IIF Functions
• Using LCASE Functions
• Using TRIM Functions
• Reporting Systems
• Reviewing Methods to Run Reports
• A Fully Featured Reporting Module
• and more