[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 |
[/vc_column_text][/vc_tta_section][/vc_tta_accordion][/vc_column][/vc_row]