[Udemy 100% Free]-Microsoft Access Advanced - 100% Free Udemy Discount Coupons For Online Courses


Wednesday, February 20, 2019

[Udemy 100% Free]-Microsoft Access Advanced

[Udemy 100% Free]-Microsoft Access Advanced


MODULE 1:  Advanced Data Management
Learning outcomes: A look into table relationships and referential integrity along  with introducing SQL, the language database professionals use to manage a  database.

Topics covered:
  • Referential Integrity
  • Table Relationships
  • An Introduction to SQL
  • Modal Dialog Boxes
MODULE 2:  Advanced Form Tasks
Learning outcomes: Creating navigation forms and sub-forms along with some of the  advanced form controls necessary to create a fully rounded user  interface.

Topics covered:
  • Using Subforms
  • Creating a Navigation Form
  • Advanced Form Controls
  • Exporting a Form
  • Other Form Tasks
MODULE 3:  Automating Reports
Learning outcomes:  Create Reports in Access that can return data quickly by using a  form to control and launch reports. Look at modifying form properties  including combo boxes and link a query to a form.

Topics covered:
  • Creating the Report Form
  • Building Query Criteria
MODULE 4:  SQL and Microsoft Access
Learning outcomes: Some of the basic and more advanced SQL commands here along with the concept of JOINS and sub-queries.

Topics covered:
  • Understanding SQL
  • Using the SELECT Statement
  • Using Subqueries
  • Using SQL Joins
MODULE 5:  Macros and Visual Basic for Applications (VBA)
Learning outcomes:  Using Macros and Visual Basic to create some advanced functionality to your Access Database.

Topics covered:
Macro Basics
More about Macros
Access and VBA
Building Advanced Procedures
Using VBA in a Database

MODULE 6:  Finishing the Application
Learning outcomes:  Look at finishing touches to control how users interact with a  database using start-up and sharing options. Identify security measures  by creating an ACCDE and encrypting a database with a password.

Topics covered:
Setting Start Up Options
Sharing/Splitting the Database
Creating an ACCDE
Encrypting the Database with a Password

No comments:

Post a Comment