The Intermediate Guide to Microsoft Access 2013
4.5 (7 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
16 students enrolled

The Intermediate Guide to Microsoft Access 2013

Another Computer Mama Guide
4.5 (7 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
16 students enrolled
Created by Elizabeth Nofs
Published 8/2016
English
English [Auto]
Current price: $139.99 Original price: $199.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 1.5 hours on-demand video
  • 2 articles
  • 12 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Review the definition of one-to-many relationships in a database
  • Create a One-From-Many Relationship by using a Combo Box on a Form
  • Learn how to design Forms and Subform that represent a one-to-many relationship
  • Use Forms and Subforms to create a Search Form
  • Create a Switchboard Form with Command buttons that open Forms and Reports
  • Use a Query to calculate the Total in a Report
Requirements
  • To enroll in the Microsoft Office Specialist 2013 program, you should have basic computer skills and should be comfortable using an Internet browser and selecting commands from a menu or toolbar. You should be able to manage files, including saving, updating, and backing up files.
  • This program can only be taken on a PC. It is not compatible with a Mac. You need a high-speed Internet connection and an e-mail account. You should also have Microsoft Office 2013 already installed: Access, Excel, Outlook, PowerPoint and Word.
Description

Microsoft Access 2013 Intermediate

Another Computer Mama Guide: www.thecomputermama.com 

If you wish to prepare for Certification Exam 77-424:  Microsoft Office Access 2013 this course will help you build the skills and knowledge you need.

  • Step-by-step video demonstrations
  • Companion eBook with 280 pages of detailed instructions
  • Sample databases
  • Practice, Quizzes and Skill Test


All materials for this program are available online.
The following resources are available to download throughout the lessons: 

  • Intermediate Guide to Microsoft® Access 2013
  • Microsoft Access 2013 Intermediate Sample files


In Microsoft Access, you’ll cover basic through advanced topics, including:

  • Review the definition of one-to-many relationships in a database
  • Create a One-From-Many Relationship by using a Combo Box on a Form
  • Learn how to design Forms and Subform that represent a one-to-many relationship
  • Use Forms and Subforms to create a Search Form
  • Create a Switchboard Form with Command buttons that open Forms and Reports
  • Use a Query to calculate the Total in a Report


The Microsoft Access 2013 Certification Training Program is part of the Microsoft Business Certification program: Microsoft Office Specialist (MOS). MOS certification is the globally recognized standard for validating expertise with the Microsoft Office 2013 suite. 

Students who wish to prepare for Microsoft Certification Exam 77-424:  Microsoft Office Access 2013 will find beginning through advanced lessons that demonstrate these required MOS topics.

 

This course teaches the objectives for the following certification tests: Expert Certification: Access® 2013: Exam 77-424

Who this course is for:
  • This program is for you if you are an office worker, manager, entrepreneur, or other professional who wants to start using advanced Microsoft Office skills immediately.
  • This program is also suitable for you if you are looking to learn about this software and expand your job possibilities.
Course content
Expand all 12 lectures 01:42:22
+ Microsoft Access: Getting Started
3 lectures 13:06

Welcome to our course! In this lesson you can learn how to:

  • Navigate our course 
  • Find the Downloads in the Resources 
  • Use the eBooks and Sample files


This is an introduction to our courses at Udemy, and how we teach. 

This course includes the following:

  • Step-by-step video demonstrations (MP4)
  • Companion eBooks with detailed instructions (PDF)
  • Sample databases and files
  • Practice, Quizzes and Skill Test


Preview 02:44

Project: A Lesson on creating Relationships in Microsoft Access

Intermediate Access Objectives

In this lesson, you will learn how to:  

1. Representing a one-to-many relationship with a Form and Subform

2. Using a Query Criteria to make a Combo Box that looks up a value on a Form

3. Creating a blank Form and adding buttons to open Forms and Reports

4. Finding common errors in Forms and Queries and correcting the mistakes

5. Calculating Totals in a Report


DOWNLOADS: This lesson includes:

  • Getting Started: Hello (PDF)
  • The Intermediate Guide to Microsoft Access 2013, 282 pages (PDF)
  • Intermediate Microsoft Access sample files and databases (Zipped)
Getting Started: Hello, Again Hello
00:07

Project: Create a Combo Box with the Wizard.

Intermediate Access Objectives

In this lesson, you will learn how to:  

1. Create a new Table to use as a Record Source for a Combo Box Control.

2. Use the Combo Box Wizard to create a Bound Drop Down Control.

3. Edit the Combo Box with the Property Sheet.

Preview 10:15
+ Form Design: Representing One-to-Many
3 lectures 41:49

Project: A Movie Search Form and Movie Subform.

This is Part 1 of a three-part lesson!

Intermediate Access Objectives

1. Use a Query as the Record Source for a Subform.

2. Apply Quick Styles to Controls in a Form/Subform.

3. Apply Conditional Formatting to a Subform that has Datasheet as the Default View.

4. Create a Form that has a Bound Control, a Combo Box that will filter the Records in the Subform

Preview 13:29

Project: A Movie Search Form and Movie Subform: Link a Form to a Subform and test it

This is Part 2 of a three-part lesson!

Intermediate Access Objectives

1. Review the Properties for a Form: Record Source, Controls, View. 

2. Create a Combo Box to filter the Records in the Subform.


Form Design: The Search Form, part 2
13:30

Project: A Select Query that synchronizes two Combo Boxes and filters the Subform

This is Part 3 of a three-part lesson!

Intermediate Access Objectives

1. Review the Properties for a Form: Record Source, Controls, View.

2. Use the Subform Wizard to add a Subform to a Form and link them by a common Field.

3. Create a Combo Box to filter the Records in the Subform.

4. Add a Macro to Refresh the Records in the Subform when the Combo Box is changed

Preview 14:50
+ Designing for Users
2 lectures 23:22

Project: Create a switchboard: an Unbound Form with Command Buttons that open Forms

Intermediate Access Objectives

1. Create a Blank Form and edit it in Design View to include a Logo, Background Image and Text Box.

2. Use the Command Button Wizard to create a Embedded Macro that opens another Form.

3. Edit the Embedded Macro and test the code.

4. Apply Quick Styles to the Controls in a Form

Designing for Users: Meet the Stars
16:31

Project: Change the Startup Options to display a Form when the database opens. Edit the Properties on the Switchboard Form.

Intermediate Access Objectives

1. Set the Microsoft Access Application options for the Current Database.

2. Display a Form when the database opens.

3. Do not display the Navigation Pane when the database opens.

4. Use the Form Properties to remove the Record Selectors, Navigation Buttons, Scroll bars, Control Box, Close Button, and the Min Max Buttons.

Designing for Users: The Opening Scene
06:51
+ One-to-Many in Report Design
2 lectures 22:32

Project: A Report with Conditional Formatting as well as a Command Button that opens a Form with an OnClick Event

Intermediate Access Objectives

1. Apply Report Design options including Theme, Logo, and a Background Image

2. Add Page Breaks and Page Numbers.

3. Apply Conditional Formatting to the data.

4. Program a Command Button to open a Form OnClick and format the Shape.

Report Design: Calculate the Report Totals
11:36

Project: A Report with Conditional Formatting as well as a Command Button that opens a Form with an OnClick Event

Intermediate Access Objectives

1. Apply Report Design options including Theme, Logo, and a Background Image

2. Add Page Breaks and Page Numbers.

3. Apply Conditional Formatting to the data.

4. Program a Command Button to open a Form OnClick and format the Shape

Report Design: More Report Formatting
10:56
+ Microsoft Access: Assessment
2 lectures 01:32

The Intermediate Access Skill Test. If you cannot open this link, you can download the same Skill Test as a Word document if you wish.

The Microsoft Access 2013 Certification Training Program is part of the Microsoft Business Certification program: Microsoft Office Specialist (MOS). MOS certification is the globally recognized standard for validating expertise with the Microsoft Office 2013 suite. Students who wish to prepare for Microsoft Certification Exam 77-424:  Microsoft Office Access 2013 will find beginning through advanced lessons that demonstrate these required MOS topics.

 

This course teaches the objectives for the following certification tests: Expert Certification: Access® 2013: Exam 77-424


Preview 01:07

Thank you for letting me be your guide.

I hope that you learned a few more things then when you started.

You done good. Got cookies?

eBeth

Elizabeth Nofs, the Computer Mama


Keep in Touch: https://thecomputermama.us

If you would like to stay in touch, please join me at my website for:

  • News and Course Announcements
  • Coupons and Freemiums
  • Guides and Mini-courses

New subscribers welcome!


Buy the books at Amazon: https://thecomputermama.us/books-page/

Visit our school at: https://thecomputermama.teachable.com/

Save $100 on our courses at www.thecomputermama.teachable.com/

Coupon code: MORE_COOKIES

BONUS LECTURE
00:25