About Comprehensive Microsoft Access 2016 Training:
The Comprehensive Microsoft Access 2016 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 2016 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 Microsoft Access 2016 Traning?
Microsoft Access 2016 installed in your computer
A computer with internet connection
What am I going to get from this Microsoft Access 2016 Training?
More than 7 hours of video content
Master the use of Microsoft Access 2016 and its components
Understand the Access 2016 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 Microsoft Access 2016 Training?
Students
Professionals
Anyone seeking comprehensive training in Microsoft Access 2016
For any query call/miss call-
Mob-+918587999769
Section 1 Basic database concepts and terminology
|
1
|
Introduction to Microsoft Access
|
|
2
|
Starting Microsoft Access
|
|
3
|
What is new in Access 2016
|
|
4
|
Trusting a file
|
|
5
|
Quick access toolbar
|
|
6
|
Backstage view
|
|
7
|
Exploring the ribbons
|
|
8
|
Navigation pane
|
|
9
|
Components of a database
|
Section 2 Creating a database, designing a table
|
10
|
Planning and designing your database
|
|
11
|
Create a table in Layout View
|
|
12
|
Understanding the structure of a table
|
|
13
|
Create a table using design view
|
|
14
|
Create a table using calculated field
|
|
15
|
Field Properties
|
|
16
|
Importing data into Access
|
|
17
|
Formatting tools
|
|
18
|
Linking the tables
|
|
19
|
Linking the tables continues
|
Section 3 Creating Queries
|
20
|
Using Query wizard for Simple Queries
|
|
21
|
Using design Query
|
|
22
|
Sorting data using Queries
|
|
23
|
Building calculated fields
|
Section 4 Creating and modifying Forms
|
24
|
Create data entry forms
|
|
25
|
Create compound forms
|
|
26
|
Modifying forms in Layout and design view
|
Section 5 Creating and Designing Reports
|
27
|
Report on single table
|
|
28
|
Report on multiple table and formatting
|
|
29
|
Create reports through queries
|
Section 6 Exporting data and mail merge
|
30
|
Exporting data from Access
|
|
31
|
Creating a mail merge
|
Section 7 Working with specialty queries
|
32
|
Create tables using Application parts
|
|
33
|
Create tables using Application parts (Continues)
|
|
34
|
Make table query
|
|
35
|
Update query
|
|
36
|
Delete query
|
|
37
|
Crosstab query
|
|
38
|
Union Query
|
|
39
|
Statistical Query
|
Section 8 Designing Forms
|
40
|
Data source
|
|
41
|
Form Controls
|
|
42
|
Input Boxes
|
|
43
|
Record Navigation
|
|
44
|
Adding Buttons
|
|
45
|
Setting the tab order
|
|
46
|
Multiple forms
|
|
47
|
Split forms
|
Section 9 Creating and designing reports
|
48
|
Report structure in design view
|
|
49
|
Adding group
|
|
50
|
Adding fields from other tables
|
|
51
|
Adding totals and sub totals
|
|
52
|
Conditional formatting and data bars
|
|
53
|
Create mailing labels
|
Section 10 Working with Macros
|
54
|
Creating a Macro
|
|
55
|
Attaching macros to objects
|
|
56
|
Using data macros
|
Section 11 Other applications in Access
|
57
|
Publishing in HTML or XML
|
|
58
|
Sharing via email
|
|
59
|
Using data analysis tools
|
|
60
|
Encrypting the database
|
|
61
|
Splitting the database
|
|
62
|
Conclusion
|
