Introductions
This one-day instructor-led course provides students with an overview of the features and functions of Microsoft Office Access 2013. This course is intended for information workers who want to learn intermediate-level Access 2013 skills. Before attending this course, students must have basic computer knowledge, basic file-management skills, basic knowledge of the Access 2013 interface and database, table, and form creation and manipulation.
Nbiz Infosol provides this course in UAE specifically in Abu Dhabi, Dubai, Ajman, RAK, Al Ain, Umm Al Quwain and other areas
Course Objectives
After completing this course, students will know how to control the types of data that can be entered in a table, extract or manipulate data by using queries, and customize forms and reports to meet their needs. They will also know how to customize and maintain an Access database and how to prepare a database that will be used by other people. Specifically, they will be able to:
- Restrict the type and amount of data in a field.
- Specify the format of data in a field.
- Restrict data by using validation rules.
- Create a simple or multi-column lookup list.
- Add controls to a form.
- Enter data in a form by using VBA.
- Create a form by using an Auto Form.
- Add a sub form to a form.
- Locate information that matches multiple criteria.
- Create a query by using a wizard or manually.
- Perform calculations by using a query.
- Update information in a table.
- Delete information from a table.
- Create a report by using a wizard or manually.
- Modify report design and content.
- Add a sub report to a report.
- Preview and print a report.
- Make favorite Access commands quickly available.
- Create custom categories.
- Assign a password to a database.
- Prevent database problems.
- Create a switchboard.
- Control the features available to database users.
- Prevent changes to database code.
- Secure a database for distribution.
Duration & Learning Level
Learning Level: Intermediate
Duration: 3 day(s)-
<<Back to schedule | |||
Training Provider | Nbiz Infosol | Course Name | |
Candidate Name * | Company Name | ||
Student Type | Student Type ID | ||
Student ID Number | Mobile # * | ||
Email* | Registration Ref | ||
Name of Course | Scheduled Dates | Venue | Registration Link |
Microsoft Access 2013 (Intermediate) | To be determined | NBIZ Infosol Abu Dhabi | Register Now »» |
Microsoft Access 2013 (Intermediate) | To be determined | NBIZ Infosol Abu Dhabi | Register Now »» |
Microsoft Access 2013 (Intermediate) | To be determined | NBIZ Infosol Abu Dhabi | Register Now »» |
Microsoft Access 2013 (Intermediate) | To be determined | NBIZ Infosol Abu Dhabi | Register Now »» |
Microsoft Access 2013 (Intermediate) | To be determined | Abu Dhabi, UAE | Register Now »» |
Microsoft Access 2013 (Intermediate) | To be determined | Chennai, India | Register Now »» |
Microsoft Access 2013 (Intermediate) | To be determined | Dubai, UAE | Register Now »» |
Microsoft Access 2013 (Intermediate) | To be determined | Manama, Bahrain | Register Now »» |
Microsoft Access 2013 (Intermediate) | To be determined | Cairo, Egypt | Register Now »» |
Microsoft Access 2013 (Intermediate) | To be determined | Jeddah, Suadi Arabia | Register Now »» |
Microsoft Access 2013 (Intermediate) | To be determined | Doha, Qatar | Register Now »» |
Microsoft Access 2013 (Intermediate) | To be determined | Dubai, UAE | Register Now »» |
Microsoft Access 2013 (Intermediate) | To be determined | Manama, Bahrain | Register Now »» |
Microsoft Access 2013 (Intermediate) | To be determined | Kuwait City, Kuwait | Register Now »» |
Microsoft Access 2013 (Intermediate) | To be determined | Beirut, Lebanon | Register Now »» |
Microsoft Access 2013 (Intermediate) | To be determined | Muscat, Oman | Register Now »» |
Microsoft Access 2013 (Intermediate) | To be determined | Jeddah, Suadi Arabia | Register Now »» |
Microsoft Access 2013 (Intermediate) | To be determined | Tehran, Iran | Register Now »» |
Microsoft Access 2013 (Intermediate) | To be determined | Baghdad, Iraq | Register Now »» |
Nbiz delivers this course in Abu Dhabi, Dubai, RAK, Ajman, Sharjah, Kuwait, Oman, Saudi, Bahrain , egypt and other places in the UAE and in the Middle East
Practical hands-on Training Experienced and Friendly Expert Trainers Interactive Training Experience
Module 1: Data Integrity
- Restricting the Type of Data in a Field
- Restricting the Amount of Data in a Field
- Specifying the Format of Data in a Field
- Restricting Data by Using Validation Rules
- Creating a Simple Lookup List
- Creating a Multi-Column Lookup List
Module 2: Custom Forms
- Adding Controls to a Form
- Entering Data in a Form by Using VBA
- Creating a Form by Using an AutoForm
- Adding a Subform to a Form
Module 3: Queries
- Locating Information That Matches Multiple Criteria
- Creating a Query by Using a Wizard
- Creating a Query Manually
- Performing Calculations by Using a Query
- Updating Information in a Table
- Deleting Information from a Table
Module 4: Reports
- Creating a Report by Using a Wizard
- Modifying Report Design
- Creating a Report Manually
- Modifying Report Content
- Adding a Sub report to a Report
- Previewing and Printing a Report
Module 5: Database Management
- Making Favorite Access Commands Quickly Available
- Creating Custom Categories
- Assigning a Password to a Database
- Preventing Database Problems
Module 6: Database Distribution
- Creating a Switchboard
- Controlling the Features Available to Database Users
- Preventing Changes to Database Code
- Securing a Database for Distribution
Upon completion of the training the participants will be provided a Certificate of Completion / Attendance.
Participants have the option to gain MOS - Microsoft Office Specialist Certification by clearing the required exam. Microsoft Office Specialist (MOS) Certification is granted to individuals who have excellent skills and expertise in using Microsoft Office applications. This is a comprehensive certification authorized by Microsoft and it validates your competency and knowledge in Microsoft Office. Details are available through this link.
1. How do I enroll/register for the training course?
To enroll or register to any training course, you can use the registration page from training page or fill the request a call back form from each course pages.
The following page will provide you a list of course and training that we are providing based on the category and from each course item you can see the course details.
URL: http://www.nbizinfosol.com/training.aspx
Another method is to fill a Request a call back form provided in each Training/Course pages.
2. What will I get along with this training?
We are providing course materials during training and completion certificate after succesful training.
3. Do I need to fill up a registration form?
Yes. you can fill the registration form avaialble in the website or you can directly call us to enroll the course.Our executives will guide you to do further steps.
4. Does the course fees include the examination fee as well?
Based upon the course you are enrolling, we will charge the exam fee . We will give you the details of course fee and exam fee anytime to clear it.
5. Do you provide any course completion certificate?
Yes. We are providing the Course completion certificate for all courses we are providing.
6. Do you provide assistance for the exam appliation process?
Yes. We will provide assistance and support to apply for any exam.
7. What is the mode of payment?
Two types of payment available:
1. Visit our office and pay direct,You are always welcome to Nbizinfosol.
2. We are providing online payment via paypal payment gateway.Based upon your request we will provide the link to access the payment page.
Participants who want to learn intermediate-level MSAccess Office Personnel Sales Professionals Regular Computer Users Supervisors and Managers
Note: The listed information (venue, schedule, duration and content) may be modified and customized as per the requirements.