Mastering Access 2013

Create Custom Database Apps On Your Network Or On The Web With This Modern Data-Crunching Powerhouse!

Instructor : Peggy Ward

Everything You Need To Know About Microsoft Access — Delivered In Easily Searchable, Highly Informative Video Lessons
Create Custom Database Apps On Your Network Or On The Web With This Modern Data-Crunching Powerhouse!

Microsoft Access lets ordinary users develop powerful apps customized for their business needs. The new Access 2013 even lets you build web-based apps which anyone can use. In this course experienced Microsoft Access trainer Peggy Ward will walk you through building your first Microsoft Access desktop or web app, including:

  • Creating and managing tables
  • Using templates
  • Building and modifying queries
  • Using forms and reports
  • Database maintenance
  • Creating web apps

Go From Beginner to Expert Through 45 Detailed Lessons – Or Jump Straight To The Information You Need Right Now With Our Built-In Search Function

Objectives – You will be able to:

  • Demonstrate navigating around the Access Interface
  • Explain the relationship between Tables, Records, and Forms in Access
  • Describe how Access can be used to create web-based applications

Course Length

Lessons : 45
Seat Time : 5.5 Hours

Lessons Include:

01: Getting Started (10:47)
02: Database Objects (10:49)
03: Creating a Database (7:26)
04: Creating Tables (8:31)
05: Importing External Data (7:56)
06: Creating Linked Tables (5:02)
07: Creating Tables from Templates (2:53)
08: Working with Records in a Table (5:49)
09: Tables and Forms (7:38)
10: Planning Tables and Forms (8:03)
11: Creating a Table in Design View (7:50)
12: Managing Table Relationships, Part 1 (5:49)
13: Managing Table Relationships, Part 2 (5:24)
14: Controlling Data Entry, Part 1 (10:12)
15: Controlling Data Entry, Part 2 (6:59)
16: Controlling Data Entry, Part 3 (13:30)
17: Working with Tables (3:58)
18: Importing Data from Other Sources (9:28)
19: Import and Link Data from Other Sources (8:47)
20: Import and Link Data from Excel (3:44)
21: Creating a Select Query (10:10)
22: Working with Criteria (7:12)
23: Doing More with Queries (4:43)
24: Group and Summarize Data in a Query (8:00)
25: Creating Flexible Queries (9:01)
26: Creating Action Queries, Part 1 (6:37)
27: Creating Action Queries, Part 2 (6:55)
28: Creating and Modifying Forms (6:29)
29: Modify Forms in Design View, Part 1 (10:27)
30: Modify Forms in Design View, Part 2 (5:36)
31: Add Controls to Forms (7:18)
32: Tab Pages and Form Control Properties (6:05)
33: Create and Modify Reports Wizard (5:17)
34: Modify Reports in Design View (7:27)
35: Formatting Reports (4:22)
36: Adding Calculations to a Report (12:42)
37: Putting Finishing Touches on a Report (5:11)
38: Modify Startup Options (6:20)
39: Maintaining a Database, Part 1 (7:33)
40: Maintaining a Database,Part 2 (9:35)
41: Merging Databases (7:15)
42: Exporting to External Locations (7:26)
43: Saving Databases (3:37)
44: Creating a Web App from a Template (9:18)
45: Creating a Custom Web App (5:13)

Trusted by Aspiring IT Professionals, Corporations and
Government agencies
for more than a Decade

Get unlimited online access learn anywhere, anytime using your computer or mobile device!