Microsoft PowerPoint 2013 Beginning: Every Picture Tells a Story

Microsoft PowerPoint 2013 Beginning: Every Picture Tells a Story

Microsoft PowerPoint 2013 Beginning: Every Picture Tells a Story Project: A PowerPoint show that uses pictures to tell the story In this lesson, you will learn how to: 1. Use the Picture Tools Ribbon to format the Picture Styles. 2. Modify the Picture Borders and Picture Effects. 3. Crop and Resize a picture. 4. Apply image Corrections such as Soften/Sharpen, Brightness/Contrast, Artistic Effects 5. Manipulate images: Compress, Change or Reset and Remove Background. Another Computer Mama Guide: www.thecomputermama.com If you wish to prepare for Microsoft Certification Exam 77-422: Microsoft Office PowerPoint 2013, this course will help you build the skills and knowledge you need. • Step-by-step video demonstrations. • Companion eBook with 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® PowerPoint 2013 • Microsoft PowerPoint 2013 Beginning Sample files With this comprehensive, performance-based certification preparation online program, you can build and validate your business computer skills using Microsoft PowerPoint 2013 software. You'll cover basic through advanced topics. Upon completion, you'll be prepared to earn your certification and gain an important edge in today's competitive job market. The Microsoft PowerPoint 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-422: Microsoft Office PowerPoint 2013 will find beginning through advanced lessons that demonstrate these required MOS topics. This course teaches the objectives for the following certification tests: PowerPoint® 2013: Exam 77-422
thecomputermama
Microsoft Excel 2013 Intermediate: Text and Date Formulas

Microsoft Excel 2013 Intermediate: Text and Date Formulas

This lessons teaches Text, Date and simple Financials formulas. Project: Use formulas to format TEXT, DATE, and TIME. Use FINANCIAL formulas to calculate a car payment Intermediate Excel Objectives In this lesson, you will learn how to: 1. Practice modifying cell contents and formats. 2. Use the Paste Special options. 3. CONCATENATE (combine) data with a formula. 4. Modify and format TEXT with formulas. 5. Use DATE and TIME formulas. 6. Use FINANCIAL formulas to calculate a car payment. Another Computer Mama Guide: www.thecomputermama.com If you wish to prepare students for Microsoft Certification Exam 77-420: Microsoft Office Excel 2013 OR Microsoft Certification Exam 77-427 Part 1 and 77-428 Part 2: Microsoft Office Excel 2013 Expert, this course will help you teach the skills and knowledge your students need: This course includes: • Step-by-step video demonstrations (MP4) • Companion eBook with detailed instructions (PDF) • Sample spreadsheets and files • Practice, Quizzes and Skill Test With this comprehensive, performance-based certification preparation online program, you can teach and validate important business computer skills using Microsoft Excel 2013 software. You can teach basic through advanced topics. Upon completion, your students will be prepared to earn their certification and gain an important edge in today's competitive job market. Other Recommended Microsoft Excel 2013 Sample Files (Not Included) Microsoft Excel 2013 Beginning: Sample Files Microsoft Excel 2013 Intermediate: Sample Files Microsoft Excel 2013 Advanced: Sample Files If you are interested in Microsoft Excel 2013, here are some resources you may consider: Microsoft Excel 2013 Beginning Microsoft Excel 2013 Beginning: It All Adds Up Microsoft Excel 2013 Beginning: A Question of Balance Microsoft Excel 2013 Beginning: Chart and Chart Tools Microsoft Excel 2013 Intermediate Microsoft Excel 2013 Intermediate: Legs, Eggs and Pigs Microsoft Excel 2013 Intermediate: Text and Date Formulas Microsoft Excel 2013 Intermediate: Using Lookup Tables Microsoft Excel 2013 Intermediate: Using Named Ranges Microsoft Excel 2013 Intermediate: In Print Microsoft Excel 2013 Intermediate: Online Microsoft Excel 2013 Advanced Microsoft Excel 2013 Advanced: Tables Microsoft Excel 2013 Advanced: PivotTables Microsoft Excel 2013 Advanced: PivotCharts
thecomputermama
Microsoft Access 2013 Advanced: Many-to-Many Relationships

Microsoft Access 2013 Advanced: Many-to-Many Relationships

Microsoft Access 2013 Advanced: Many-to-Many Relationships This is an introduction to the lessons in the Access 2013 Advanced programming. Please review our Microsoft Access lessons available on TES and download the zipped files that include eBook (PDF), video (MP4) and sample files. An overview of our Microsoft Access lessons available on TES: 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 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. Please review our Microsoft Access lessons available on TES and download the zipped files that include eBook (PDF), video (MP4) and sample files. • Step-by-step video demonstrations • Companion eBook with detailed instructions • Sample databases • Practice, Quizzes and Skill Test 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
thecomputermama
Microsoft Access 2013 Beginning: Hello, Access!

Microsoft Access 2013 Beginning: Hello, Access!

Microsoft Access 2013 Beginning: Hello, Access! 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. 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 database • Practice, Quizzes and Skill Test All materials for this program are available online. 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
thecomputermama
Microsoft Access 2013 Beginning

Microsoft Access 2013 Beginning

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. • eBook with 290 pages of detailed instructions (PDF) • 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
thecomputermama
Microsoft Excel 2013 Advanced: PivotTables

Microsoft Excel 2013 Advanced: PivotTables

PivotTables combine all of the best Data Tools: Sort, Filter, and Subtotal. This lesson teaches how to summarize data in an interactive PivotTable in Microsoft Excel 2013. If you wish to prepare students for Microsoft Certification Exam 77-420: Microsoft Office Excel 2013 OR Microsoft Certification Exam 77-427 Part 1 and 77-428 Part 2: Microsoft Office Excel 2013 Expert, this course will help you teach the skills and knowledge your students need: This course includes: • Step-by-step video demonstrations (MP4) • Companion eBook with detailed instructions (PDF) • Sample spreadsheets and files • Practice, Quizzes and Skill Test With this comprehensive, performance-based certification preparation online program, you can teach and validate important business computer skills using Microsoft Excel 2013 software. You can teach basic through advanced topics. Upon completion, your students will be prepared to earn their certification and gain an important edge in today's competitive job market. If you are interested in Microsoft Excel 2013, here are some resources you may consider: Microsoft Excel 2013 Beginning Microsoft Excel 2013 Beginning: It All Adds Up Microsoft Excel 2013 Beginning: A Question of Balance Microsoft Excel 2013 Beginning: Chart and Chart Tools Microsoft Excel 2013 Intermediate Microsoft Excel 2013 Intermediate: Create a Price Sheet Microsoft Excel 2013 Intermediate: Legs, Eggs and Pigs Microsoft Excel 2013 Intermediate: Text and Date Formulas Microsoft Excel 2013 Intermediate: Using Lookup Tables Microsoft Excel 2013 Intermediate: Using Named Ranges Microsoft Excel 2013 Intermediate: In Print Microsoft Excel 2013 Intermediate: Online Microsoft Excel 2013 Advanced Microsoft Excel 2013 Advanced: Tables Microsoft Excel 2013 Advanced: PivotTables Microsoft Excel 2013 Advanced: PivotCharts
thecomputermama
Microsoft Access 2013 Beginning: Form Design

Microsoft Access 2013 Beginning: Form Design

Microsoft Access 2013 Beginning: Form Design 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. 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. 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
thecomputermama
Microsoft Access 2013 Beginning: More Report Designs

Microsoft Access 2013 Beginning: More Report Designs

Microsoft Access 2013 Beginning: More Report Designs 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. 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. 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
thecomputermama
Microsoft Access 2013 Intermediate: The Search Form, part 1

Microsoft Access 2013 Intermediate: The Search Form, part 1

Microsoft Access 2013 Intermediate: The Search Form, part 1 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 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. 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
thecomputermama
Microsoft Access 2013 Intermediate: The Search Form, part 2

Microsoft Access 2013 Intermediate: The Search Form, part 2

Microsoft Access 2013 Intermediate: The Search Form, part 2 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 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. 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
thecomputermama
Microsoft Access 2013 Advanced: The Receipt Form, part 2

Microsoft Access 2013 Advanced: The Receipt Form, part 2

Microsoft Access 2013 Advanced: The Receipt Form, part 2 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 of 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 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. 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
thecomputermama
Microsoft Access 2013 Beginning: Designing Forms for Real Users

Microsoft Access 2013 Beginning: Designing Forms for Real Users

Microsoft Access 2013 Beginning: Designing Forms for Real Users 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 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. 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
thecomputermama
Microsoft Access 2013 Beginning: Query Designs

Microsoft Access 2013 Beginning: Query Designs

Microsoft Access 2013 Beginning: Query Designs 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 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. 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
thecomputermama
Microsoft Access 2013 Beginning: Table Design

Microsoft Access 2013 Beginning: Table Design

Microsoft Access 2013 Beginning: Table Design 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. 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 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
thecomputermama
Microsoft Access 2013 Beginning: More Tables

Microsoft Access 2013 Beginning: More Tables

Microsoft Access 2013 Beginning: More Tables 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 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. 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
thecomputermama
Microsoft Access 2013 Beginning: Report Designs

Microsoft Access 2013 Beginning: Report Designs

Microsoft Access 2013 Beginning: Report Designs 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. 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. 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
thecomputermama
Microsoft Access 2013 Intermediate: One-from-Many Relationships

Microsoft Access 2013 Intermediate: One-from-Many Relationships

Microsoft Access 2013 Intermediate: One-from-Many Relationships 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. 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. 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
thecomputermama
Microsoft Access 2013 Intermediate: The Opening Scene

Microsoft Access 2013 Intermediate: The Opening Scene

Microsoft Access 2013 Intermediate: The Opening Scene 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. 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. 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
thecomputermama
Microsoft Access 2013 Intermediate: Report 1 (Totals)

Microsoft Access 2013 Intermediate: Report 1 (Totals)

Microsoft Access 2013 Intermediate: Report 1 (Totals) 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. 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. 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
thecomputermama
Microsoft Access 2013 Beginning: More Query Designs

Microsoft Access 2013 Beginning: More Query Designs

Microsoft Access 2013 Beginning: More Query Designs 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 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. 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
thecomputermama
Microsoft Access 2013 Intermediate: Meet the Stars

Microsoft Access 2013 Intermediate: Meet the Stars

Microsoft Access 2013 Intermediate: Meet the Stars 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 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. 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
thecomputermama
Microsoft Access 2013 Intermediate: Report 2 (Formatting)

Microsoft Access 2013 Intermediate: Report 2 (Formatting)

Microsoft Access 2013 Intermediate: Report 2 (Formatting) 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 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. 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
thecomputermama
Microsoft Access 2013 Intermediate: The Search Form, part 3

Microsoft Access 2013 Intermediate: The Search Form, part 3

Microsoft Access 2013 Intermediate: The Search Form, part 3 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 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. 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
thecomputermama
Microsoft Access 2013 Advanced: Tables 2-Primary Keys and Relationships

Microsoft Access 2013 Advanced: Tables 2-Primary Keys and Relationships

Microsoft Access 2013 Advanced: Tables 2-Primary Keys and Relationships 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 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. 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
thecomputermama