Course Overview
5h 04m | 63 Videos | 81307 Views | 
All Levels Why Comprehensive MS Access 2010 training?
This course on Microsoft Access 2010 is a Comprehensive MS Access 2010 course on understanding the main features in Access. You would not only get great quality video content explaining concepts of working in access but also includes the practice files so that the individuals can themselves create their databases and work as the trainer in the video does.
The course has been divided into various sub modules which are structured in a way to include complete understanding of each Microsoft Access components.
The first module deals with the foundation of access which deals with understanding the basic Database Concepts and Terminology where we would understand how to get started with Microsoft access 2013. The next sections specifically deals with Creating a Database, Designing a Table, Creating Queries, Creating and Modifying Forms and creation and designing of reports and understand exporting data from access and creating a mail merge.
Next core module will purely focus on the advanced features of Microsoft access which includes creation of tables using Application parts, working with speciality queries, designing forms in an access database, we will learn about various form controls and see how they can be applied to make the form look better, creating and designing reports, group repeated information using the group, sort and total capabilities, learn how conditional formatting and data bars can be helpful, working with Macros which includes understanding attaching, across to objects and using data macros. At the end of the module we would learn publishing of Access database in HTML or XML, sharing via email, using data analysis tools, encrypting the database, and splitting the database.
MS Access 2010 Course requirements:
- Microsoft Access 2010 installed in your computer
- A computer with internet connection
- Basic knowledge of Access
What am I going to get from this MS Access 2010 course?
- More than 5 hours of video content
- Master the use of Microsoft Access 2010 and its components
- Understand the Access 2010 interface and its elements such as designing forms, usage of queries and generating reports to physically represent the databases effectively.
- Understand the basics of how databases work, the structure of the database and how tables can be used effectively
- Learn how to effectively link to other data sources
- Construct relational databases
- Modify data according to the requirements of analysis
- Learn to curtail data entry errors
- Automate data using Macros
