Common Planner
K–12 Standards

Advanced Database: Grades 10, 11, 12

Other Arkansas CTE sets

Introduction to Relational Databases and Database Careers

  • 1.1

    Define terminology

    1. 1.

      Prepare a list of terms with definitions1.1.1

  • 1.2

    Explain the purpose of a relational database

    1. 1.

      Explain how a database is relational1.2.1

  • 1.3

    Explain the hierarchy of data

    1. 1.

      Explore an existing database identifying the file, record, field, and entry1.3.1

  • 1.4

    Explain relational database system DBMS

    1. 1.

      Identify advantages of a relational database system DBMS1.4.1

  • 1.5

    Identify the basic objects

    1. 1.

      List the basic objects (table, report, form, query)1.5.1

  • 1.6

    Explain two database management tasks

    1. 1.

      Compact and back up a database1.6.1

  • 1.7

    Explain why you may want to create and use a trusted folder

    1. 1.

      Create a trusted folder1.7.1

  • 1.8

    Discuss careers involving databases

    1. 1.

      Research various database careers1.8.1

Building a Relational Database and Defining Table Relationships

  • 2.1

    Define terminology

    1. 1.

      Prepare a list of terms with definitions2.1.1

  • 2.2

    Discuss the guidelines for designing databases

    1. 1.

      Explore an existing database discussing the following guidelines:<ul><li>Identify all the fields needed to produce the required information</li><li>Organize each piece of data into its smallest useful part</li><li>Determine each table's primary key</li><li>Include a common field in related tables</li><li>Avoid data redundancy</li><li>Determine the properties of each field</li></ul>2.2.1

  • 2.3

    Describe how to create a table

    1. 1.

      Create a table naming fields, assigning data types and setting field size properties2.3.1

  • 2.4

    Explain primary key

    1. 1.

      Set, change or remove primary keys2.4.1

  • 2.5

    Identify ways to enhance and improve a table design

    1. 1.

      Enhance a table by using some of the following features:<ul><li>Set a default value</li><li>Add an input mask</li><li>Create a lookup field</li><li>Set a required field</li><li>Add a validation rule and text</li></ul>2.5.1

  • 2.6

    Explain how to define table relationships

    1. 1.

      Create joins using primary tables, related tables, and common fields2.6.1

  • 2.7

    Compare/Contrast different types of relationships

    1. 1.

      Create a one-to-one or one-to-many or many-to-many relationship2.7.1

  • 2.8

    Explain the concept of referential integrity and cascade update/delete

    1. 1.

      Create a relationship adding referential2.8.1

Maintaining and Formatting Tables in a Database

  • 3.1

    Define terminology

    1. 1.

      Prepare a list of terms with definitions3.1.1

  • 3.2

    Explain how to modify records in a table

    1. 1.

      Enter, edit, and delete records3.2.1

  • 3.3

    Explain the importance of the Find command

    1. 1.

      Use the Find command3.3.1

  • 3.4

    Describe how to sort records

    1. 1.

      Sort records in ascending and descending order3.4.1

  • 3.5

    Explain how to filter records

    1. 1.

      Filter records using Filter by Form and Filter by Selection3.5.1

    2. 2.

      Filter records using an advanced filter3.5.2

  • 3.6

    Identify wildcards

    1. 1.

      Use wildcards in a database (#, ?, *)3.6.1

Creating Simple Queries

  • 4.1

    Define terminology

    1. 1.

      Prepare a list of terms with definitions4.1.1

  • 4.2

    Explain the purpose of a query

    1. 1.

      Create a simple query4.2.1

  • 4.3

    Explain how to create a select query

    1. 1.

      Create and run a select query using various criteria4.3.1

  • 4.4

    Explain how to create a multitable query

    1. 1.

      Create and run a multitable query4.4.1

  • 4.5

    Describe how to create queries using various comparison operators

    1. 1.

      Create queries using various comparison operators (=, <, >, <=, >=, <>, Between…And…, In (), Like)4.5.1

  • 4.6

    Describe how to create queries using various logical operators

    1. 1.

      Create queries using AND, OR, or NOT4.6.1

  • 4.7

    Identify reasons for a calculated field

    1. 1.

      Write a formula for a calculated field4.7.1

  • 4.8

    Describe how to create queries with an aggregate function

    1. 1.

      Create a query with an aggregate function4.8.1

    2. 2.

      Add a Group By to an aggregate function4.8.2

Create Simple Forms and Reports

  • 5.1

    Define terminology

    1. 1.

      Prepare a list of terms with definitions5.1.1

  • 5.2

    Explain how to create a form

    1. 1.

      Create a form5.2.1

  • 5.3

    Identify ways to modify and format a form

    1. 1.

      Modify and format a form5.3.1

  • 5.4

    Explain the steps necessary to create a main form with a subform

    1. 1.

      Create a main form with a subform5.4.1

  • 5.5

    Explain how to navigate through a form

    1. 1.

      Navigate through fields and records in a form5.5.1

    2. 2.

      Navigate through fields and records in a main form and subform5.5.2

  • 5.6

    Explain how to create, format, and modify a report

    1. 1.

      Create a report5.6.1

    2. 2.

      Modify and format a report5.6.2

  • 5.7

    Identify different types of conditional formatting

    1. 1.

      Apply conditional formatting to a report5.7.1

  • 5.8

    Explain how to print forms and reports

    1. 1.

      Print various forms5.8.1

    2. 2.

      Print various reports5.8.2

Creating Advanced Queries

  • 6.1

    Define terminology

    1. 1.

      Prepare a list of terms with definitions6.1.1

  • 6.2

    Explain how to create a parameter query

    1. 1.

      Create a parameter query6.2.1

  • 6.3

    Explain how to create a crosstab query

    1. 1.

      Create a crosstab query6.3.1

  • 6.4

    Explain how to create a find duplicates query

    1. 1.

      Create a find duplicates query6.4.1

  • 6.5

    Explain how to create a find unmatched query

    1. 1.

      Create a find unmatched query6.5.1

  • 6.6

    Describe the steps in creating a top values query

    1. 1.

      Create a top values query6.6.1

  • 6.7

    Explain reasons for creating a concantenation

    1. 1.

      Create a concantenated expression using the fields and the & (ampersand)6.7.1

  • 6.8

    Explain the purpose of an action query

    1. 1.

      Create the following action queries: make-table, append, delete, and update6.8.1

  • 6.9

    Explain the reason for an index

    1. 1.

      Create an index6.9.1

Creating Custom Forms

  • 7.1

    Define terminology

    1. 1.

      Prepare a list of terms with definitions7.1.1

  • 7.2

    Explain how to create a form using various tools

    1. 1.

      Create a form using the Datasheet tool, Multiple Items tool, and Split Form tool7.2.1

  • 7.3

    Compare/Contrast the three types of controls

    1. 1.

      Explore an existing form and identify the bound, unbound and calculated control7.3.1

  • 7.4

    Explain how to create a custom form

    1. 1.

      Create a custom form with some of the following: form header, footer, title, logo, label, etc.7.4.1

  • 7.5

    Discuss advantages of creating a main form and subform

    1. 1.

      Create a main form with a subform7.5.1

  • 7.6

    Identify how to change the tab order

    1. 1.

      Change the tab order in a form7.6.1

  • 7.7

    Discuss ways to enhance the visual effects of a form

    1. 1.

      Add some of these visual effects to a form: lines, rectangle, special effect properties, backgrounds, logo, etc7.7.1

Creating Custom Reports

  • 8.1

    Define terminology

    1. 1.

      Prepare a list of terms with definitions8.1.1

  • 8.2

    Explain how to modify and

    1. 1.

      Modify a report adding some of these features: grouping and sorting, totals, backgrounds, lines, logos, etc.8.2.1

  • 8.3

    Explain how to create a custom report

    1. 1.

      Create a custom report with some of these features: report header/footer, page header/footer, group header/footer, dates, page numbers, titles, lines, etc.8.3.1

  • 8.4

    Explain grouping and sorting of data in a report

    1. 1.

      Add grouping and sorting to a report8.4.1

    2. 2.

      Apply the keep together property to a report8.4.2

  • 8.5

    Explain the purpose of the hiding duplicate values property

    1. 1.

      Hide duplicate values in a report8.5.1

  • 8.6

    Explain how to create mailing labels

    1. 1.

      Create mailing labels8.6.1

Sharing, Integrating, Analyzing and Managing

  • 9.1

    Define terminology

    1. 1.

      Prepare a list of terms with definitions9.1.1

  • 9.2

    Discuss various ways to export

    1. 1.

      Export data from some of the following formats: HTML document, XML, etc.9.2.1

  • 9.3

    Discuss various ways to import

    1. 1.

      Import data from some of the following formats: CSV, text file, XML, etc.9.3.1

  • 9.4

    Identify ways to save database objects as other file types

    1. 1.

      Save database objects as other file types9.4.1

  • 9.5

    Explain Analyzer tools

    1. 1.

      Use the Analyzer9.5.1

  • 9.6

    Explain how to embed or link various objects in a form

    1. 1.

      Add and modify some of these to a form: a chart, pivot chart/table, link data from a worksheet, link to a table in another database9.6.1

  • 9.7

    Explain how to create an attachment field

    1. 1.

      Attach documents to and detach from records9.7.1

  • 9.8

    Discuss reasons to split a database

    1. 1.

      Use the splitter9.8.1

Macros and Switchboards

  • 10.1

    Define terminology

    1. 1.

      Prepare a list of terms with definitions10.1.1

  • 10.2

    Explain the purpose of a switchboard

    1. 1.

      Create a switchboard10.2.1

  • 10.3

    Explain the purpose of a macro

    1. 1.

      Create a macro10.3.1

  • 10.4

    Identify reasons to make a macro group

    1. 1.

      Create a macro group10.4.1

  • 10.5

    Explain the process of adding a command button to a form or report

    1. 1.

      Add a command button to a form or report10.5.1

    2. 2.

      Add a command button to a form and assign it to a macro10.5.2

Intro to SQL--Recommended by not required

  • 11.1

    Define terminology

    1. 1.

      Prepare a list of terms with definitions11.1.1

  • 11.2

    Describe briefly the history of SQL

    1. 1.

      Discuss the history of SQL11.2.1

  • 11.3

    Explain how to layout and create a table in SQL

    1. 1.

      Use the CREATE TABLE command11.3.1

  • 11.4

    Explain how to delete a table using SQL

    1. 1.

      Use the DROP TABLE command11.4.1

  • 11.5

    Explain how to add and modify records using SQL

    1. 1.

      Use the INSERT INTO command11.5.1

    2. 2.

      Use the UPDATE command11.5.2

  • 11.6

    Explain how to query a database using SQL

    1. 1.

      Use the SELECT command with various operators and clauses11.6.1

  • 11.7

    Explain how to sort a database in SQL

    1. 1.

      Use the ORDER BY command to sort in ascending and descending order11.7.1

Frequently asked questions

What grade levels do these standards cover?
Grade 10, Grade 11, and Grade 12
When were these standards adopted?
2009
Where can I read the official document?
Advanced Database

Keep exploring

Keep exploring CTE standards

Sibling grade bands, other subjects in this jurisdiction, and the same subject across other states.

More Arkansas CTE sets

CTE