The Microsoft Suite Pro User Bundle

1 Review

314 Enrolled

62.5 Hours

$35.00$654.00

94% Off

The Ultimate Microsoft Access 2013 Training

95 Lessons (19.5h)

Chapter 1: Introduction
Acquiring Access 2013; Course Overview14:31
What's New in Access 20139:26
Course Exercise Files
Chapter 2: Using Touch
Overview of Principles5:53
Chapter 3: Getting Started
Database Templates; Creating, Opening and Saving Databases11:26
Workspace and Backstage View10:31
Chapter 4: Help
Online, Offline and Contextual Help5:49
Chapter 5: Keyboard Shortcuts and Key Tips
Finding Keyboard Shortcuts and Key Tips5:57
Chapter 6: Access Options
Customizing the Settings and Use of Access 201311:23
Chapter 7: The Ribbon and Toolbars
The Ribbon11:22
Quick Access Toolbar4:48
Chapter 8: Status Bar
Customizing the Status Bar3:42
Chapter 9: Database Basics
Overview of the Main Features of Access Database16:43
Web App Basics10:42
Chapter 10: Tables
Creating Tables - Part 115:29
Creating Tables - Part 214:46
Relationship between Tables - Part 114:32
Relationship between Tables - Part 28:37
Chapter 11: Datasheet View
Inserting and Formatting Fields; Field Validation; Navigation Buttons12:19
Sorting, Filtering and Finding Data13:21
Entering Data; Changing the Order of Columns, Field Width and Height8:00
Chapter 12: Table Design
Design View; Field Properties13:36
Saving Data; Data Types, Attachments and Field Size14:06
Input Masks; More on Field Properties15:06
Chapter 13: Forms
Creating Forms; Form Wizard14:36
Single Forms; Insert, Delete, Modify, Sort and Filter Records12:35
Layout View; Adding Existing Fields15:55
Design View; Arranging Fields16:27
Controls14:06
Form Design13:25
Chapter 14: Queries
Query Design15:30
Joins and Query Wizard15:03
Query Types13:51
Operators and Expressions - Part 112:00
Operators and Expressions - Part 27:32
Operators and Expressions - Part 315:04
Subforms12:32
Chapter 15: Reports
Report Wizard; Previewing a Report9:41
Report Design13:57
Grouped and Summary Reports; Modifying a Report15:26
Adding Subreports11:40
Adding Subreports
Documenter; Print Properties and Options9:20
Chapter 17: Importing and Exporting Data
Import and Append; Copy and Paste; Export Access Database13:45
Chapter 18: Templates and Application Parts
Database Templates and Application Parts14:21
Chapter 19: More on Forms
Navigation Form10:45
Modal Dialogs - Part 111:52
Modal Dialogs - Part 213:33
Modal Dialogs - Part 39:39
Chapter 20: Macros and VBA
Actions; Example of VBA; Creating AutoExec Macro15:25
Chapter 21: Additional Topics
More Access Options8:45
Info Tab11:49
Chapter 23: Security
Trust Center12:58
Chapter 23: Conclusion
Updates; Closing2:21
Chapter 1: Introduction
Pre-requisites and Basic Knowledge of Access 20139:10
Course Exercise Files
Chapter 2: Indexes
Indexes and Introduction to the Movies Database14:36
Chapter 3: Datasheet View
Basics in Working with Datasheet View10:29
Controlling the Display and Advanced Sorting and Filtering in Datasheet View15:21
Chapter 4: Linking Access Databases
Linking to Other Access Database Tables14:41
Chapter 5: ODBC and SQL Server
How to Install SQL Server Express14:49
Setting up a Database, Accessing MDF file, and Linking via ODBC using SQL Server16:50
Chapter 6: Splitting an Access Database
Reasons to Split a Database; Splitting a Database to a Front-end and a Back-end15:18
Consequences of the Split; Moving a Database; Adding a Trusted Location16:07
Chapter 7: Multi-user Aspects
Access Options relating to Multi-user Issues; Record Locking14:58
Chapter 8: Macros
Basics of Macros and Properties of Macro Editor14:23
Examples of Macros; Autoexec14:29
More Autoexec14:43
Macro Security8:37
Chapter 9: The Ribbon
Customizing the Quick Access Toolbar and the Ribbon15:17
Chpater 10: Visual Basic for Applications
Convert Macro to VBA; VBA Editor14:13
Reorganizing VBA Workspace; Developing, Debugging and Running VBA Codes14:27
Modules, Subs, Options Explicit, and Variables15:58
Scope of Variables16:13
Branch and Loop14:38
Chapter 11: Events
Customizing Events15:08
Responding to Events and Developing Error Handles13:59
More on Events14:11
Getting Help with Events8:24
Chapter 12: Forms
Basics of Forms: Review and Tips and Tricks15:39
Advanced Features of Forms - Part 117:19
Advanced Features of Forms - Part 214:32
Advanced Features of Forms - Part 314:49
Advanced Features of Forms - Part 415:19
Chapter 13: SQL
Basics of Queries: Review13:57
Main Features and Syntax of SQL Statements15:53
Use of Multiple Criteria of a Where Clause12:55
Chapter 14: Joins
How Joins Look in SQL Statements and using Query Grids15:49
Chapter 15: Action Queries
Update Query15:42
Delete and Make Table Queries12:20
Append Query7:12
Chapter 16: Packaging your Application
Protecting your Database and Codes15:08
Making your Database More User-Friendly7:23
Chapter 17: Web Apps
Setting up an Access Web App16:33
Building Basic Web Apps16:48
Chapter 18: Conclusion
Closing0:44
Bonus Material
Access 2013 Keyboard Shortcuts

DescriptionInstructorImportant DetailsReviewsRelated Products

These 62.5 Hours Will Gear You Up to Work With Microsoft Project, Excel, & PowerPoint At a Professional Level

SimonSezItSince 2008, individuals, small businesses, and Fortune 500 companies with thousands of employees have benefited from the easy and hands-on software training offered by Simon Sez IT. With 70+ courses and 3,500+ video tutorials on a range of software programs, Simon Sez IT ensures stress-free e-learning and enhanced employee productivity – whether you’re implementing new software or a technological upgrade for your workplace. With over 225,000 Udemy students in over 180 countries, Simon Sez IT is the preferred e-learning choice for individuals and businesses everywhere.

Description

Microsoft Access 2013 is a database management system that can be optimized to capture and synthesize information with custom web apps and desktop databases. With the popularity of the new Access 2016, this bundle containing over 19 hours of instruction, is your ticket to efficiently analyzing large, complex data sets. The modern workplace requires you be able to work with information fast, and by course's end you'll be an expert in this powerful software and ready to adapt to Access 2016.

Access 95 lectures & 19.5 hours of content 24/7
Add & delete records to your database
Create desktop databases & apps for multiple users
Build forms to capture information online
Implement pre-designed templates that track project, employee, issue, or task details
Use macros, tables, forms, queries & other tools to create a professional, working database
Learn to create & maintain macros, then see how to effectively link to other data sources

Specs

Details & Requirements

Length of time users can access this course: lifetime
Access options: web streaming, mobile streaming
Certification of completion not included
Redemption deadline: redeem your code within 30 days of purchase
Experience level required: all levels

Compatibility

Internet required

Terms

Unredeemed licenses can be returned for store credit within 30 days of purchase. Once your license is redeemed, all sales are final.

1 Review

5/ 5

All reviews are from verified purchasers collected after purchase.

Ben Iordachescu

Verified Buyer

May 25, 2019

Your Cart

Your cart is empty. Continue Shopping!

Processing order...