Microsoft Access 2016 Introduction training covers database concepts. In this training, delegates will understand how to design, build databases and tables, make forms and reports and apply the query to the tables to fetch results. Delegates will understand about how to create MS Access database, save it, then open it. We will demonstrate you simple ways to use Microsoft's powerful online help so that delegates can solve an issue related to the database.
This course will also cover skills one needed to personalise Access to achieve the tasks you want. Delegates will learn about concepts such as Ribbons and Toolbars that make MS Access tremendously flexible. Most of the today’s job roles involve some kind of data management. In the case of data workers, it may be their primary job task. For, e.g., such as data scientists and accountants, data management may be a strong factor of the job. This Course is useful for users such as sales clerks or those users who are in the skilled trades. It is an important fact of today’s world that virtually we all are affected in some way by the need to manage data.
Create tables and relationships
Navigate the MS Access 2016 interface
Learn essential new skills for complex data projects
Find out how to into import data from Excel into your database
Create, save and open the Microsoft Access 2016 database
Handle index fields
How to use backup and repair database
There is no prerequisite for this course.
What Will You Learn
In this introductory part of MS Access 2016 course, Delegates will be awared of various database concepts, terminologies and components. Delegates will explore the user interface of MS Access, build a basic database, create tables, reports, forms and make use of queries to get results, perform calculations with dates, fields, and numbers, navigate and work with tables and the several data types. It will also teach about working with select queries, review and work with numerous reports and reporting features of this application of Microsoft, and review data entry forms and the many tools that go along with them.
This course will give the delegates the essential knowledge to complete the Microsoft Access 2016 Intermediate course. At the starting of the course, the basics of database concepts and structure, and learn to build and customise tables to store data. Delegates will learn about relational databases, and see how you can use them to create forms, generation of reports, and searching for data with queries across a large number of records in many tables just a few clicks of our mouse. Delegates will also learn how to make use of macros to automate cyclic tasks and boost your efficiency.
Getting Started with Access User Interface
Query a Database
Microsoft Access 2016 Introduction Enquiry
Maven Training provides top-notch training at different venues across the world. We offer nearly 200 courses at 1000+ locations. Our learning programs are the blend of thorough understanding and application of skills.View All Locations