The Microsoft Suite Pro User Bundle

The Microsoft Suite Pro User Bundle

1 Review
314 Enrolled
62.5 Hours
Deal Price$35.00
Suggested Price
$654.00
94% Off
The Microsoft Suite Pro User Bundle
1 Review
$35.00$654.0094% 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
The Microsoft Suite Pro User Bundle
1 Review
$35.00$654.0094% OFF
View similar items
DescriptionInstructorImportant DetailsReviewsRelated Products

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

S
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.
BI

Ben Iordachescu

Verified Buyer

May 25, 2019
Your Cart
Your cart is empty. Continue Shopping!
Processing order...