Microsoft Office 2007 will be used in this course.Learn how to query with SQL; use crosstab, parameter and action queries; create and run macros; import, export and link database objects; optimize, replicate and synchronize databases; maintain database security.  

• Use and write SQL statements to create queries, 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
• 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 and export Access databases
• Link objects from one database to another and update the links
• Split, compact, repair and back up a database; encrypt and password-protect database files
• Create and modify hyperlink fields