Last updated 1/2022MP4 | Video: h264, 960x720 | Audio: AAC, 44.1 KHzLanguage: English | Size: 5.32 GB | Duration: 35h 6m
The Most Convenient Way to Boost Your Confidence And Learn MS Access Inside And Out—Quickly, No Travel or Classes. What you'll learn Essential training for Microsoft Access 2010 Essential training for Microsoft Access 2013 Advanced training for Microsoft Access 2010 Advanced training for Microsoft Access 2013 Requirements Microsoft Access 2010 and Microsoft Access 2013 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 to use Access 2010 or 2013, our Ultimate Microsoft Access Training Bundle has got you covered. Starting with the absolute basics, these courses will take you to the level of total data mastery in both editions of the program, as you work through both bners 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 can’t afford to give this a miss. This bundle includes: 35 hours of video tutorials Over 150 individual video lectures 4 quizzes with 170 test questions Certificate of completionPrintable course transcriptions to follow along and take notes Courses included with this bundle: Learn Microsoft Access 2013 Starting with the basics, our certified instructor will teach you to add and delete records to your database. Then, learn to create desktop databases and apps for multiple users before diving into importing data from other sources. Build forms to capture information online. Implement pre-designed templates that track project, employee, issue, or task details. Protect databases with permissions. Run reports that provide valuable business intelligence. And walk away with a solid grasp of how tie it all together with this Microsoft Access Training. Includes exercise files. Learn Microsoft Access 2013 - Advanced Your professional trainer will show you how to use macros, tables, forms, queries, and other tools to create a professional, working database. Follow along as you learn to create and maintain macros, then see how to effectively link to other data sources. Get helpful techniques that allow you to link, report, and package your data quickly, and find out how to split a database by splitting the frontend and backend. With this informative course, you’ll learn the skills you need to make an impact with sleek, high-perfog databases that help you do your job better. Includes exercise files. Learn Microsoft Access 2010 Discover the fundamentals of database design and construction, which 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, 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—in terms of how they look on paper and 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 "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. Note: All videos are high-definition and are therefore best viewed enlarged and with the HD setting on. Updated June 2017. Course transcripts now available. Overview Section 1: Learn Microsoft Access 2013 Bner Course Lecture 1 Acquiring Access 2013; Course Overview Lecture 2 WATCH ME: Essential Information for a Successful Training Experience Lecture 3 ME: Access 2013 Exercise Files Lecture 4 able Course Transcript Lecture 5 What's New in Access 2013 Lecture 6 Using Touch Lecture 7 Database Templates; Creating, Opening and Saving Databases Lecture 8 Workspace and Backstage View Lecture 9 Online, Offline, and Contextual Help Lecture 10 Finding Keyboard Shortcuts and Key Tips Lecture 11 Customizing the Settings and Use of Access 2013 Lecture 12 The Ribbon Lecture 13 Quick Access Toolbar Lecture 14 Customizing the Status Bar Lecture 15 Overview of the Main Features of Access Database Lecture 16 Web App Basics Lecture 17 Creating Tables - Part 1 Lecture 18 Creating Tables - Part 2 Lecture 19 Relationship between Tables - Part 1 Lecture 20 Relationships Between Tables - Part 2 Lecture 21 Inserting and Formatting Fields; Field Validation; Navigation Buttons Lecture 22 Sorting, Filtering and Finding Data Lecture 23 Entering Data; Chag the Order of Columns, Field Width and Height Lecture 24 Design View; Field Properties Lecture 25 Saving Data; Data Types, Attachments and Field Size Lecture 26 Input Masks; More on Field Properties Lecture 27 Creating Forms; Form Wizard Lecture 28 Single Forms; Insert, Delete, Modify, Sort and Filter Records Lecture 29 Layout View; Adding Existing Fields Lecture 30 Design View; Arrag Fields Lecture 31 Controls Lecture 32 Form Design Lecture 33 Query Design Lecture 34 Joins and Query Wizard Lecture 35 Query Types Lecture 36 Operators and Expressions - Part 1 Lecture 37 Operators and Expressions - Part 2 Lecture 38 Operators and Expressions - Part 3 Lecture 39 Subforms Lecture 40 Report Wizard; Previewing a Report Lecture 41 Report Design Lecture 42 Grouped and Summary Reports; Modifying a Report Lecture 43 Adding Subreports Lecture 44 Documenter; Print Properties and Options Lecture 45 Import and Append; Copy and Paste; Export Access Database Lecture 46 Database Templates and Application Parts Lecture 47 Navigation Form Lecture 48 Modal Dialogs - Part 1 Lecture 49 Modal Dialogs - Part 2 Lecture 50 Modal Dialogs - Part 3 Lecture 51 Actions; Example of VBA; Creating AutoExec Macro Lecture 52 More Access Options Lecture 53 Info Tab Lecture 54 Trust Center Lecture 55 Updates; Closing Section 2: Learn Microsoft Access 2013 Advanced Training Course Lecture 56 Prerequisites and Basic Knowledge of Access 2013 Lecture 57 WATCH ME: Essential Information for a Successful Training Experience Lecture 58 Access 2013 Advanced Exercise Files Lecture 59 Indexes and Introduction to the Movies Database Lecture 60 Basics in Working with Datasheet View Lecture 61 Controlling the Display and Advanced Sorting and Filtering in Datasheet View Lecture 62 Linking to Other Access Database Tables Lecture 63 How to Install SQL Server Express Lecture 64 Setting up a Database, Accessing MDF file, and Linking via ODBC using SQL Server Lecture 65 Reasons to Split a Database; Splitting a Database to a Front-end and a Back-end Lecture 66 Consequences of the Split; Moving a Database; Adding a Trusted Location Lecture 67 Access Options relating to Multi-user Issues; Record Locking Lecture 68 Basics of Macros and Properties of Macro Editor Lecture 69 Examples of Macros; Autoexec Lecture 70 More Autoexec Lecture 71 Macro Security Lecture 72 Customizing the Quick Access Toolbar and the Ribbon Lecture 73 Convert Macro to VBA; VBA Editor Lecture 74 Reorganizing VBA Workspace; Developing, Debugging and Running VBA Codes Lecture 75 Modules, Subs, Options Explicit, and Variables Lecture 76 Scope of Variables Lecture 77 Branch and Loop Lecture 78 Customizing Events Lecture 79 Responding to Events and Developing Error Handles Lecture 80 More on Events Lecture 81 Getting Help with Events Lecture 82 Basics of Forms: Review and Tips and Tricks Lecture 83 Advanced Features of Forms - Part 1 Lecture 84 Advanced Features of Forms - Part 2 Lecture 85 Advanced Features of Forms - Part 3 Lecture 86 Advanced Features of Forms - Part 4 Lecture 87 Basics of Queries: Review Lecture 88 Main Features and Syntax of SQL Statements Lecture 89 Use of Multiple Criteria of a Where Clause Lecture 90 How Joins Look in SQL Statements and using Query Grids Lecture 91 Update Query Lecture 92 Delete and Make Table Queries Lecture 93 Append Query Lecture 94 Protecting your Database and Codes Lecture 95 Making your Database More User-Friendly Lecture 96 Setting up an Access Web App Lecture 97 Building Basic Web Apps Lecture 98 Closing Section 3: Learn Microsoft Access 2010 Bner Course Lecture 99 Intro to Backstage View, Ribbon, Quick Access Toolbar & Options Lecture 100 READ ME: Essential Information for a Successful Training Experience Lecture 101 able Course Transcripts Lecture 102 Start/Exit, Help Features, Shortcuts, Views, Templates Lecture 103 Course Review Lecture 104 Understanding Database Components Lecture 105 Introduction to Design of a Database Lecture 106 Introduction to Building a Database Lecture 107 Creating Tables & Basic Setup of Relationships Lecture 108 Using Quick Parts to Setup New Table, Importing Spreadsheet Lecture 109 Entering Data Types into Tables Lecture 110 Chag Table Attributes, Copy, Rename, Delete Records Lecture 111 Table Structures Lecture 112 Table and Field Properties Lecture 113 Auto-Create Forms, Filtering & Searching Lecture 114 Types of Different Forms & Creating New Lecture 115 Improve Look, Style, & Feel of Forms Lecture 116 Adding Fields to Existing Form Lecture 117 Understanding and Setting Up the Expression Builder Lecture 118 Format Control on Forms/Reports Lecture 119 Sorting Single & Multiple Columns; Filter One Field Data Records Lecture 120 Sorting & Filtering Data in Form View; Find & Replace in Forms Lecture 121 Understanding Reports & Structure Lecture 122 Creating Reports; Using Print Preview to Check Report Outcome Lecture 123 Advanced Reporting; Formatting Reports Lecture 124 How to Improve Report Design, Add Existing Fields; Group/Sort Lecture 125 Select Queries; Sorting; Defined Criteria Lecture 126 Change Fields wthin Query; Specifying Criteria for Numbers/Text Lecture 127 Update Queries; Append Queries; Delete Queries Lecture 128 Inner/Outer Joins; Make Table Queries; Mail Merge Lecture 129 Securing Database and Views; New Features Section 4: Learn Microsoft Access 2010 Advanced Course Lecture 130 Introduction to Advanced Access 2010 Lecture 131 READ ME: Essential Information for a Successful Training Experience Lecture 132 able Course Transcripts Lecture 133 Working with Macros Lecture 134 AutoExec Macro Lecture 135 Database Options Lecture 136 More Database Options Lecture 137 Renaming Database Objects Lecture 138 Basics & Understanding Data Types Lecture 139 Table and Field Properties Lecture 140 Validation Rules & Text Lecture 141 Understanding & Using Keys and Indexes Lecture 142 Data Normalization Lecture 143 Types of Relationships Lecture 144 Maintaining Relationships Lecture 145 Using & Understanding Queries Lecture 146 Complex Queries Lecture 147 Creating Queries and Using Join & Sub-Queries Lecture 148 Datasheet View Lecture 149 Creating & Working with Forms Lecture 150 Using Forms to Maintain Data Lecture 151 Command Buttons Lecture 152 Command Buttons Part 2 Lecture 153 Form Features that Need VBA Code Lecture 154 Understanding When & How to Use VBA Lecture 155 More about VBA and Using It to Improve Database Lecture 156 VBA Language Structure & Making a Switchboard Lecture 157 Error Handling Lecture 158 Cleaning Up Before Distribution Lecture 159 Security Techniques Lecture 160 External Data & Importxporting Data Lecture 161 Linking to Excel & Linking to Another Database Lecture 162 Separating/Splitting Up Forms, Reports, etc from Database Lecture 163 Options for Making Changes When Database is Multi-User Lecture 164 Advanced Features for Reports Lecture 165 Advanced Features for Reports Part 2 Lecture 166 Distributing Application Anyone new to Microsoft Access 2010 or Access 2013, or upgrading from previous versions of Microsoft Access HomePage: gfxtra__The_Ultima.part1.rar.html gfxtra__The_Ultima.part2.rar.html gfxtra__The_Ultima.part3.rar.html gfxtra__The_Ultima.part4.rar.html
TO MAC USERS: If RAR password doesn't work, use this archive program:
RAR Expander 0.8.5 Beta 4 and extract password protected files without error.
TO WIN USERS: If RAR password doesn't work, use this archive program:
Latest Winrar and extract password protected files without error.