وب سایت تخصصی شرکت فرین
دسته بندی دوره ها

جمع جزء: 1,074,000 تومان

مشاهده سبد خریدتسویه حساب

رمز خود را فراموش کرده اید؟
وب سایت تخصصی شرکت فرین
6
خانه » فروشگاه » آموزش های اداری و آفیس » آموزش Microsoft Access » MO-500 Microsoft Access Expert Certification

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
    • 179,000 تومان
    بیش از یک محصول به صورت دانلودی میخواهید؟ محصول را به سبد خرید اضافه کنید.
    افزودن به سبد خرید
    خرید دانلودی فوری

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

    ایمیل شما:
    تولید کننده:
    مدرس:
    شناسه: 12244
    حجم: 2720 مگابایت
    مدت زمان: 517 دقیقه
    تاریخ انتشار: ۲۸ اردیبهشت ۱۴۰۲
    دسته بندی محصول
    Udemy-Training
    Udemy-Training
    مشاهده دوره های Udemy-Training
    دیگر آموزش های این مدرس
    طراحی سایت و خدمات سئو

    179,000 تومان
    افزودن به سبد خرید