# CTE Resource Center - Verso - Computer Information Systems, Advanced Task 1967260418

CTE Resource Center - Verso

Virginia’s CTE Resource Center

Plan, design, and create a database file with advanced features.

Definition

Planning a database includes examining requirements such as

  • people and systems that will use the database
  • type of data (e.g., text, numbers, dates)
  • amount of data
  • size of data elements.

Designing a database should include determining how the data will be

  • obtained
  • entered
  • manipulated
  • retrieved.

Creating a database should include

  • opening a new file in a database program
  • creating and configuring the forms, fields, and tables
  • entering data
  • saving the database file.

Advanced features of a database may include

  • type of data (e.g., text, numbers, dates)
  • size of data elements
  • manipulation of data
  • retrieval of data
  • creation and configuration of forms, fields, queries, reports, and tables
  • creation of fields that require calculation.

Related Standards of Learning

Mathematics

COM.10

The student will design and implement the input phase of a program, which will include designing screen layout, getting information into the program by way of user interaction and/or file input, and validating input.

Other Related Standards

FBLA Competitive Events and Activities Areas

Computer Applications

 

Database Design & Applications

 

Microsoft Office Specialist Excel and Word

 

Spreadsheet Applications