Microsoft Access Masterclass

Microsoft Access Masterclass Training provides complete knowledge about the basic to the advanced features of Access. The training also provides knowledge about the Relational Databases and how to import and export data. Throughout the training the delegates will get to know how to build a database with a good relational structure, write queries to generate useful reports and create forms to enter data.

The training provides knowledge about the structure and advantages of a database. The course enables the delegates to create complex queries, make forms and build a database with a good relational structure. The delegates will understand how to create basic to advanced reports and design Access databases.

Getting Started with Access

• Orientation to Microsoft Access
• Create a Simple Access Database
• Get Help and Configure Options in Microsoft Access

Fundamentals of MS Access

• Basic queries
• Purpose and users of database
• Output type
• Methods for designing Database
• Top-Down
• Bottom-Up
• Collect Information
• Data mapping
• Sample data map
• Normalisation
• 1stNF
• 2ndNF
• 3rdNF
• Naming Conventions
• Table Relationships
• Different types of relationships
• Normalisation of Data

Introduction to User Interface

• Access Ribbon
• Quick Access Toolbar
• Object Navigation Pane
• Work Surface
• Access Options Dialog Box
• Create a database using Wizard

Generate Reports

• Build a report
• Add controls to a report
• Improve an appearance of a report
• Preparing a report for print
• Organise report information
• Format reports

Handling Queries

• Building simple queries
• Learn Dynaset
• Enter criteria: exact match and range operators
• Understand difference between AND versus OR
• Use of wildcards
• Learn about use of keywords
• Sort and hide fields
• Create multi-table queries
• Additional tips

Tables

• Creating an access database
• Create a new database
• Different data types
• Determine data types
• Create a table in design view

Advanced Query Techniques

• Create query join
• Create Find Unmatched and Find Duplicate Queries
• Create Parameter Queries
• Use Like keyword in Parameter Queries
• Create a top X query
• Review calculated query fields
• Summarise query data with totals
• Insert WHERE statements in Summary queries
• Create a crosstab query Form Wizard

Forms

• Introduction to Forms
• Alter a form
• Add data records in form view
• Form record navigation
• View of layout
• Designing of a view
• One-Click Forms

Maintain a Database

• Backup a Database
• Recover a Database
• Compact a Database
• Repair a Database
• Save a Database as a Template
• Encrypt a Database
• Configure Database Options
• Set a Form as The Startup Form
• Use Database Tools

Share Data with other Applications

• Export table and queries to excel
• Import data from .txt file
• Import data from excel
• Export data to a .txt file
• Link external sources
• Use of word merge