MO-500 Microsoft Access Expert Certification

سرفصل های دوره

Complete Techniques for the MO-500 Microsoft Access Expert Certification Exam

Chapter 1 Introduction

001. Course Introduction and Structure

Chapter 2 Modify Database Structure

001. Import Objects or Data from Other Sources

002. Delete Database Objects

003. Hide and Display Objects in the Navigation Pane

Chapter 3 Manage Table Relationships and Keys

001. (Part 1) Understand Relationships

002. (Part 2) Understand Relationships

003. (Part 3) Understand Relationships

004. (Part 4) Understand Relationships

005. Display Relationships

006. Set the Primary Key

007. Enforce Referential Integrity

008. Set Foreign Keys

Chapter 4 Print and Export Data

001. Configure Print Options for Records, Forms, and Reports

002. Export Objects in Alternative Formats

Chapter 5 Objective Domain 1 Exercises and Solutions

001. Objective Domain 1 Exercises and Solutions

Chapter 6 Create Tables

001. Import Data into Tables

002. Create linked tables from external sources

003. Import tables from other databases

Chapter 7 Manage Tables

001. Hide Fields in Tables

002. Add Total Rows

003. Add Table Descriptions

Chapter 8 Manage Table Records

001. Find and Replace Data

002. Sort Records

003. Filter Records

Chapter 9 Create and Modify Fields

001. (Part 1) Add and Remove Fields

002. (Part 2) Add and Remove Fields

003. Add Validation Rules to Fields

004. Change Field Captions

005. Change Field Sizes and Data Types

006. Configure Auto Increment and Set Default Values

007. Apply Built-In Input Masks

Chapter 10 Objective Domain 2 Exercises and Solutions

001. Objective Domain 2 Exercise Solutions

Chapter 11 Create and Run Queries

001. Create Simple Queries

002. Create Basic Crosstab Queries

003. Create Basic Parameter Queries

004. (Part 1) Create Basic Action Queries

005. (Part 2) Create Basic Action Queries

006. (Part 3) Create Basic Action Queries

007. (Part 4) Create Basic Action Queries

008. Create Basic Multi-Table Queries

009. Save Queries

010. Run Queries

Chapter 12 Modify Queries

001. Add, Hide, and Remove Fields, Sort and Filter Data

002. Filter Data Within Queries

Chapter 13 Objective Domain 3 Exercises and Solutions

001. Objective Domain 3 Exercises and Solutions

Chapter 14 Configure Form Controls

001. Introduction to Forms

002. (Part 1) Add, Move, and Remove Form Controls

003. (Part 2) Add, Move, and Remove Form Controls

004. (Part 3) Add, Move, and Remove Form Controls

005. (Part 4) Add, Move, and Remove Form Controls

006. (Part 5) Add, Move, and Remove Form Controls

007. Add and Modify Form Labels

Chapter 15 Format Forms

001. Modify Tab Order on Forms

002. Sort Records by Form Field

003. Modify Form Positioning

004. Insert Information in Form Headers and Footers

005. Insert Images on Forms

Chapter 16 Objective Domain 4 Exercises and Solutions

001. Objective Domain 4 Exercises and Solutions

Chapter 17 Configure Report Controls

001. Introduction to Access Reports

002. Group and Sort Fields on Reports

003. Add and Modify Report Controls and Labels

Chapter 18 Format Reports

001. Format a Report into Multiple Columns

002. Modify Report Positioning

003. Format Report Elements

004. Change Report Orientation

005. Insert Information in Report Headers and Footers

006. Insert Images on Reports

Chapter 19 Objective Domain 5 Exercises and Solutions

001. Objective Domain 5 Exercises and Solutions

Chapter 20 Sample Exam

001. Sample Exam Project 1

002. Sample Exam Project 2

003. Sample Exam Project 3

004. Sample Exam Project 4

005. Sample Exam Project 5

006. Sample Exam Project 6

Chapter 21 Associate Access 77-730 Optional Lectures

001. Create a Blank Desktop Database

002. Create a Database from a Template

003. Compact and Repair a Database

004. Back Up a Database

005. Split a Database

006. Encrypt a Database with a Password

007. Recover Data from Backup

008. Create a Table

009. Create a Form

010. Create a Form from a Template with Application Parts

011. Create a Report Based on the Query or Table and in Design View

012. Create a Report Using the Report Wizard

139,000 تومان

افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy-Training