The Complete Guide to Microsoft Access 2013
4.5 (1 rating)
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.
11 students enrolled
Wishlisted Wishlist

Please confirm that you want to add The Complete Guide to Microsoft Access 2013 to your Wishlist.

Add to Wishlist

The Complete Guide to Microsoft Access 2013

Another Computer Mama Guide
4.5 (1 rating)
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.
11 students enrolled
Created by Elizabeth Nofs
Last updated 6/2017
English
Curiosity Sale
Current price: $10 Original price: $200 Discount: 95% off
30-Day Money-Back Guarantee
Includes:
  • 6 hours on-demand video
  • 5 Articles
  • 38 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Understand the purpose of Tables and how they are used in a database
  • Edit the Form Properties to help Users navigate the Form Fields and enter data
  • Learn how to design Queries and use Queries to lookup records in the Tables
  • Use Query Criteria and Parameter Queries to select specific records in the Tables
  • Learn how to design and modify Reports in Layout and Design Views
  • Learn how to design Forms and Subform that represent a one-to-many relationship
  • Create a Switchboard Form with Command buttons that open Forms and Reports
  • Use a Query to calculate the Total in a Report
  • Understand how to create and Normalize a database
  • Learn how to create relationships between Tables in a Database: using Key data
  • Learn strategies for Archiving data using Action Queries
  • Optimize a database for Multi-Users and improve network performance
View Curriculum
Requirements
  • 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. Before You Begin: Click here to get Microsoft Office software https://products.office.com/en-us/student/office-in-education Order the Books at www.amazon.com
  • 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.
Description

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 eBooks with pages of detailed instructions
  • Sample presentations and images
  • Practice, Quizzes and Skill Test

 

All materials for this program are available online.

The following resources are available to download throughout the lessons:

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


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

  • Learn how to navigate the online course and submit your assignments
  • Understand the purpose of Tables and how they are used in a database
  • Edit the Form Properties to help Users navigate the Form Fields and enter data
  • Learn how to design Queries and use Queries to lookup records in the Tables
  • Use Query Criteria and Parameter Queries to select specific records in the Tables
  • Learn how to design and modify Reports in Layout and Design Views
  • Learn how to manage Database files: Save and Save As


In Intermediate 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 relatinship
  • 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


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

  • Understand how to create and Normalize a database
  • Learn how to create relationships between Tables in a Database: using Key data
  • Understand Primary Keys and Relationships
  • Create a Receipt Form that uses a Report and Subreport to calculate the total
  • Become skilled at working with Dates in a Query
  • Visualize the results and export the Reports
  • Learn strategies for Archiving data using Action Queries
  • Optimize a database for Multi-Users and improve network performance


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 is the target audience?
  • 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.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
36 Lectures
06:01:11
+
Microsoft Access: Getting Started
2 Lectures 15:16

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


DOWNLOADS Included in this Lesson:

  • Beginning Guide to Microsoft® Access 2013, 290 pages (PDF)
  • Intermediate Guide to Microsoft® Access 2013, 282 pages (PDF)
  • Advanced Guide to Microsoft® Access 2013, 348 pages (PDF)


  • Microsoft Access 2013 Beginning Sample files (Zipped)
  • Microsoft Access 2013 Intermediate Sample files (Zipped)
  • Microsoft Access 2013 Advanced Sample files (Zipped)


Preview 02:44

Project: Introduction to Access database objects. Create and modify a customer Table.

Beginning Access Objectives

 In this lesson, you will learn how to:  

1. Create a new, blank Access database.

2. Use the Navigation Pane to find Access Objects.

3. Create and modify Tables: Add a Text Field.

4. Modify the Fields and test the Data Validation.

Preview 12:32
+
Microsoft Access: Tables and Table Design
2 Lectures 20:23

Project: Create and modify the Customer Table by adding new Fields in Design View

Beginning Access Objectives

In this lesson, you will learn how to:  

1. Use the Table Design View to edit Field Properties.

2. Edit the Field Properties and add a Default Value.

3. Add an Input Mask to a Text Field: format the Phone Number to include placeholders.

4. Review the purpose of the Primary Key.

5. Rename the Primary Key.

Tables and Table Design: Hello, Tables
09:21

Project: Import an Excel spreadsheet into Microsoft Access. Create and modify a product table

Beginning Access Objectives

In this lesson, you will learn how to:  

1. Import a Microsoft Excel spreadsheet into a new Table in an Access database.

2. Use the Design View to edit the Field Properties.

3. Sort and Filter Records in Access

Tables and Table Design: More Tables
11:02
+
Microsoft Access: Forms and Form Design
2 Lectures 27:56

Project: Create two Forms with the Form Wizard

Beginning Access Objectives

In this lesson, you will learn how to:  

1. Create a Form with the Form Wizard.

2. Modify the Forms in Layout View with the Form Design Tools.

3. Apply a Theme to a Form.

4. View the Property Sheet and use the Properties to resize and position a picture.

5. Use the Design Ribbon to Format the Header.

Forms and Form Design: Hello, Forms
11:16

Project: Edit the Form Controls with the Form Design Tools and the Property Sheet.

Beginning Access Objectives

In this lesson, you will learn how to:  

1. Go to the Design View and use the Form Design Tools to edit the Form Fields.

2. View the Property Sheet for the Form and the individual Form Controls.

3. Add a picture to the Form Header and use the Property Sheet to resize the picture.

4. Arrange the Form Fields and edit the Tab Order

Forms and Form Design: Designing for Real Users
16:40
+
Microsoft Access: Questions and Query Design
2 Lectures 20:52

Project: Create Select Queries based on the Table tblMovies.

Beginning Access Objectives

In this lesson, you will learn how to:  

1. Use the Query Wizard to select a Table as the Record Source and add Fields in a Select Query.

2. Sort the Query Results.

3. Edit the Query Criteria in Design View.

4. Add, Delete and Rearrange Fields in the QBE Grid.

5. Save the Select Query

Questions and Query Design: Query Design
09:28

Project: Parameter Queries with calculated Fields from the customer and movie Tables.

Beginning Access Objectives

In this lesson, you will learn how to:  

1. Create a Query in Design View and use the Show Table command to add a Record Source.

2. Add Fields to the QBE Grid.

3. Create a Field that combines (Concatenates) two or more Fields together.

4. Create a Parameter Query that prompts the User to enter more information when the Query runs

Questions and Query Design: More Questions, More Queries
11:24
+
Microsoft Access: Answers and Report Design
2 Lectures 22:22

Project: A Report created with the Report Wizard and formatted with a Theme

Beginning Access Objectives

In this lesson, you will learn how to:  

1. Use the Report Wizard to create a Report based on a Table.

2. Modify a Report in Report Layout View.

3. Apply a Theme and edit the Report Header to include a Logo.

4. Add Page Numbers to the Report Footer.

5. Use the Report Sort and Filter options.

Answers and Report Design: Hello, Reports
11:26

Project: A Report that uses a Parameter Query for the Record Source

Beginning Access Objectives

In this lesson, you will learn how to:  

1. Create a Report that uses a Parameter Query for the Record Source.

2. Modify the Report with the Report Layout Tools.

3. Create a Table with the Report Arrange options.

4. Use the Table functions to Move and Merge Cells.

Answers and Report Design: More Reports
10:56
+
Microsoft Access: Assessment
1 Lecture 01:26

The Beginning 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:26
+
Microsoft Access Intermediate: Hello, Again
2 Lectures 10:39

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

Getting Started: Hello, Again, Hello
00:24

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.

Getting Started: One-from-Many
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. 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

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

Form Design: The Search Form, part 3
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

5. Convert the Macros to Visual Basic

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 Scence
06:51
+
One-to-Many in Report Design
2 Lectures 25:17

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
13:41
7 More Sections
About the Instructor
Elizabeth Nofs
4.3 Average rating
976 Reviews
14,883 Students
18 Courses
The Computer Mama

Expert in Instructional Technology and Online Learning

Incredible ability to teach technology

Developed a successful method for teaching visually that is based on observation, orientation and notation. The method is very effect for teaching concepts and skills.

I have taught Microsoft Office Certification Exam preparation course for Microsoft Office 2003, 2007, 2010 and 2013 programs. The books that I wrote for these course met the Microsoft Vendor of Approved Courseware for the Microsoft Office 2010 and 2007(MCAS).

There are over 60 Computer Mama courses available through ed2go and World Education.  We have our own school at thecomputermama.teachable

During the summer, Alex and I participate in the High School Career Challenge. It is a program for students with Asperger's Syndrome (autism) that focuses on job skills and training. We developed a Flash animation course that teaches the students how to create banner ads.

I enjoy teaching Microsoft Office and look forward to working with you. eBeth