Query and manipulate a specific database.

Indicators for this outcome
(a) Determine the purpose of a specific database.
(b) Explain why the data were selected and entered in specific database.
(c) Explain the need for standardization in the naming of fields.
(d)

Query a specific database in order to display records that meet given criteria, following steps such as:

  • Filter and search records;
  • Construct and use select, parameter and action queries;
  • Add a calculated field to a query;
  • Perform calculations on a record grouping;
  • Design and produce reports to generate results as specified; and,
  • Format a report for printing.
(e) Create new fields based on existing fields in a specific database.
(f) Select additional data to be entered in a specific database.
(g) Add and organize data (e.g., divide into tables, define fields, enter records) in a database.
(h) Use consistent parameters (e.g., tags, terms, categories) when entering data in a database.
(i) Test the effectiveness of a database by performing operations (e.g., queries, filters, sorting) for purposes including functionality, presentation, and accessibility.
(j) Adjust parameters and organization of data to solve any errors or problems in the database.
Loading...