Advanced Microsoft Access 2013 Training Video

Take your Microsoft Access skills to the next level with this Advanced Access Course from Infinite Skills
4.7 (41 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.
750 students enrolled
$50
Take This Course
  • Lectures 99
  • Contents Video: 10 hours
    Other: 0 mins
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 11/2013 English

Course 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.

What are the requirements?

  • Microsoft Access 2013

What am I going to get from this course?

  • Take your Microsoft Access 2013 skills to the next level

What is the target audience?

  • Users with a basic understanding of Microsoft Access

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Access Advanced Introduction
Important - Download These First - Working Files
Preview
Article
0101 What Will You Learn?
Preview
05:21
0102 Relational Databases Explained
Preview
05:02
0103 Working Files Explained
02:51
Section 2: Advanced Table Design
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
Section 3: Advanced Querying
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
Section 4: Action Queries
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
Section 5: Standard Query Language
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
Section 6: Advanced Form Design
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
Section 7: Advanced Reports
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
Section 8: Subforms And Reports
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
Section 9: Macros
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
Section 10: Database Utilities
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
Section 11: Turn A Database Into An Application
1101 Creating A Welcome Screen
04:41
1102 Setting The Options For Database Startup
04:56
1103 Encrypting And Password Protecting Your Application
03:30
1104 Restrict Access To Some Objects By Use Of The ACCDE Format
04:26
1105 Why Split A Database In Two?
05:04
1106 Download, Distribute And Test Access Runtime
04:48
1107 Creating Your Own Ribbon And Tabs
07:10
1108 Adding Further Commands To A Custom Ribbon
07:39
Section 12: Custom Access Web Apps
1201 What Do I Need To Make Custom Web Apps?
01:58

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Infinite Skills, 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.

Ready to start learning?
Take This Course