WHO IS MICROSOFT ACCESS COURSE FOR?
The MS Access training is designed for individuals who are used to managing data in spreadsheets but wish to understand why and how a database will provide a better solution. The training takes the participants through the process of creating a database, from design through to data population.
WHAT WILL I LEARN?
Introduction
- Using Microsoft Access
- Overview of MS Access
- Basic Concepts
- What is a Database?
- Relational Database
- Database Objects
- Getting Started with Microsoft Access 2010
- Open a new blank database
- Create a new database from a featured template
Creating Database and Tables
- MS Access Screen
- The Access Environment
- The navigation Pane
- The Ribbon
- Designing a Database
- The Basic steps in designing a database
- Designing Tables
- Working with Tables
- Creating Calculated Field in Access
- Primary Key
- Using the Lookup wizard
- Entering a Field Description
- Assigning a Field Properties
Table Relationships
- Working with Table Relationship
- How Relationship Work?
- Setting up a relationship?
- Enforce Referential Integrity
- Types of Relationships
- Modifying an Existing Relationship
- Deleting an Existing Relationship
Microsoft Access Forms
- Forms
- Anatomy of a form
- Create Simple Form
- Control Command Buttons
- Database application Form in MS Access
Microsoft Access Queries
- Introduction
- List of Operators and their meaning in Microsoft Access Query
- Creating a Microsoft Access Query from Scratch
- Creating Query with Criteria
- Action Queries
- Update Queries
- Delete Queries
- Parameter Queries
- Crosstab query
Microsoft Access Reports
- Reports
- Creating a Report
- Creating Report Microsoft Access using Report Wizard
- Building Microsoft Access Report using “Report Design”
- Anatomy of Microsoft Access Report
- Creating Calculated Fields in a Report
- Using Conditional Formatting in Access Reports
Microsoft Access Database Application
- Database Applications
- What is a Microsoft Access Application?
- Creating an application with Database Wizard
- To create application with Database Wizards (Templates)
- Designing a Startup Form
- Password Protect Access Database (Encrypt/Decrypt)
- Using Microsoft Access
- Overview of MS Access
- Basic Concepts
- What is a Database?
- Relational Database
- Database Objects
- Getting Started with Microsoft Access 2010
- Open a new blank database
- Create a new database from a featured template
- MS Access Screen
- The Access Environment
- The navigation Pane
- The Ribbon
- Designing a Database
- The Basic steps in designing a database
- Designing Tables
- Working with Tables
- Creating Calculated Field in Access
- Primary Key
- Using the Lookup wizard
- Entering a Field Description
- Assigning a Field Properties
- Working with Table Relationship
- How Relationship Work?
- Setting up a relationship?
- Enforce Referential Integrity
- Types of Relationships
- Modifying an Existing Relationship
- Deleting an Existing Relationship
- Forms
- Anatomy of a form
- Create Simple Form
- Control Command Buttons
- Database application Form in MS Access
- Introduction
- List of Operators and their meaning in Microsoft Access Query
- Creating a Microsoft Access Query from Scratch
- Creating Query with Criteria
- Action Queries
- Update Queries
- Delete Queries
- Parameter Queries
- Crosstab query
- Reports
- Creating a Report
- Creating Report Microsoft Access using Report Wizard
- Building Microsoft Access Report using “Report Design”
- Anatomy of Microsoft Access Report
- Creating Calculated Fields in a Report
- Using Conditional Formatting in Access Reports
- Database Applications
- What is a Microsoft Access Application?
- Creating an application with Database Wizard
- To create application with Database Wizards (Templates)
- Designing a Startup Form
- Password Protect Access Database (Encrypt/Decrypt)
- Macros
- Creating a Macro in Microsoft Access
- Working with Form Properties window
- Completing the Main Menu Window
- Creating a Start-up Form “Main Menu”
- Adding a Macro to a Command Button in Access
- Overview of Printing
- Print Preview Screen
- Print Preview Ribbon
- Printing Options for Specific Objects
JOIN 1000'S OF PROFESSIONALS
Frequently Asked Questions
NADIA Training Institute has been the benchmark for professional training in the Gulf market for more than 38 years. We have built thousands of careers and developed skill sets with our world-class training courses. Whether you want to enhance your job prospects or increase your productivity at work, you will find suitable courses at NADIA.
Yes, we do offer weekend and weekday classes based on students requirements. This may be planned with our learning consultants at the time of course registration.
Upon completion of any training program, while we cannot guarantee employment, we can connect you to recruiters and job vacancies from within our network.
NADIA Training Institute supports several different payment methods including cost-free instalment payment plans. Find out more by speaking to one of our learning consultants.
For partnership and business development inquiries, please contact us at training@nadia-training.com.
Check out our Help and Support center to find quick answers to your questions.