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

Database Development and Use

Task Item

Know that different types of database models exist like: hierarchical, relational, object-oriented.

Know the life cycle stages of a database: logical design, database creation, data entry, data maintenance, information retrieval.

Recognize common business applications of databases like: dynamic website, customer relationship management systems, enterprise resource planning systems, website content management systems.

Know the term SQL (structured query language) and understand its main use in querying database content.

Category

Tables and Relationships

Skill Set

Fields/Columns

Task Item

Table

Form

Create, modify, deletea lookup in a field/column.

Create, modify, delete an input mask in a field/column.

Set data entry for a field/column: required, not required.

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.

Create, modify a subtract join.

Apply a self join.

Category

Queries

Skill Set

Query Types

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 crosstab query.

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

Create, modify, run a one, two variable parameter query.

Use wildcards in a query: [ ], !, -, #.

Show highest, lowest range of values in a query.

Create and name a calculated field that performs arithmetic operations.

Group information in a query using functions: sum, count, average, max, min.

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.

Modify sequential tab order of controls on a form.

Create, delete a linked subform.

Category

Reports

Skill Set

Controls

Task Item

Format arithmetic calculation controls in a report: percentage, currency, to a specific number of decimal places.

Apply a running sum for a group, over all.

Concatenate fields in a report.

Skill Set

Presentation

Task Item

Insert, delete a data field in group, page, report headers and footers.

Sort, group records in a report by field(s).

Force page breaks for groups in a report.

Create, delete a linked subreport.

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.

Skill Set

Automation

Task Item

Create a simple macro like: close an object and open another object,open and maximize an object, open and minimize an object, print and close an object.

Assign/attach a macro to a command button, object, control.