The Beginning Guide to Microsoft Access 2013

Name: The Beginning Guide to Microsoft Access 2013
Rating: 4.4 (1245 reviews)

Another Computer Mama Guide

Created byElizabeth Nofs

Last updated 6/2017

English

What you'll 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 manage Database files: Save and Save As

Course content

6 sections • 12 lectures • 1h 49m total length

Getting Started with our courses on UDEMY7:28
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

All materials for this program are available online.

The following resources are available to download throughout the lessons:

Beginning Guide to Microsoft® Access 2013
Microsoft Access 2013 Beginning Sample files
Getting Started: Hello, Access!12:32
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.

Tables and Table Design: Hello, Tables9:21
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: More Tables11:02
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

Forms and Form Design: Hello, Forms11:16
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: Designing for Real Users13:08
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

Questions and Query Design: Query Design9:28
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: More Questions, More Queries11:24
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

Answers and Report Design: Hello, Reports11:26
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: More Reports10:56
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.

Access Skill Test: Beginning1:07
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
BONUS LECTURE0:25
Thank you for letting me be your guide.

I hope that you learned a few new skills that you can take to work with you. 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/

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 Beginning

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

Beginning Guide to Microsoft® Access 2013
Microsoft Access 2013 Beginning Sample files

In Microsoft 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

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.

The Beginning Guide to Microsoft Access 2013

What you'll learn

Explore related topics

Course content

Getting Started2 lectures • 20min

Microsoft Access: Tables and Table Design2 lectures • 20min

Microsoft Access: Forms and Form Design2 lectures • 24min

Microsoft Access: Questions and Query Design2 lectures • 21min

Microsoft Access: Answers and Report Design2 lectures • 22min

Microsoft Access: Assessment2 lectures • 2min

Requirements

Description

Who this course is for: