Most organizations depend on databases for delivery of goods and services, allocation of
resources, and support of management decision making and policy analysis. Policy analysts
and managers also find database packages like Microsoft Access valuable for personal use,
especially in getting data ready for use.
Formulate basic and advanced relational database queries using a query tool such as
Access’s Query by Example.
Create database queries using Structured Query Language (SQL)
Describe the rationale for the basic design principals of relational databases such as
referential integrity and foreign keys.
Interpret an entity relationship diagram for an existing relational database including
participation and cardinality.
Create an entity relationship diagram based on an organization’s data and business
Create a physical relational database design based on an entity relationship diagram.
Design and implement simple customized database user interfaces including forms and
reports using a development tool.
Use macros to automate the use of Access and Excel for data analysis.