Home »Microsoft Access - Advanced
COURSE : CERTIFIED MICROSOFT ACCESS COURSE 
Course Overview

This advanced Microsoft Access training course will build on your existing skills to teach you advanced techniques for making the most of Access’s functionality.Microsoft Access is a very popular and widely used database program enabling the user to manipulate data in a wide variety of ways. Data can be analyzed and sorted, specific information can be searched for, and the results can be used to produce reports, lists and more.In this course, you will extend your knowledge into some of the more specialized and advanced capabilities of Access by structuring existing data, writing advanced queries, working with macros, enhancing forms and reports and maintaining a database.

Training Duration Total Training Hours : 20Hours 
Training Duration : 2 Week
Total Training Days : 5 Working Days
Training Schedules Weekdays (Sunday to Thursday)
Regular Sessions : 6 Hrs Per day (9am to 2pm or 3.00pm to 9.00 pm)
Food & refreshments Included

WeekEnds (Friday & Saturday)
Fast Track Sessions: 8 Hours per day (9am to 5pm)
Food & refreshments Included
Certifications: 1) Certificate from Laurels Training Institute, Attested by Knowledge & Human Development Authority (KHDA) government of Dubai, UAE

OPTIONAL
2) Certificate from American Institute of Professional Studies (AIPS) from USA (After 15 Days of course Completion which will couriered to the attendees office address)
Tests Yes
Learning Aids Yes
Course Material Hard & Soft Copies of Study Material
Language of Instruction English
Instructor Helpline Yes 
1. Email
2. Social Media (For Emergency requirements)
Registration Requirements 1. Passport Copy
2. Curriculum Vitae
3. Passport size photographs
4. Course Fee
Mode of Payment: Cash / Cheque / Credit Card / Bank Transfer.
Eligibility Criteria
(Who should attend this training)
  • Use a mouse
  • Type and use a keyboard
  • Basic understanding of Windows
  • Navigate through Windows files and folders
  • Work with Windows - minimise, maximise, open and close
  • It is recommended that students have basic experience  with the Windows operating systema
Course Benefits
  • By the end of this Microsoft Access training course you will have a complete understanding of the higher functions of Access. Share Access data with other applications
  • Create and modify a database switchboard and set the startup options
  • Secure and distribute databases
  • Create a many to many relationship
  • Create automated forms to run reports and queries
  • Create a menu system for your database to make it more user friendly
  • Use features like command buttons and macros to automate your forms
Course Contents / Outline
1. Explore an Access 2010 Database
  • Working in Access 2010
  • Understanding Database Concepts o Exploring Tables
  • Exploring Forms
  • Exploring queries
  • Exploring Reports
  • Previewing and Printing Access Objects
2. Create Database and Simple Tables
  • Creating Databases from Templates
  • Creating Databases and Tables manually
  • Manipulating Table Columns and Rows
  • Refining Table Structure
  • Creating Relationships Between Tables
3. Create Simple Forms
  • Creating Forms by Using the Form Tool
  • Changing the Look of Forms
  • Changing the Arrangement of Forms
4. Display Data o Sorting Information in Tables
  • Filtering Information in Tables
  • Filtering Information by Using Forms
  • Locating Information That Matches Multiple Criteria
5. Create Simple Reports
  • Creating Reports by Using a Wizard
  • Modifying Report Design
  • Previewing and Printing Reports
6. Maintain Data Integrity
  • Restricting the Type of Data
  • Restricting the Amount of Data
  • Restricting the Format of Data
  • Restricting Data by Using Validating Rules
  • Restricting Data to Values in Lists
  • Restricting Data to Values in Other Tables
7. Create Custom Forms
  • Modifying Forms Created by Using a Wizard
  • Adding Controls o Adding Subforms
  • Using E-Mail forms to Collect Data
8. Create Queries
  • Creating Queries by Using a Wizard
  • Creating Queries Manually
  • Using Queries to Summarize Data
  • Using Queries to Perform Calculations
  • Using Queries to Updated Records
  • Using Queries to Delete Records
9. Create Custom Reports
  • Creating Reports Manually
  • Modifying Report Content
  • Adding Sub-reports
10. Import and Export Data
  • Importing Information
  • Exporting Information
  • Copying and from Other Office Programs
  • 11. Make Database User Friendly
  • Creating Navigation Forms
  • Creating Custom Categories
  • Controlling which Features are Available
12. Project Database
  • Assigning Passwords to Database
  • Splitting Databases
  • Securing Databases for Distribution
  • Preventing Database Problems
13. Customize Access
  • Changing Defaults Program Options
  • Customizing the Ribbon
  • Customizing the Quick Access Toolbar    
© Laurels Training Institute 2017. All Rights Reserved.