Microsoft Access 2013

This is a comprehensive course on learning basic and advanced components of MS Access 2013. Along with the video tutorials there are various practice files included for better understanding of the concepts. The broad modules include Basic Database Concepts and Terminology, Creating a Database, Designing a Table, Creating Queries, Creating and Modifying Forms, Reports. We also look at the Exporting Data and Mail Merge, Create Table, Working with speciality queries, Designing Forms, reports and other applications.

98

 5h 31m | 59 Videos | 81030 Views |   All Levels

Why Comprehensive MS Access 2013 Course?

This course on Comprehensive MS Access 2013 on understanding the main components in Access. Along with the video content/tutorials that explain the concepts of working in access the training also includes the practice files so that the candidates can themselves create their databases as the trainer in the video explains. This will lead to complete understanding of how databases can be created effectively.

The course has been divided into various sub sections which are planned in a way to include complete understanding of each Microsoft Access components. The first module deals with the basic of access which deals with understanding the foundation concepts of database concepts and terminology where we would comprehend how to get started with Microsoft access 2013 and use its interface. The following videos in the course will explain how to create a Database, design a Table, create queries, create and modify forms and create as well as design reports and know how to export data from access eventually creating a mail merge.

The following core section will deal only with the advanced features of Microsoft access. This will include understanding the creation of tables using application parts, working with speciality queries, design forms in an access database, form controls and comprehend how they can be applied to make the form look better, create and design reports, group repeated information using the group, sort and total capabilities, conditional formatting and data bars, 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.

What are the Requirements for MS Access 2013 Course?

• Microsoft Access 2013 installed in your computer
• A computer with internet connection
• Basic knowledge of Access 2013

What am I going to get from this MS Access 2013 Course?

• More than 5 hours of video content
• Master the use of Microsoft Access 2013 and its components
• Understand the Access 2013 interface and its components 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

Who should take up this MS Access 2013 Course?

•  Students
• Professionals
• Anyone seeking comprehensive training in Microsoft Access 2013

Back to top ^