RECORD MANAGEMENT CHP 6

DEFINE DATABASE :

• Holds data in the database. It is organized in fields and records

• A collection of related data stored on a computer system. It is organized for rapid

  search and retrieval of data. Microsoft Access is a popular database program

• All fields (set of field) in the table related to one thing, person, place, or

  organization

• One or more characters treated as a unit of information. As the examples are

  name, date or birth and age

DEFINE FIELD:

• All fields (set of field) in the table related to one thing, person, place, or

  organization

• A collection of related data stored on a computer system. It is organized for rapid

  search and retrieval of data. Microsoft Access is a popular database program

• One or more characters treated as a unit of information. As the examples are

  name, date or birth and age

• Holds data in the database. It is organized in fields and records

DEFINE TABLE :

• Sort results

• All fields (set of field) in the table related to one thing, person, place, or

  organization

• Products could be sorted by name, category (like pies, cakes, and cupcakes), or price.

• Holds data in the database. It is organized in fields and records

Which is the purpose for database queries and reports?

• Holds data in the database. It is organized in fields and records

• Look for data you specify

• Sort results

• Summarize data in a table or

  query

Which is the purpose for finding features?

• Summarize data in a table or

  query

• Looks for data you specify

• Have more advanced options than

  the Find Feature

• Looks in all or selected fields

Which is correct about how computers sort data?

• A computer performs sorting operations quickly and

  can store a great amount of data in a small space.

• Maintenance of records includes

  moving, copying and backing up files and folders.

• Character

  standard use numeric codes to represent symbols,

  numbers, and letters.

• Computers programs use character codes.

DEFINE ASCII (American Standard Code

for Information Interchange) :

• One or more characters treated as a unit of information. As the examples are

  name, date or birth and age

• A character code that was developed as a

  standard and logical way to recognize character

  data on computer

• Holds data in the database. It is organized in fields and records

• The

  life cycle of electronic records includes creation, use, storage and disposition for most

  business and government entities.

Which is correct about sort order for Microsoft excel?

• Sort sheet organizes all of the data in your worksheet by one column.

• Related information

  across each row is kept together when the sort is applied.

• The

  life cycle of electronic records includes creation, use, storage and disposition for most

  business and government entities.

• Electronic files are created in software programs and a unique

  filename is given to each file/record.

Which is correct for sort order in Microsoft Access?

• One or more characters treated as a unit of information. As the examples are

  name, date or birth and age

• Orders could be sorted by order date or by the last name of the customers who placed the

  orders.

• Customers could be sorted by name or by the city or zip code where they live.

• Products could be sorted by name, category (like pies, cakes, and cupcakes), or price.

ARRANGE THE CORRECT ORDERS OF ELECTRONIC RECORDS LIFE CYCLE :
I - Creation and Storage

II - Maintenance

III - Disposition

IV - Distribution and use

• I,III,IV,II

• I,II,III,IV

• IV,II,I,III

• I,IV,II,III