Course | September 5 | 1:30-4 p.m. | 239 Campus Shared Services (1608 4th Street, Berkeley)
This course details the process of designing Action Queries using a Microsoft Access database interface in order to manipulate values in local and external data sources. Emphasis is placed on Action Query types, Select Query conversion, and automation triggers of one or more sequential queries. Learning Objectives * Connect to local and external data sources. * Design Queries to manipulate record fields in local and external Tables. * Convert standard Select Queries into Action Queries. * Design Update Queries to perform mass record value edits. * Design Append Queries to replicate specified records between two or more Tables. * Design Delete Queries to permanently delete Table records using static and dynamic criteria. * Design Make Table Queries to capture mass record snapshots as new database objects. * Isolate and replicate unique records using Make Table Queries. * Automate Action Queries using Macro Objects. * Analyze Structured Query Language of Action Queries to identify action-specific SQL keywords.