Students will learn how to use a variety of complex database techniques.
Lesson 1: Querying with SQL
SQL and Access
Writing SQL statements
Attaching SQL queries to controls
Lesson 2: Advanced queries
Creating crosstab queries
Creating parameter queries
Using action queries
Lesson 3: Macros
Creating, running, and modifying macros
Attaching macros to the events of database objects
Lesson 4: Advanced macros
Creating macros to provide user interaction
Creating macros that require user input
Creating the AutoKeys and AutoExec macros
Creating macros for data transfer
Lesson 5: Importing, exporting, and linking objects
Working with XML documents
Linking Access objects
Using hyperlink fields
Lesson 6: Database management
Setting options and properties
Access Level 2
or equivalent knowledge.
|Distance Learning price|
For other prices, please contact us.
Click here to see all our courses.