Advanced Microsoft Access 2013 Training Video
4.8 (88 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,005 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Advanced Microsoft Access 2013 Training Video to your Wishlist.

Add to Wishlist

Advanced Microsoft Access 2013 Training Video

Take your Microsoft Access skills to the next level with this Advanced Access Course from Infinite Skills
4.8 (88 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,005 students enrolled
Created by Infinite Skills
Last updated 1/2017
English
Current price: $10 Original price: $50 Discount: 80% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 10 hours on-demand video
  • 1 Article
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Take your Microsoft Access 2013 skills to the next level
View Curriculum
Requirements
  • Microsoft Access 2013
Description

This Advanced Microsoft Access 2013 training course from Infinite Skills will take you beyond the fundamentals of this powerful Microsoft program. This course is designed for users that already have a basic working knowledge of Microsoft Access.


In this video tutorial, you will jump right into learning advanced table design with indexing and input masks. You will learn how to create advanced queries and action, and how to use SQL (standard query language). Guy will cover topics such as advanced form design, how to create an advanced report, and creating and using bound and unbound subforms. This video based training course will teach you how to create and use a Macro, a Sub Macro, and how to configure a Macro. Guy will show you how to turn a database into an application, and how to back up a database and convert Access databases to and from previous versions. Finally, you will learn how to create a custom web app and how to use Access with external applications.

By the conclusion of this computer based training course, you will be fully capable of creating, managing, and displaying your Microsoft Access 2013 data, and have an in-depth understanding of the many tools and techniques available to you in this Microsoft program. Working files are included, allowing you to follow along with the author throughout the lessons.

Who is the target audience?
  • Users with a basic understanding of Microsoft Access
Students Who Viewed This Course Also Viewed
Curriculum For This Course
99 Lectures
09:56:55
+
Access Advanced Introduction
4 Lectures 13:15
+
Advanced Table Design
5 Lectures 34:36
0201 Create And Use Input Masks
09:02

0202 Indexing In Access Tables
06:55

0203 Multiple Field Primary Keys
04:43

0204 Extended Field Properties
05:39

0205 Analyze A Table For Improved Performance
08:17
+
Advanced Querying
8 Lectures 48:56
0301 Selecting Unique And Distinct Values
03:51

0302 Parameter Queries
06:19

0303 Adding A Formula Field
07:55

0304 Using If Conditions Within A Formula Field
07:13

0305 Altering Join Types Between Tables
05:28

0306 Cross Tab With The Wizards Help
04:30

0307 Cross Tab Without Wizards
07:51

0308 Introducing The Expression Builder
05:49
+
Action Queries
7 Lectures 43:57
0401 Change Data In Tables With An Action Query
08:47

0402 Adding A Parameter To Update Queries
06:22

0403 Make A New Table From An Existing Table Query
04:20

0404 Make A Single Table From Multiple Table Data
04:30

0405 Amending And Appending Imported Data
06:54

0406 Deleting Records With The Delete Query
05:37

0407 Backup And Restore By Use Of Action Queries
07:27
+
Standard Query Language
8 Lectures 44:45
0501 SQL Syntax And Using It In Access Queries
06:16

0502 Filtering Your SQL Statement
05:10

0503 Linking Multiple Tables In SQL
04:47

0504 Grouping Data Through SQL
04:59

0505 Using Formula In SQL Select Statements
04:09

0506 The Powerful Subquery
07:07

0507 Generating A Union Query In Access
05:50

0508 Action SQL Statements
06:27
+
Advanced Form Design
13 Lectures 01:31:54
0601 Adding New Bound Data Objects
05:30

0602 Adding Unbound Objects
06:43

0603 Manually Configuring Combo Boxes
07:26

0604 Referencing The Unbound Columns Of Combo Boxes
08:35

0605 Introducing Navigation Forms
05:37

0606 Create Non Data Forms As Menus And Dialogs
09:05

0607 Creating Command Buttons For Forms
07:02

0608 Open One Form Filtered By Another
04:51

0609 Creating Buttons Without The Wizard
06:50

0610 Using Double Click Instead Of Click
06:44

0611 Building A Search Form
07:27

0612 Dynamic List Box Filtering
09:15

0613 Adding A Data Chart To A Form
06:49
+
Advanced Reports
12 Lectures 01:24:14
0701 Creating A Report Without The Wizard
08:01

0702 Add Titles And Images
03:43

0703 Formatting Lines And Background Colors
06:21

0704 Page Numbering And Displaying The Current Date
07:50

0705 Add Calculations To A Report
06:19

0706 Sorting And Grouping Data
08:08

0707 Adding Totals To Groups
09:44

0708 Creating Summary Reports
07:24

0709 Multiple Lines In A Concatenated Field
08:42

0710 Open A Report Filtered By A Form
06:00

0711 Adding A Chart To A Report
06:19

0712 Charts Filtered By The Reports Grouping
05:43
+
Subforms And Reports
6 Lectures 38:34
0801 Subforms Can Be Bound Or Unbound
04:54

0802 Creating And Using Unbound Subforms
06:34

0803 Create A Bound Subform
05:51

0804 Form Tabs For Displaying Multiple Subform Data
08:13

0805 Adding A Bound Sub Report
06:16

0806 Clever Use Of Unbound Reports
06:46
+
Macros
12 Lectures 01:09:38
0901 What Is A Macro
03:10

0902 Steps To Creating A Macro
06:02

0903 Assign Macros To Buttons On Forms
06:30

0904 Assign A Macro To A Ribbon Icon
04:21

0905 Use Of Sub Macros
05:12

0906 Assigning Keyboard Shortcuts To Macros
05:43

0907 Open A Form Filtered Through A Macro
07:48

0908 Using An If To Control The Flow Of Actions
06:09

0909 Running Action SQL From A Macro
07:39

0910 Adding Comments To Macros
04:29

0911 Configure A Macro To Run When The Database Opens
06:00

0912 Adding An OK Confirmation Step
06:35
+
Database Utilities
4 Lectures 17:43
1001 Why Do I Need To Compact And Repair?
06:38

1002 Converting Access Databases To And From Previous Versions
04:42

1003 Backing Up A Database
02:21

1004 Tracking Dependent Objects
04:02
4 More Sections
About the Instructor
Infinite Skills
4.4 Average rating
42,544 Reviews
714,400 Students
331 Courses
High Quality Training

Infinite Skills is a Canadian based company who offer a huge and ever growing range of high quality eLearning solutions that teach using studio quality narrated videos backed-up with practical hands-on examples and comprehensive working files. All courses are created by trained educators and experts in video based education.

The emphasis is on teaching real life skills that are essential for progressing in today's commercial environment.