The Ultimate Microsoft Access 2010 and 2013 Training Bundle

BY
Udemy

Gaina hands-on experience of the basic as well as advanced concepts and methodologies associated with Microsoft Access.

Mode

Online

Fees

₹ 499 2299

Quick Facts

particular details
Medium of instructions English
Mode of learning Self study
Mode of Delivery Video and Text Based

Course overview

Data management abilities are essential in today's business, and Microsoft Access is the most readily used software for the purpose. Simon Sez IT, an e-learning company that seeks to provide low-cost training on business software such as Adobe Photoshop, Microsoft Office, and QuickBooks, has designed The Ultimate Microsoft Access 2010 and 2013 Training Bundle online certification, which is delivered through Udemy.

The Ultimate Microsoft Access 2010 and 2013 Training Bundle online course is a self-paced program designed for learners who desire to grow in their professional professions by gaining a practical understanding of the Microsoft Access 2010 and 2013 versions. The Ultimate Microsoft Access 2010 and 2013 Training Bundle online classes begin with the fundamentals of Microsoft Access and progress to more advanced topics such as maintaining relationships, error handling, data normalization, query design, form design, web app, keyword shortcut, database security, and database design.

The highlights

  • Certificate of completion
  • Self-paced course
  • 35 hours of pre-recorded video content
  • 7 articles
  • 5 downloadable resources
  • Quizzes

Program offerings

  • Online course
  • Learning resources. 30-day money-back guarantee
  • Unlimited access
  • Accessible on mobile devices and tv

Course and certificate fees

Fees information
₹ 499  ₹2,299
certificate availability

Yes

certificate providing authority

Udemy

What you will learn

After completing The Ultimate Microsoft Access 2010 and 2013 Training Bundle certification course, learners will receive a thorough understanding of the essential principles and strategies of Microsoft Access and SQL. Learners will study MS Access's numerous functions and features, including the web app, tables, keyboard shortcuts, and quick access toolbar. Learners will also learn data entry, form design, query design, database design, database security, relationship maintenance, error handling, and data normalization techniques.

The syllabus

Learn Microsoft Access 2013 Beginner Course

  • Acquiring Access 2013; Course Overview
  • WATCH ME: Essential Information for a Successful Training Experience
  • Access 2013 Exercise Files
  • What's New in Access 2013
  • Using Touch
  • Database Templates; Creating, Opening, and Saving Databases
  • Workspace and Backstage View
  • Online, Offline, and Contextual Help
  • Finding Keyboard Shortcuts and Key Tips
  • Customizing the Settings and Use of Access 2013
  • The Ribbon
  • Quick Access Toolbar
  • Customizing the Status Bar
  • Overview of the Main Features of Access Database
  • Web App Basics
  • Creating Tables - Part 1
  • Creating Tables - Part 2
  • Relationship between Tables - Part 1
  • Relationships Between Tables - Part 2
  • Inserting and Formatting Fields; Field Validation; Navigation Buttons
  • Sorting, Filtering, and Finding Data
  • Entering Data; Changing the Order of Columns, Field Width, and Height
  • Design View; Field Properties
  • Saving Data; Data Types, Attachments, and Field Size
  • Input Masks; More on Field Properties
  • Creating Forms; Form Wizard
  • Single Forms; Insert, Delete, Modify, Sort, and Filter Records
  • Layout View; Adding Existing Fields
  • Design View; Arranging Fields
  • Controls
  • Form Design
  • Query Design
  • Joins and Query Wizard
  • Query Types
  • Operators and Expressions - Part 1
  • Operators and Expressions - Part 2
  • Operators and Expressions - Part 3
  • Subforms
  • Report Wizard; Previewing a Report
  • Report Design
  • Grouped and Summary Reports; Modifying a Report
  • Adding Subreports
  • Documenter; Print Properties and Options
  • Import and Append; Copy and Paste; Export Access Database
  • Database Templates and Application Parts
  • Navigation Form
  • Modal Dialogs - Part 1
  • Modal Dialogs - Part 2
  • Modal Dialogs - Part 3
  • Actions; Example of VBA; Creating AutoExec Macro
  • More Access Options
  • Info Tab
  • Trust Center
  • Updates; Closing
  • Access 2013 Quiz

Learn Microsoft Access 2013 Advanced Training Course

  • Prerequisites and Basic Knowledge of Access 2013
  • WATCH ME: Essential Information for a Successful Training Experience
  • Access 2013 Advanced Exercise Files
  • Indexes and Introduction to the Movies Database
  • Basics in Working with Datasheet View
  • Controlling the Display and Advanced Sorting and Filtering in Datasheet View
  • Linking to Other Access Database Tables
  • How to Install SQL Server Express
  • Setting up a Database, Accessing MDF file, and Linking via ODBC using SQL Server
  • Reasons to Split a Database; Splitting a Database to a Front-end and a Back-end
  • Consequences of the Split; Moving a Database; Adding a Trusted Location
  • Access Options relating to Multi-user Issues; Record Locking
  • Basics of Macros and Properties of Macro Editor
  • Examples of Macros; Autoexec
  • More Autoexec
  • Macro Security
  • Customizing the Quick Access Toolbar and the Ribbon
  • Convert Macro to VBA; VBA Editor
  • Reorganizing VBA Workspace; Developing, Debugging and Running VBA Codes
  • Modules, Subs, Options Explicit, and Variables
  • Scope of Variables
  • Branch and Loop
  • Customizing Events
  • Responding to Events and Developing Error Handles
  • More on Events
  • Getting Help with Events
  • Basics of Forms: Review and Tips and Tricks
  • Advanced Features of Forms - Part 1
  • Advanced Features of Forms - Part 2
  • Advanced Features of Forms - Part 3
  • Advanced Features of Forms - Part 4
  • Basics of Queries: Review
  • Main Features and Syntax of SQL Statements
  • Use of Multiple Criteria of a Where Clause
  • How Joins Look in SQL Statements and using Query Grids
  • Update Query
  • Delete and Make Table Queries
  • Append Query
  • Protecting your Database and Codes
  • Making your Database More User-Friendly
  • Setting up an Access Web App
  • Building Basic Web Apps
  • Closing
  • Access 2013 Advanced Quiz

Learn Microsoft Access 2010 Beginner Course

  • Intro to Backstage View, Ribbon, Quick Access Toolbar & Options
  • READ ME: Essential Information for a Successful Training Experience
  • Downloadable Course Transcripts
  • Start/Exit, Help Features, Shortcuts, Views, Templates
  • Course Review
  • Understanding Database Components
  • Introduction to Design of a Database
  • Introduction to Building a Database
  • Creating Tables & Basic Setup of Relationships
  • Using Quick Parts to Setup New Table, Importing Spreadsheet
  • Entering Data Types into Tables
  • Changing Table Attributes, Copy, Rename, Delete Records
  • Table Structures
  • Table and Field Properties
  • Auto-Create Forms, Filtering & Searching
  • Types of Different Forms & Creating New
  • Improve Look, Style, & Feel of Forms
  • Adding Fields to Existing Form
  • Understanding and Setting Up the Expression Builder
  • Format Control on Forms/Reports
  • Sorting Single & Multiple Columns; Filter One Field Data Records
  • Sorting & Filtering Data in Form View; Find & Replace in Forms
  • Understanding Reports & Structure
  • Creating Reports; Using Print Preview to Check Report Outcome
  • Advanced Reporting; Formatting Reports
  • How to Improve Report Design, Add Existing Fields; Group/Sort
  • Select Queries; Sorting; Defined Criteria
  • Change Fields wthin Query; Specifying Criteria for Numbers/Text
  • Update Queries; Append Queries; Delete Queries
  • Inner/Outer Joins; Make Table Queries; Mail Merge
  • Securing Database and Views; New Features
  • Access 2010 Quiz

Learn Microsoft Access 2010 Advanced Course

  • Introduction to Advanced Access 2010
  • READ ME: Essential Information for a Successful Training Experience
  • Downloadable Course Transcripts
  • Working with Macros
  • AutoExec Macro
  • Database Options
  • More Database Options
  • Renaming Database Objects
  • Basics & Understanding Data Types
  • Table and Field Properties
  • Validation Rules & Text
  • Understanding & Using Keys and Indexes
  • Data Normalization
  • Types of Relationships
  • Maintaining Relationships
  • Using & Understanding Queries
  • Complex Queries
  • Creating Queries and Using Join & Sub-Queries
  • Datasheet View
  • Creating & Working with Forms
  • Using Forms to Maintain Data
  • Command Buttons
  • Command Buttons Part 2
  • Form Features that Need VBA Code
  • Understanding When & How to Use VBA
  • More about VBA and Using It to Improve Database
  • VBA Language Structure & Making a Switchboard
  • Error Handling
  • Cleaning Up Before Distribution
  • Security Techniques
  • External Data & Importng/Exporting Data
  • Linking to Excel & Linking to Another Database
  • Separating/Splitting Up Forms, Reports, etc from Database
  • Options for Making Changes When Database is Multi-User
  • Advanced Features for Reports
  • Advanced Features for Reports Part 2
  • Distributing Application
  • Access 2010 Advanced Quiz


Trending Courses

Popular Courses

Popular Platforms

Learn more about the Courses

Download the Careers360 App on your Android phone

Regular exam updates, QnA, Predictors, College Applications & E-books now on your Mobile

Careers360 App
150M+ Students
30,000+ Colleges
500+ Exams
1500+ E-books