Microsoft Access 2016

MP4 | Video: 1280x720 | 61 kbps | 44 KHz | Duration: 4 Hours | 644 MB

Genre: eLearning | Language: English

A practical Microsoft Access 2016 tutorial. Learn all the essentials of working on Microsoft Access database.

Learn all the essentials of working on Microsoft Access database through this Comprehensive Microsoft Access 2016 Online Training. The Comprehensive Microsoft Access 2016 has been divided into various sub sections. The first module deals with the basic of MS Access which deals with understanding the foundation concepts of database concepts and terminology where we would comprehend how to get started with Microsoft access 2016 and use its interface. It will enable you to create a database of your own from scratch, understanding table structures and their relationships, creating queries with various criteria’s, building forms with form controls, creating reports with labels, implanting macros in buttons and all other important applications to make your database more effective and efficient. 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.

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.