Microsoft Access 2013 - Advanced

This online course on MS Access 2013 will help the candidates to learn various advanced functions in Access. This course gives an in depth understanding of Access features using case studies and examples, which will enable you to gather and analyse the data in a much faster way. You would be understanding in depth about how to build relational databases, customize data according to the requirements of analysis, various speciality or action queries, ways to minimize data entry errors by building buttons in forms, applications of access, automating data using macros.

221

 2h 23m | 30 Videos | 89464 Views |   Expert

Why MS Access 2013 Course – Advanced training?

This training is specifically to understand the Advance functions in MS Access 2013 – Advanced. The course will enable you to amalgamate information to create effective databases. This Microsoft Access Tutorial will give you an advanced understanding of the many Access features that will allow you to gather and interpret data faster.

The training has been structured in different modules keeping in mind the various components of Microsoft Access. The first module of the curriculum deals with understanding the creation of tables. Here we would learn the creation of tables using Application parts. Next we would work with speciality queries wherein we would understand how to make a table query, update query, delete query, Crosstab Query, union query and statistical query.

Next section focuses on designing forms in an access database. Here we would see working with data source i.e. will see how data is linked from a query in order to prepare a form from scratch, we will learn about various form controls and see how they can be applied to make the form look better, next we will see how input boxes such as an combo box can be helpful in order to eliminate potential human errors in data entry, how specialized combo box can be used that will help us jump on the record we want to, how to build interactivity in a form using buttons, learn how to set the tab order for your form which helps in data entry, we will look at another kind of form such as the multiple form can be created and how the split form can be created.

Going ahead we will focus on creating and designing reports wherein we will prepare a report right from scratch and see how the design view helps in identifying the report structure to make freestyle changes, we will see how we could group repeated information using the group, sort and total capabilities, we are going to see how to add existing fields from other tables, how to add totals and sub totals to the report to make it easier to summarize and analyze the reports, learn how conditional formatting and data bars can be helpful in comparing and analyzing data and how to create mailing labels easily using access.

By the completion of this training course, you will have in-depth knowledge of other aspects of Access such as working with Macros which includes understanding attaching, across to objects and using data macros. Finally we will understand 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 – Advanced ?

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

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

• More than 2.5 hours of video content
• Learn advanced functions of Microsoft Access
• Build relational databases
• Customize data according to the requirements of analysis
• Learn to minimize data entry errors
• Automate data using Macros

Who should take up this MS Access 2013 Course?

• Students
• Professionals
• Anyone seeking advanced training in Access 2013

Back to top ^