Create business applications without programming

Using Microsoft Access 2007, hands-on examples show you how to: writing SQL statements to create queries, and using crosstab, parameter, and action queries.  Also, creating and running macros to automate tasks and attaching macros to events of database objects. Importing, exporting, and linking database objects will be covered too. In addition, optimizing databases; and basic database security.

Prerequisite: Access: Intermediate

Key Topics Covered

1) Use SQL statements and examine them in Access.
2) Write SQL statements to create queries.
3) Attach an SQL statement to a command button.
4) Create crosstab, parameter, and action queries.
5) Create and run macros to automate tasks and attach macros to the events to database objects.
6) Create data validation and data entry macros.
7) Create macros that run parameter queries.
8) Create the AutoKeys and AutoExec macros.
9) Create macros to import and export database objects.
10) Import objects into an active database, export objects from a database.
11) Link and update database objects.
12) Work with database utilities to optimize resources.
13) Use a password to secure database.