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

Microsoft Access 2016 Intermediate/Advanced Course

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

The ultimate next step for anyone interested in supercharging their Microsoft Access and data analysis skills


1 - Introduction to Microsoft Access 2016 Advanced
  • 1 - Course Overview and Content
  • 2 - WATCH ME Essential Information for a Successful Training Experience
  • 3 - Access-2016-Advanced-Exercise-Files.zip
  • 3 - DOWNLOAD ME Course Exercise Files.html
  • 4 - Access-2016-Advanced-Course-Files.zip
  • 4 - DOWNLOAD ME Course Demo Files.html

  • 2 - Primary Keys and Indexes
  • 5 - Primary Keys and Indexing Rules and Guidelines
  • 6 - More About Indexes

  • 3 - Using Datasheet View
  • 7 - Settingup Northwind Database
  • 8 - Working in a Datasheet View
  • 9 - Customizing Datasheet View and Advanced Sorting and Filtering
  • 10 - Subdatasheets
  • 11 - Exercise 01

  • 4 - Linking to Other Access Databases
  • 12 - Linking Two Tables to Other Access Databases

  • 5 - Using ODBC and SQL Server
  • 13 - Acquiring and Installing SQL Server Express
  • 14 - Setting up SQL Server Database
  • 15 - Exercise 2

  • 6 - Splitting An Access Database
  • 16 - Splitting an Access Database into Frontend and Backend Databases
  • 17 - Converting Shared Table into Local Table Moving Backend Database
  • 18 - Exercise 3
  • 19 - Addressing Multiusers Issues When Sharing Data

  • 7 - Macros
  • 20 - Basics of Macros
  • 21 - Macros on Events AutoExec
  • 22 - More About AutoExec Bypassing AutoExec
  • 23 - Macro Security Settings
  • 24 - Exercise 4

  • 8 - The Ribbon
  • 25 - Customizing the Ribbon and Quick Access Tool

  • 9 - Visual Basic for Applications in Access 2016
  • 26 - Convert Macros to VBA VBA Editor and Property Windows
  • 27 - VBA Modules Running Code and Error Handling
  • 28 - Creating Modules Subs Functions Intellisense and Variables
  • 29 - Scope Variable Naming and Strings
  • 30 - Standard Functions Logical Case and Loop Statements

  • 10 - Access Events Model
  • 31 - Adding Events to Assets Database
  • 32 - Exercise 05
  • 33 - Common Events Form and Report Events
  • 34 - Switchboard and Navigation Form Error Handling
  • 35 - Exercise 06

  • 11 - Forms
  • 36 - Formatting Bound and Control Form
  • 37 - Split Forms Macro Error Handling
  • 38 - Creating Form with Tab
  • 39 - Go To Combo Box and Its Properties
  • 40 - Exercise 07

  • 12 - Advanced Use of Queries
  • 41 - Basic of Queries Review
  • 42 - Syntax of SQL Statements
  • 43 - Use of Multiple Where Criteria Select Statements Function
  • 44 - Joins and Its Types
  • 45 - Exercise 08
  • 46 - Action Queries Part 1
  • 47 - Action Queries Part 2
  • 48 - Subqueries

  • 13 - Packaging Your Application
  • 49 - Steps in Packaging Access Application
  • 50 - Exercise 09

  • 14 - Conclusion
  • 51 - Online Support and Conclusion

  • 15 - Extras
  • 52 - Access-Shortcuts.pdf
  • 52 - EXTRA RESOURCE The Most Frequently Used Access Shortcuts Infographic.html
  • 139,000 تومان
    بیش از یک محصول به صورت دانلودی میخواهید؟ محصول را به سبد خرید اضافه کنید.
    افزودن به سبد خرید
    خرید دانلودی فوری

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

    ایمیل شما:
    تولید کننده:
    مدرس:
    شناسه: 7489
    حجم: 1479 مگابایت
    مدت زمان: 546 دقیقه
    تاریخ انتشار: ۱۳ اسفند ۱۴۰۱
    طراحی سایت و خدمات سئو

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