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, from Excel, and from a .CSV file; export objects from one active database to another Access
database; export and import XML documents; save objects as XPS files, link objects from one database to another and
update the links, and create hyperlink fields..
- 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.
|