The Advanced Guide to Microsoft Access 2013
5.0 (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.
2 students enrolled
Wishlisted Wishlist

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

Add to Wishlist

The Advanced Guide to Microsoft Access 2013

Another Computer Mama Guide
5.0 (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.
2 students enrolled
Created by Elizabeth Nofs
Last updated 6/2017
English
Current price: $10 Original price: $200 Discount: 95% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 2.5 hours on-demand video
  • 2 Articles
  • 16 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • 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
View Curriculum
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

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 347 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:

·         Advanced Guide to Microsoft® Access 2013

·         Microsoft Access 2013 Advanced Sample files

In Microsoft 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
16 Lectures
02:38:27
+
Getting Started
4 Lectures 34:38

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 07:28

This is an introduction to the lessons in the Access 2013 Advanced programming. It is a very useful reference as you go through these lessons.


An overview of the lessons in this book:

1. Representing many-to-many relationship with a Table and Subdatasheet.

2. Using Primary Keys to create Relationships between Tables.

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

Preview 00:27

Project: Create a Table and use the Primary Key to create a relationship to an existing Table

Advanced Access Objectives

1. Define the Primary Key in a new Table

2. Add a Foreign Key to a Table

3. Use the Primary Keys to create Relationships between Tables

4. Add a Subdatasheet and format the Tables to Show/Hide and Freeze the Columns in Datasheet View

Preview 12:26

Project: Create several Tables with Primary and Foreign Keys

Advanced Access Objectives

1. Identify the levels of database design: First, Second and Third Normal Form.

2. Create Tables in Design View that have Primary and Foreign Keys.

3. Create Tables that do not have repeating groups: Third Normal Form.

4. Document the Relationships.

5. Edit the Joins between Tables to ensure Data Integrity and Enforce Referential Integrity

Tables: Primary Keys and Relationships
14:17
+
Advanced Form Design
2 Lectures 29:40

Project: Create and format a Tabular Subform and a Receipt Form that looks up customers by their phone number

This is Part 1 or a two-part lesson!

Advanced Access Objectives

1. Use a Table to format a Form.

2. Insert, Merge and Split Rows and Columns in a Tabular Layout.

3. Reposition and Format Control Padding, Margins and Anchoring.

4. Add a Background Image to a Form

Preview 13:00

Project: Create and format a Receipt Form that uses a Combo Box to look up a customer by their phone number

This is Part 2 or a two-part lesson!

Advanced Access Objectives

1. Create a Select Query that combines (JOINS) several Tables by matching Keys.

2. Create a Blank Form and select a Query as the Record Source in the Form Properties.

3. Add existing Fields to a Form.

4. Add a Subform and Link the Form and Subform by three Key Fields.

5. Test the Receipt Form, see if it works

The Receipt Form, part 2
16:40
+
Advanced Report Design: The Receipt Printout
2 Lectures 27:53

Project: A Receipt Printout Report formatted as a Table and sized for a POS Printer

This is Part 1 or a two-part lesson!

Advanced Access Objectives

1. Create a Select Query that groups the sales and calculates the Totals for each Receipt.

2. Use the Group By and Totals Row in a Query.

3. Create a Blank Report and select a Query as the Record Source.

4. Edit the Report Page Setup and change the page Size and Orientation

Report Design: The Receipt Printout, part 1
13:42

Project: A Receipt Subreport that will be added to the Receipt Report from the prior lesson

This is Part 2 or a two-part lesson!

Advanced Access Objectives

1. Create a Select Query that combines (JOINS) several Tables by matching Keys.

2. Create a Tabular Report and use the Report Arrange options to Insert Rows, Merge Cells and Move Fields into different Rows.

3. Resize the SubReport and format the Headers.

4. Add a SubReport and Link the Form and Subform by a Key Field.

5. Test the Receipt Report in Print Preview.

Report Design: The Receipt Printout, part 2
14:11
+
Sharing and Collaboration
3 Lectures 34:26

Project: A Report that uses a Query to calculate which movies are overdue

Advanced Access Objectives

1. Create a Select Query that calculates the overdue movies for each customer with the DateDiff() function.

2. Format the Report Headers to include Bound and Unbound Controls.

3. Edit the Report Tab Order and align the Controls to the grid.

Advanced Design: Using Dates in Calculations
17:00

Project: Create a Crosstab Query to analyze the data. Export and print the Report in several formats

Advanced Access Objectives

1. Analyze the data as a Crosstab Query.

2. Save a Report as an XPS or PDF file format.

3. Send a Report by E-mail.

4. Export the Report data into different formats including Microsoft Word and Excel.

Advanced Design: Prepare to Share
11:12

Project: Create a Crosstab Query to analyze the data. Export and print the Report in several formats.

This is Part 2, or a two-part lesson!

Advanced Access Objectives

1. Analyze the data as a Crosstab Query.

2. Save a Report as an XPS or PDF file format.

3. Send a Report by E-mail.

4. Export the Report data into different formats including Microsoft Word and Excel.

Advanced Design: Prepare to Share, part 2
06:14
+
The Administrator
3 Lectures 30:02

Project: Several Action Queries that Append, Update and move the data in the Tables

This is Part 1 of a two-part lesson!

Advanced Access Objectives

1. Append new Records to an existing Table.

2. Create an Action Query to Update the data for selected Records in a Table.

3. Use an Action Query to Make a new Table and copy selected Records to that new Table.

4. Create a Delete Query and practice with a copy of an existing Table

The Admin: Strategies for Archiving, part 1
11:31

Project: Several Action Queries that Append, Update and move the data in the Tables

This is Part 2 of a two-part lesson!

Advanced Access Objectives

1. Append new Records to an existing Table.

2. Create an Action Query to Update the data for selected Records in a Table.

3. Use an Action Query to Make a new Table and copy selected Records to that new Table.

4. Create a Delete Query and practice with a copy of an existing Table

The Admin: Strategies for Archiving, part 2
09:20

Project: Split a database into two databases and link them together

Advanced Access Objectives

1. Split an Access database into two databases-Tables and User Interface-to deploy the database in a multi-user network.

2. Link the two databases and refresh the links with the Linked Table Manager.

3. Manage the Access Environment and set the Access Options for the General, Datasheet, Object Designers, Client Settings, and the Quick Access Toolbar.

4. Open a database Exclusively and Encrypt it with a Password. 

5. Compact and Repair a databas

The Admin: The Performance Network
09:11
+
Microsoft Access Assessment
2 Lectures 02:07

The Advanced 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:42

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

THANK YOU COUPON: If you wish to enroll in another Computer Mama course for only $10.00 (SAVE $190.00) please use this code: COOKIES


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/

BONUS LECTURE
00:25
About the Instructor
Elizabeth Nofs
4.3 Average rating
972 Reviews
14,760 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