After completing this course, students will know how to:
- Use SQL statements and examine them in Access, write SQL
statements to create queries, and attach an SQL statement to a command button.
- Create crosstab queries to summarize grouped data, create
parameter queries to view results based on specified criteria, and create action queries
to add, delete, and modify data in tables and to create new tables.
- Create and run macros to automate tasks and attach macros to
the events of database objects.
- Create data validation and data-entry macros, create macros
that run parameter queries, create the AutoKeys and AutoExec macros, and create macros to
import and export database objects.
- Import Access objects into an active database from another
Access database and from Excel, export objects from one active database to another Access
database, export and import XML documents, link objects from one database to another and
update the links, and export and import tables and queries to the Windows SharePoint
Services site.
- Work with database utilities to optimize resources and
replicate and synchronize a database.
- Use a password to secure database files, encrypt and decrypt
databases, and set specific permissions for users to secure database objects.
|