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

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

Microsoft Access 2013 Intermediate

Access 2013 Intermediate Another Computer Mama Guide: www.thecomputermama.com If you wish to prepare for Certification Exam 77-424: Microsoft Office Access 2013 this course will help you build the skills and knowledge you need. • eBook with 282 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: • Intermediate Guide to Microsoft® Access 2013 • Microsoft Access 2013 Intermediate Sample files In Microsoft Access, you’ll cover basic through advanced topics, including: • Review the definition of one-to-many relationships in a database • Create a One-From-Many Relationship by using a Combo Box on a Form • Learn how to design Forms and Subform that represent a one-to-many relationship • Use Forms and Subforms to create a Search Form • Create a Switchboard Form with Command buttons that open Forms and Reports • Use a Query to calculate the Total in a Report The Microsoft Access 2013 Certification Training Program is part of the Microsoft Business Certification program: Microsoft Office Specialist (MOS). MOS certification is the globally recognized standard for validating expertise with the Microsoft Office 2013 suite. Students who wish to prepare for Microsoft Certification Exam 77-424: Microsoft Office Access 2013 will find beginning through advanced lessons that demonstrate these required MOS topics. This course teaches the objectives for the following certification tests: Expert Certification: Access® 2013: Exam 77-424
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 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 Advanced: The Producers

Microsoft Access 2013 Advanced: The Producers

Microsoft Access 2013 Advanced: The Producers 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. 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: Strategies for Archiving (Action Queries!)

Microsoft Access 2013 Advanced: Strategies for Archiving (Action Queries!)

Microsoft Access 2013 Advanced: Strategies for Archiving (Action Queries!) Project: Several Action Queries that Append, Update and move the data in the Tables 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 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 Report, part 1

Microsoft Access 2013 Advanced: The Receipt Report, part 1

Microsoft Access 2013 Advanced: The Receipt Report, part 1 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 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 1- Tables in a Relational Database

Microsoft Access 2013 Advanced: Tables 1- Tables in a Relational Database

Microsoft Access 2013 Advanced: Tables 1- Tables in a Relational Database 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 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 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 Advanced: The Receipt Report, part 2

Microsoft Access 2013 Advanced: The Receipt Report, part 2

Microsoft Access 2013 Advanced: The Receipt Report, part 2 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. 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 Performance Network

Microsoft Access 2013 Advanced: The Performance Network

Microsoft Access 2013 Advanced: The Performance Network 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 database 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 Prepare to Share

Microsoft Access 2013 Advanced: The Prepare to Share

Microsoft Access 2013 Advanced: The Prepare to Share 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. 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 Advanced: The Receipt Form, part 1

Microsoft Access 2013 Advanced: The Receipt Form, part 1

Microsoft Access 2013 Advanced: The Receipt Form, part 1 Project: Create and format a Tabular Subform and a Receipt Form that looks up customers by their phone number This is Part 1 of 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 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 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 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