The Ultimate Microsoft Access 2010 Training Course 15 Hours

Have all the database terms, data, and reports got you down? Demystify Access forever with this effective course.
What you'll learn
Learn the Access 2010 interface including the Backstage View, Ribbon Features, and Quick Access Toolbar.
Explore the fundamentals of a database including records, fields, table objects, relationships, and primary keys.
Discover techniques for creating forms that present data in a visual way.
Understand and set-up the expression builder.
Filter data in single and multiple columns in tables and forms.
Learn how to create reports.
Discover how to improve your report design, add existing fields, and how to group and sort right on the report.
Learn how to update the database quickly using update queries, append queries, and delete queries.
Execute a set of defined actions and learn to create and modify macros.
Identify best practices for naming objects in an Access 2010 Database.
Learn to collect data from external sources.
Discover the importance of preparing an Access database for distribution and for multi-user access by separating forms.
Distinguish the difference between Word and Excel macros, and the macros and VBA programs that are a part of Access.
Learn best practices for setting-up a new database.
Using VBA for robust error handling and making a handy switchboard.
Requirements
Microsoft Access 2010
Description
In today's workplace, data management skills are absolutely crucial, and Microsoft Access is the most widely available software for the job. Whether you need beginner, intermediate or advanced level Access 2010 training, our Ultimate Microsoft Access 2010 Training Course has got you covered. Starting with the absolute basics, these informative and engaging courses will take you to the level of total data mastery in both editions of the program, as you work through both beginners and advanced courses. If you need to manage data at all in your job, or are looking for a promotion to a role where you do, then you simply can't afford to miss this training. This bundle includes: 15 hours of video tutorials Over 60 individual video lectures Optional quizzes to test what you've learned Certificate of completion Courses included with this bundle: Learn Microsoft Access 2010 Discover the fundamentals of database design and construction, as this will allow you to construct a strong relational database that makes future modifications and data analysis easier. Each chapter builds on the previous one, walking you through topics on tables and their attributes, structures, and field properties. Forms are presented to make information gathering and input a breeze. Learn data analysis using functions, formulas, expression builder, conditional formatting, sorting, filtering, and queries. Discover practical techniques for improving designs, adding existing fields, and grouping/sorting—as your instructor gives you easy to understand methods for working with reports. Learn Microsoft Access 2010 - Advanced Beyond just getting data into the database, in our Advanced level course, you will be taught to create both form and function. Discover how to create switchboards, autoexec functions, macros, creative reports, custom buttons, deep custom queries for detailed data analysis, and reports that shine—both in terms of how they look on paper as well as due to the data they provide. Additionally, you will learn best practices to employ during initial design and creation steps. These will help you minimize headaches as the database design evolves, and enable mass distribution as the amount of data and number of users increases. Where else can you find so many extra tools to help you master Access? What people are saying: "Simon Sez IT is one of the best resources if you are looking for Microsoft Office tutorials." - TopTenReviews.com "Thank you very much for an extraordinaire online tutorial of Access, it has helped me a lot and even enabled me to get a job. Now I work for an asset management bureau in Paris programming and updating databases from Bloomberg on a daily basis!" - Lisa R., France. "The instructor is easy to follow. He explains things clearly and takes his time going over it. The best part is that you can review the course as often as you want if there is something you are having a hard time grasping."- Terry J. Stigall "Easy to understand and informative. I consider myself an advanced user of MS Access, but I learned something useful in every chapter."- Kathleen Dziubek
Overview
Section 1: Getting to Know the Workspace
Lecture 1 Intro to Backstage View, Ribbon, Quick Access Toolbar & Options
Lecture 2 READ ME: Essential Information for a Successful Training Experience
Lecture 3 Start/Exit, Help Features, Shortcuts, Views, Templates
Section 2: Access Basics
Lecture 4 Understanding Database Components
Lecture 5 Introduction to Design of a Database
Lecture 6 Introduction to Building a Database
Section 3: Tables
Lecture 7 Creating Tables & Basic Setup of Relationships
Lecture 8 Using Quick Parts to Setup New Table, Importing Spreadsheet
Lecture 9 Entering Data Types into Tables
Lecture 10 Changing Table Attributes, Copy, Rename, Delete Records
Lecture 11 Table Structures
Lecture 12 Table and Field Properties
Section 4: Forms
Lecture 13 Auto-Create Forms, Filtering & Searching
Lecture 14 Types of Different Forms & Creating New
Lecture 15 Improve Look, Style, & Feel of Forms
Lecture 16 Adding Fields to Existing Form
Section 5: Expression Builder
Lecture 17 Understanding and Setting Up the Expression Builder
Section 6: Conditional Formatting
Lecture 18 Format Control on Forms/Reports
Section 7: Sorting and Filtering
Lecture 19 Sorting Single & Multiple Columns; Filter One Field Data Records
Lecture 20 Sorting & Filtering Data in Form View; Find & Replace in Forms
Section 8: Reports
Lecture 21 Course Review
Lecture 22 Understanding Reports & Structure
Lecture 23 Creating Reports; Using Print Preview to Check Report Outcome
Lecture 24 Advanced Reporting; Formatting Reports
Lecture 25 How to Improve Report Design, Add Existing Fields; Group/Sort
Section 9: Queries
Lecture 26 Select Queries; Sorting; Defined Criteria
Lecture 27 Change Fields wthin Query; Specifying Criteria for Numbers/Text
Lecture 28 Update Queries; Append Queries; Delete Queries
Lecture 29 Inner/Outer Joins; Make Table Queries; Mail Merge
Section 10: Security
Lecture 30 Securing Database and Views; New Features
Section 11: Access 2010 Quiz
Section 12: Introduction to Advanced Access 2010
Lecture 31 Introduction
Lecture 32 READ ME: Essential Information for a Successful Training Experience
Section 13: Macros
Lecture 33 Working with Macros
Lecture 34 AutoExec Macro
Section 14: Database Options Before Distribution
Lecture 35 Database Options
Lecture 36 More Database Options
Section 15: Naming
Lecture 37 Renaming Database Objects
Section 16: Tables Review of Table
Lecture 38 Basics & Understanding Data Types
Lecture 39 Table Field Properties
Lecture 40 Validation Rules & Tex
Section 17: Keys and Indexes
Lecture 41 Understanding & Using Keys and Indexes
Section 18: Normalization
Lecture 42 Data Normalization
Section 19: Relationships
Lecture 43 Types of Relationships
Lecture 44 Maintaining Relationships
Section 20: Queries
Lecture 45 Using & Understanding Queries
Lecture 46 Complex Queries
Lecture 47 Creating Queries and Using Join & Sub-Queries
Section 21: Datasheet View
Lecture 48 Datasheet View
Section 22: Forms
Lecture 49 Creating & Working with Forms
Lecture 50 Using Forms to Maintain Data
Lecture 51 Command Buttons
Lecture 52 Command Buttons Part 2
Lecture 53 Visual Basic for Applications
Section 23: Visual Basic for Applications
Lecture 54 Understanding When & How to Use VBA
Lecture 55 More about VBA and Using It to Improve Database
Lecture 56 VBA Language Structure & Making a Switchboard
Lecture 57 Error Handling
Section 24: Polishing Up
Lecture 58 Cleaning Up Before Distribution
Section 25: Security
Lecture 59 Security Techniques
Section 26: Import/Export
Lecture 60 External Data & Importng/Exporting Data
Section 27: Linking to Data
Lecture 61 Linking to Excel & Linking to Another Database
Section 28: Splitting Database
Lecture 62 Separating/Splitting Up Forms, Reports, etc from Database
Section 29: Multi-User
Lecture 63 Options for Making Changes When Database is Multi-User
Section 30: Reports
Lecture 64 Advanced Features for Reports
Lecture 65 Advanced Features for Reports part 2
Section 31: Package & Distribute
Lecture 66 Distributing Application
Section 32: Access 2010 Advanced Quiz
Anyone new to Microsoft Access or upgrading from an earlier version.
Screenshots

#