Microsoft Access Advanced
Cena: $79.99
MODUŁ 1: Advanced Data Management
Wyniki nauki: A look into table relationships and referential integrity along with introducing SQL, the language database professionals use to manage a database.
Omówione tematy:
-
Referential Integrity
-
Table Relationships
-
An Introduction to SQL
-
Modal Dialog Boxes
MODUŁ 2: Advanced Form Tasks
Wyniki nauki: Creating navigation forms and sub-forms along with some of the advanced form controls necessary to create a fully rounded user interface.
Omówione tematy:
-
Using Subforms
-
Creating a Navigation Form
-
Advanced Form Controls
-
Exporting a Form
-
Other Form Tasks
MODUŁ 3: Automating Reports
Wyniki nauki: 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.
Omówione tematy:
-
Creating the Report Form
-
Building Query Criteria
MODUŁ 4: SQL and Microsoft Access
Wyniki nauki: Some of the basic and more advanced SQL commands here along with the concept of JOINS and sub-queries.
Omówione tematy:
-
Understanding SQL
-
Using the SELECT Statement
-
Using Subqueries
-
Using SQL Joins
MODUŁ 5: Macros and Visual Basic for Applications (VBA)
Wyniki nauki: Using Macros and Visual Basic to create some advanced functionality to your Access Database.
Omówione tematy:
-
Macro Basics
-
More about Macros
-
Access and VBA
-
Building Advanced Procedures
-
Using VBA in a Database
MODUŁ 6: Finishing the Application
Wyniki nauki: 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.
Omówione tematy:
-
Setting Start Up Options
-
Sharing/Splitting the Database
-
Creating an ACCDE
-
Encrypting the Database with a Password
Zostaw odpowiedź
Musisz Zaloguj sie lub Zarejestruj się dodać nowy komentarz .