Quality Seal Emagister EMAGISTER CUM LAUDE

Microsoft® Office 2010 Access

simplilearn
Online

Price on request
You can also call the Study Centre
81510... More
Compare this course with other similar courses
See all

Important information

  • Course
  • Online
Description

Simplilearn is the World’s Largest Certification Training Provider, with over 400,000+ professionals trained globally
Trusted by the Fortune 500 companies as their learning provider for career growth and training
2000+ certified and experienced trainers conduct trainings for various courses across the globe
All our Courses are designed and developed under a tried and tested Unique Learning Framework that is proven to deliver 98.6% pass rate in first attempt.

Important information

Opinions

There are no opinions on this course yet

What you'll learn on the course

Access
Office IT

Course programme

Course Preview
  • Microsoft® Access 2010
    • Lesson 0.0 - Course Overview11:30
      • 1 Lesson 0-Course Overview1:24
      • 2 Key Features1:12
      • 3 Objectives1:27
      • 4 About the Course1:44
      • 5 About the Course (contd.)1:48
      • 6 Value of Microsoft® Access 2010 for Professionals1:32
      • 7 Value of Microsoft® Access 2010 for Organizations1:36
      • 8 Lessons Covered1:37
      • 9 Exam Question Types0:0
      • 10 Microsoft® Access 2010 Certification1:45
      • 11 Sources of Information0:0
      • 12 Conclusion1:10
    • Lesson 1.0 - Introduction To Microsoft Access 20102:26
      • 1 Introduction to Microsoft® Access 20101:14
      • 2 Objectives1:29
    • Lesson 1.1 - Topic 1-Introduction to Database and Database Systems8:26
      • 1 Topic 1-Introduction to Database and Database Systems1:22
      • 2 What Is a Database1:48
      • 3 Types of Database Systems2:20
      • 4 Relational Database Management System2:13
    • Lesson 1.2 - Topic 2-Basic Features of MS Access 20108:2
      • 1 Topic 2-Basic Features of MS Access 20101:12
      • 2 Access 20101:37
      • 3 New Features of Access 20102:7
      • 4 New Features of-Access 2010 (contd.)2:7
      • 5 Obtaining MS Access 20101:28
    • Lesson 1.3 - Topic 3-Running Access and Using Database Files13:36
      • 1 Topic 3-Running Access and Using Database Files1:5
      • 2 Running MS Access 20101:53
      • 3 Access Database Files2:4
      • 4 Demo 1-Running Access and Creating a New Database2:4
      • 5 Demo 1-Running Access and Creating a New Database (contd.)2:4
      • 6 Demo 2-Opening Access and Database2:4
      • 7 Demo 2-Opening Access and Database (contd.)2:4
    • Lesson 1.4 - Topic 4-Working with Access 201012:16
      • 1 Topic 4-Working with Access 20101:8
      • 2 Access 2010 User Interface1:34
      • 3 The Ribbon2:9
      • 4 Quick Access Toolbar1:36
      • 5 Navigation Pane1:47
      • 6 Notification Band1:48
      • 7 Work Area1:32
      • 8 Demo 3-Working with the Access Interface1:32
      • 9 Demo 3-Working with the Access Interface (contd.)1:32
    • Lesson 1.5 - Topic 5-Setting Access Options9:46
      • 1 Topic 5-Setting Access Options1:7
      • 2 Access Options2:6
      • 3 Access Options (contd.)1:55
      • 4 Demo 4-Setting Access 2010 Options1:43
      • 5 Demo 4-Setting Access 2010 Options (contd.)1:43
      • 5 Quiz0:0
      • 6 Summary1:43
      • 7 Conclusion1:6
    • Lesson 2.0 - Working with Tables2:30
      • 1 Working with Tables1:14
      • 2 Objectives1:31
    • Lesson 2.1 - Topic 1-Understanding Tables7:40
      • 1 Topic 1-Understanding Tables1:10
      • 2 Tables1:41
      • 3 Tables (contd.)1:35
      • 4 Columns1:0
      • 5 Rows1:54
    • Lesson 2.2 - Topic 2-Managing Tables14:52
      • 1 Topic 2-Managing Tables1:9
      • 2 Table Creation1:38
      • 3 Datasheet View2:4
      • 4 Design View1:34
      • 5 Saving and Viewing Tables1:41
      • 6 Demo 1-Creating and Managing Tables1:46
      • 7 Demo 1-Creating and Managing Tables (contd.)1:46
      • 8 Entering Data1:46
      • 9 Demo 2-Data Entry in Tables1:46
      • 10 Demo 2-Data Entry in Tables (contd.)1:46
    • Lesson 2.3 - Topic 3-Creating Using Templates9:4
      • 1 Topic 3-Creating Using Templates1:11
      • 2 Templates1:53
      • 3 Backstage Templates2:7
      • 4 Application Parts1:37
      • 5 Demo 3-Using Table Templates1:37
      • 6 Demo 3-Using Table Templates (contd.)1:37
    • Lesson 2.4 - Topic 4-Compacting and Repairing Databases10:20
      • 1 Topic 4-Compacting and Repairing Databases1:15
      • 2 Database Growth2:6
      • 3 Compact and Repair1:52
      • 4 Demo 4-Compact and Repair1:52
      • 5 Demo 4-Compact and Repair (contd.)1:52
      • 6 Quiz0:0
      • 7 Summary1:37
      • 8 Conclusion1:6
    • Lesson 3.0 - Working with Fields2:22
      • 1 Lesson 3-Working with Fields1:19
      • 2 Objectives1:22
    • Lesson 3.1 - Topic 1-Introduction to Fields18:16
      • 1 Topic 1-Introduction to Fields1:11
      • 2 Fields1:37
      • 3 Data Types1:34
      • 4 Data Types (contd.)2:34
      • 5 Field Properties1:44
      • 6 Common Field Properties1:50
      • 7 Specific Field Properties1:36
      • 8 Demo 1-Adding and Managing Fields1:6
      • 9 Demo 1-Adding and Managing Fields (contd.)4:26
    • Lesson 3.2 - Topic 2-Data Validation25:18
      • 1 Topic 2-Data Validation1:12
      • 2 Lookup Field2:7
      • 3 Demo 2-Using Lookup Fields1:9
      • 4 Demo 2-Using Lookup Fields (contd.)3:33
      • 5 Input Masks2:17
      • 6 Demo 3-Using Input Masks1:6
      • 7 Demo 3-Using Input Masks (contd.)3:49
      • 8 Validation Rules and Texts2:11
      • 9 Demo 4-Adding Validation Rules1:6
      • 10 Demo 4-Adding Validation Rules (contd.)3:39
    • Lesson 3.3 - Topic 3-Keys and Relationships20:2
      • 1 Topic 3-Keys and Relationships1:37
      • 2 Keys1:28
      • 3 Primary Key1:55
      • 4 Foreign Key2:6
      • 5 Foreign Keys-Referential Integrity1:34
      • 6 Relationships1:18
      • 7 One-to-One Relationship0:0
      • 8 One-to-Many Relationship1:31
      • 9 Many-to-Many Relationship1:31
      • 10 Demo 5-Adding Keys and Defining Relationships1:11
      • 11 Demo 5-Adding Keys and Defining Relationships (contd.)5:20
    • Lesson 3.4 - Topic 4-Sorting and Filtering8:40
      • 1 Topic 4-Sorting and Filtering1:13
      • 2 Sorting1:47
      • 3 Ways of Sorting1:24
      • 4 Filtering1:49
      • 5 Advanced Filtering Options1:41
      • 6 Demo 6-Sorting and Filtering data1:6
      • 7 Demo 6-Sorting and Filtering data (contd.)0:0
      • 8 Quiz0:0
      • 9 Summary1:43
      • 10 Conclusion1:7
    • Lesson 4.0 - Working with Queries2:46
      • 1 Lesson 4-Working with Queries1:16
      • 2 objectives1:37
    • Lesson 4.1 - Topic 1-Queries in MS Access19:38
      • 1 Topic 1-Queries in MS Access1:16
      • 2 Query1:47
      • 3 Types of Queries2:52
      • 4 Using the Simple Query Wizard1:54
      • 5 Demo 1-The Simple Query Wizard1:9
      • 6 Demo 1-The Simple Query Wizard (contd.)2:11
      • 7 Design View1:31
      • 8 Demo 2-Using the Design View1:7
      • 9 Demo 2-Using the Design View (contd.)2:15
      • 10 Viewing Results1:34
      • 11 Multiple Table Queries1:50
      • 12 Demo 3-Querying from Multiple Tables1:6
      • 13 Demo 3-Querying from Multiple Tables (contd.)1:47
    • Lesson 4.2 - Topic 2-Calculated Fields, Parameter Queries, and Summary Queries20:2
      • 1 Topic 2-Using Calculated Fields, Parameter Queries, and Summary Queries1:25
      • 2 Calculated Fields2:17
      • 3 Demo 4-Creating a Calculated Field1:5
      • 4 Demo 4-Creating a Calculated Field (contd.)2:2
      • 5 Parameter Queries2:10
      • 6 Demo 5-Creating Parameter Queries1:6
      • 7 Demo 5-Creating Parameter Queries (contd.)1:53
      • 8 Expression Builder1:53
      • 9 Demo 6-Using the Expression Builder1:6
      • 10 Demo 6-Using the Expression Builder (contd.)2:26
      • 11 Summary Queries1:52
      • 12 Demo 7-Using Summary Queries1:5
      • 13 Demo 7-Using Summary Queries (contd.)2:11
    • Lesson 4.3 - Topic 3-Perform Actions on Data with Queries15:52
      • 1 Perform Actions on Data with Queries1:16
      • 2 Action Queries2:19
      • 3 Update and Delete Queries2:10
      • 4 Make Table and Append Queries1:49
      • 5 Demo 8 - Using Action Queries1:7
      • 6 Demo 8-Using Action Queries3:56
      • 7 Quiz0:0
      • 8 Summary1:41
      • 9 Conclusion1:8
    • Lesson 5.0 - Creating and Using Forms2:26
      • 1 Creating and Using Forms1:16
      • 2 Objectives1:27
    • Lesson 5.1 - Topic 1-Introduction to Forms5:24
      • 1 Topic 1-Introduction to Forms1:9
      • 2 Forms1:46
      • 3 Ways to Create Forms2:17
    • Lesson 5.2 - Topic 2-Auto Forms and Form Wizard14:8
      • 1 Topic 2-Auto Forms and Form Wizard1:12
      • 2 Auto Forms1:50
      • 3 Auto Forms-Additional Features1:0
      • 4 Demo 1-Creating an Auto Form from a Table1:5
      • 5 Demo 1-Creating an Auto Form from a Table (contd.)2:2
      • 6 Form Wizard1:50
      • 7 Layouts of Form Wizard1:56
      • 8 Demo 2-Using the Forms Wizard1:5
      • 9 Demo 2-Using the Forms Wizard (contd.)2:34
    • Lesson 5.3 - Topic 3-Working with Templates19:8
      • 1 Topic 3-Working with Templates1:16
      • 2 Types of Form Templates1:44
      • 3 Quick Start Templates1:50
      • 4 Demo 3-Using Quick Start1:8
      • 5 Demo 3-Using Quick Start (contd.)2:39
      • 6 More Form Templates1:56
      • 7 Demo 4-Using More Form Templates1:10
      • 8 Demo 4-Using More Form Templates (contd.)2:44
      • 9 Navigation Form Templates1:47
      • 10 Demo 5-Using a Navigation Form1:9
      • 11 Demo 5-Using a Navigation Form (contd.)2:41
    • Lesson 5.4 - Topic 4-Manually Creating a Form9:46
      • 1 Topic 4-Manually Creating a Form1:14
      • 2 Layout and Design1:41
      • 3 Layout View1:42
      • 4 Design View1:32
      • 5 Demo 6-Manual Creation and Designing of a Form1:8
      • 6 Demo 6-Manual Creation and Designing of a Form (contd.)3:6
    • Lesson 5.5 - Topic 5-Form Elements and Formatting12:58
      • 1 Topic 5-Form Elements and Formatting1:12
      • 2 Elements1:22
      • 3 Control Properties2:10
      • 4 Layout and Formatting1:55
      • 5 Demo 7-Arranging and Formatting a Form1:6
      • 6 Demo 7-Arranging and Formatting a Form (contd.)3:9
      • 7 Quiz0:0
      • 8 Summary1:34
      • 9 Summary (contd.)1:24
      • 10 Conclusion1:7
    • Lesson 6.0 - Advanced Form Capabilities2:24
      • 1 Lesson 6-Advanced Form Capabilities1:16
      • 2 Objectives1:26
    • Lesson 6.1 - Advanced Controls21:46
      • 1 Topic 1-Advanced Controls1:15
      • 2 List Box and Combo Box1:59
      • 3 Inserting List Box and Combo Box2:8
      • 4 Demo 1-Combo Box Control1:5
      • 5 Demo 1-Combo Box Control (contd.)2:24
      • 6 Command Buttons2:28
      • 7 Demo 2-Using the Button Control1:6
      • 8 Demo 2-Using the Button Control (contd.)3:5
      • 9 Tab Order2:37
      • 10 Demo 3-Changing the Tab Order1:5
      • 11 Demo 3-Changing the Tab Order (contd.)2:11
    • Lesson 6.2 - Linked Forms and Subforms20:10
      • 1 Topic 2-Linked Forms and Subforms1:17
      • 2 Linked Form2:9
      • 3 Demo 4-Creating a Linked Form1:5
      • 4 Demo 4-Creating a Linked Form(contd.)3:36
      • 5 Subform2:11
      • 6 Demo 5-Creating a Subform1:5
      • 7 Demo 5-Creating a Subform(contd.)4:17
      • 8 Quiz0:0
      • 9 Summary1:48
      • 10 Conclusion1:7
    • Lesson 7.0 - Building Reports2:16
      • 1 Building Reports1:15
      • 2 Objectives1:23
    • Lesson 7.1 - Introduction to Reports8:44
      • 1 Topic 1-Introduction to Reports1:10
      • 2 Reports1:52
      • 3 Views for Reports1:40
      • 4 Sections on Reports2:6
      • 5 Page Setup2:4
    • Lesson 7.2 - Creating Reports19:54
      • 1 Topic 2-Creating Reports1:8
      • 2 Create Reports1:44
      • 3 Auto Report1:41
      • 4 Demo 1-Using Auto Report1:9
      • 5 Demo 1-Using Auto Report (contd.)2:14
      • 6 Report Wizard2:19
      • 7 Demo 2-Using the Report Wizard1:5
      • 8 Demo 2-Using the Report Wizard (contd.)3:20
      • 9 Labels2:13
      • 10 Demo 3-Creating Labels1:7
      • 11 Demo 3-Creating Labels (contd.)2:27
    • Lesson 7.3 - Working with Layout and Design View17:26
      • 1 Topic 3-Working with Layout and Design Views1:14
      • 2 Layout View1:48
      • 3 Demo 4-Using Layout View1:5
      • 4 Demo 4-Using Layout View (contd.)3:54
      • 5 Design View1:39
      • 6 Demo 5-Using Design View1:5
      • 7 Demo 5-Using Design View (contd.)3:40
      • 8 Quiz0:0
      • 9 Summary1:42
      • 10 Conclusion1:6
    • Lesson 8.0 - Advanced Reports2:26
      • 1 Advanced Reports1:17
      • 2 Objectives1:26
    • Lesson 8.1 - Report Export12:48
      • 1 Topic 1-Report Export1:12
      • 2 Exporting Reports2:6
      • 3 Way to Export Reports1:39
      • 4 Automate Exports2:8
      • 5 Demo 1-Exporting a Report1:8
      • 6 Demo 1-Exporting a Report (contd.)3:41
    • Lesson 8.2 - Charts in Reports12:54
      • 1 Topic 2-Charts in Reports1:13
      • 2 Chart Options1:39
      • 3 Chart Options (contd.)2:32
      • 4 Demo 2-Using the Chart Wizard1:6
      • 5 Demo 2-Using the Chart Wizard (contd.)2:51
      • 6 Demo 3-Customizing the chart1:7
      • 7 Demo 3-Customizing the chart (contd.)2:29
    • Lesson 8.3 - Creating Pivot Tables and Charts6:32
      • 1 Topic 3-Creating Pivot Tables and Charts1:12
      • 2 Pivot Tables and Charts1:37
      • 3 Demo 4-Creating a Pivot Table and Chart1:6
      • 4 Demo 4-Creating a Pivot Table and Chart (contd.)2:51
    • Lesson 8.4 - Conditional Formatting12:40
      • 1 Conditional Formatting1:12
      • 2 Using Rules to Format1:46
      • 3 Conditions to Set Rules1:34
      • 4 Adding Data Bars1:32
      • 5 Demo 5-Using Conditional Formatting1:9
      • 6 Demo 5-Using Conditional Formatting (contd.)4:37
    • Lesson 8.5 - Using Subreports8:18
      • 1 Topic 5-Using Subreports1:11
      • 2 Subreports1:47
      • 3 Adding Subreports1:41
      • 4 Demo 6-Creating a SubReports1:6
      • 5 Demo 6-Creating a SubReports (contd.)2:2
      • 6 Quiz0:0
      • 7 Summary1:44
      • 8 Thank you1:8

Additional information

  • What is this course about?

    Microsoft Access is an information management tool that helps you store information for reference, reporting, and analysis.  Simplilearn’s Microsoft Office 2010 Access Training helps you to analyze large amounts of information, and manage related data more efficiently than any other spreadsheet application.


Compare this course with other similar courses
See all