Learn MS Access Course

[vc_row][vc_column][vc_column_text][rpt name=”ms-access-course-online-access”][/vc_column_text][vc_column_text]


[/vc_column_text][vc_empty_space height=”20px”][/vc_column][/vc_row][vc_row][vc_column][vc_column_text]

Learn MS Access Course

Apane trainer dost ko jaanie:

  • Name: Mr. Rishabh Pugalia
  • Profession: Chartered Accountant
  • Has worked for KPMG (Audit), J.P. Morgan (Investment Banking & Research), Futures First (STIR F&O)
  • 4.0 years of work experience in the area of Audit, Investment Banking & Proprietary trading
    • Program Director & Training Instructor – Advanced Excel, Advanced PowerPoint, Financial Modeling, VBA Macros
    • 7.0 years of work experience in Corporate Training, eLearning Content Development
    • Under him, He has trained more than 12,000 professionals across 14+ cities
    • Successfully completed six-weeks Analyst training program of Adkins Matchett & Toy
    • Conducted CPE seminars for Chartered Accountants – Kolkata, Mumbai, Jodhpur

[/vc_column_text][vc_empty_space height=”10px”][vc_column_text]

Course Sample Video

[/vc_column_text][vc_empty_space height=”5px”][/vc_column][/vc_row][vc_row][vc_column width=”1/3″][/vc_column][vc_column width=”1/3″][/vc_column][vc_column width=”1/3″][/vc_column][/vc_row][vc_row][vc_column][vc_tta_accordion][vc_tta_section title=”Section 1: Introduction to Access” tab_id=”1542027608575-34d0da9b-52d1″][vc_column_text]

0101 Why MS-Access
0102 Starting with MS-Access (Interface)
0103 Data Types and Purpose

[/vc_column_text][/vc_tta_section][vc_tta_section title=”Section 2: Table Object Basic” tab_id=”1542027608639-b4967005-b143″][vc_column_text]

0201 Introduction
0202 Creating a Sample Table
0203 Adding, Editing and Deleting Records
0204 Use of Autonumbers – Datasheet View
0205 Table Properties and Custom Formatting
0206 Set Field Validations
0207 Other Field Properties
0208 Import Data from Excel into a New Table
0209 Append Data From Excel into an existing table
0210 Table Sorting
0211 Table Filtering
0212 Exporting to Excel

[/vc_column_text][/vc_tta_section][vc_tta_section title=”Section 3: Query Objects: Basics” tab_id=”1542027698482-63a6af61-e627″][vc_column_text]

0301 Introduction
0302 Basic Queries
0303 Query Criteria
0304 Date Criteria
0305 Using AND in Criteria
0306 Using Or in Criteria
0307 Using AND-OR in Criteria
0308 Multiple AND and OR Example 2
0309 Parameter Queries
0310 Wild Card Operators
0311 Like and Not Like Operator
0312 And Operator
0313 Or Operator
0314 In and Not In Operator
0315 Basic Calculated field
0316 Using Date in Operators in calculation

[/vc_column_text][/vc_tta_section][vc_tta_section title=”Section 4: Report Objects: Basics” tab_id=”1542027753143-1430e4d3-ee5a”][vc_column_text]

0401 Introduction
0402 Modifying the Report
0403 Working with Controls, Report and Layout Views
0404 Report Using Parameter Query in combination

[/vc_column_text][/vc_tta_section][vc_tta_section title=”Section 5: Form Objects: Basics” tab_id=”1542027787268-abbfce19-d9d1″][vc_column_text]

0501 Introduction
0502 Creating a Form with the Form Table
0503 Creating a Form with the Wizard From Table
0504 Basic Formatting and Editing of layout

[/vc_column_text][/vc_tta_section][vc_tta_section title=”Section 6: Table Object: Advanced” tab_id=”1542027828185-55b30f72-abbb”][vc_column_text]

0601 Using the Lookup Wizard
0602 Setup Lookups Without the Wizard
0603 Lookup Wizard Example 2
0604 Advanced Sorting
0605 Advanced Filter_Filter by Form
0606 RDBMS between multiple Table 1
0607 RDBMS between multiple Table 2
0608 Printing RDBMS between multiple Tables
0609 Create Linking table in different access as backhand data

[/vc_column_text][/vc_tta_section][vc_tta_section title=”Section 7: Query Objects: Advanced” tab_id=”1542027865494-836c3216-5881″][vc_column_text]

0701 RDBMS Between tables
0702 Primary Key
0703 Join Types in RDBMS
0704 Temporary Relationship between Tables
0705 Permanent Relationship between Tables
0706 Unmatch Query Wizard
0707 Unmatch Query Using Query
0708 IIF Calculated fields
0709 Using TOP queries
0710 Using TOTAL Queries (GroupBy)
0711 Cross Tab Action Query
0712 Make Table Action Query
0713 Update Table Action Query
0714 Delete Action Query
0715 Append Table Action Query
0716 Summary of all action Query in one process
0717 RDBMS used for calculative field
0718 Yearly Report using RDBMS with Parameter query
0719 Unmatch Query Wizard
0720 Unmatch Query Design

[/vc_column_text][/vc_tta_section][vc_tta_section title=”Section 8: Report Objects: Advanced” tab_id=”1542027904019-93de5e64-6090″][vc_column_text]

0801 Using Report Wizard
0802 Grouping Options and Summary Option 1
0803 Grouping Options and Summary Option 2
0804 Grouping Options and Summary Option 3

[/vc_column_text][/vc_tta_section][vc_tta_section title=”Section 9: Form Objects: Advanced” tab_id=”1542027938133-532b4345-7d33″][vc_column_text]

0901 Add a Combo Box to Our Orders form
0902 Setting the TAB Order and Using TAB Controls
0903 Add a Subform
0904 Change a Textbox into a ComboBox
0905 Creating and Using Button Controls

[/vc_column_text][/vc_tta_section][vc_tta_section title=”Section 10: Macro” tab_id=”1542027967704-9d8ee38e-c20c”][vc_column_text]

1001 Introduction to Macro
1002 Creating Simple Macro
1003 Assigning Macro To Button
1004 Building Macro Under Event
1005 Macro to Open Report for Printing
1006 Change tab Setting of MS Access