Advanced Database teach the student to understand key database concepts and use a relational database application to create a database structure and outputs as well as understand key concepts of database development and usage.
Category
Database Concepts
Skill Set
Task Item
Know that different types of database models exist like: hierarchical, relational, object-oriented.
Recognize common business applications of databases like: dynamic website, customer relationship management systems, enterprise resource planning systems, website content management systems.
Category
Tables and Relationships
Skill Set
Fields/Columns
Skill Set
Relationships and Joins
Task Item
Create, modify, delete a one-to-one, one-to-many relationship between tables.
Create, modify a many-to-many relationship using a junction table.
Apply referential integrity between tables.
Apply automatic update of related fields.
Apply automatic deletion of related records.
Apply, modify an inner join, outer join.
Category
Queries
Skill Set
Task Item
Create, run a query to update data in a table.
Create, run a query to add records to a table.
Create, run a query to append records to a table.
Apply, remove bound control properties like: limit to list, distinct values.
Create, run a query to delete records in a table.
Create, run a query to save selected data as a new table.
Create, run a query to show duplicated records within a table.
Create, run a query to show unmatched records in related tables.
Skill Set
Refining a Query
Task Item
Category
Forms
Skill Set
Controls
Task Item
Create, modify, delete bound controls: text box, combo box, list box, check box, option groups.
Apply, remove bound control properties like: limit to list, distinct values.
Create, modify, delete unbound controls containing arithmetic, logical expressions.
Category
Reports
Skill Set
Controls
Skill Set
Presentation
Task Item
Category
Enhancing Productivity
Skill Set
Linking, Importing
Task Item
Link external data to a database: spreadsheet, text (.txt, .csv), existing database files.
Import spreadsheet, text (.txt, .csv), XML, existing database files into a database.