FREE AND STUDY GAMES ABOUT CGS 2100 ACCESS EXAM

PDF Download

FREE AND STUDY GAMES ABOUT CGS 2100 ACCESS EXAM

QUESTIONS

Actual Qs and Ans Expert-Verified Explanation

This Exam contains:

-Guarantee passing score -50 Questions and Answers -format set of multiple-choice -Expert-Verified Explanation

Question 1: record selector

Answer:

In a datasheet, the small square at the beginning of a row (also called the row selector) that you click to select the entire row. (AC 14)

Question 2: Report Wizard

Answer:

An Access tool that asks you a series of questions, and then creates a report based on your answers.

(AC 23)

Question 3: Datasheet view (for a table)

Answer:

The Access view that shows a table's contents as a datasheet in rows and columns. (AC 2)

Question 4: pencil symbol

Answer:

The symbol that appears in a row selector to indicate that the record is being edited. (AC 15)

Question 5: template

Answer:

A predefined database that includes professionally designed tables, forms, reports, and other objects.

(AC 7)

Question 6: All Access Objects

Answer:

The default category in the Navigation Pane; it lists all the objects in the database grouped by type (tables, queries, forms, reports, and so on). (AC 38)

Question 7: report

Answer:

A formatted printout (or screen display) of the contents of one or more tables or queries in a database.

(AC 23)

Question 8: Click to Add column

Answer:

In Datasheet view for a table, the datasheet column you can use to create a new field in the table. (AC 2)

Question 9: Text

Answer:

An Access data type that allows field values containing letters, digits, and other characters. (AC 11)

Question 10: data type

Answer:

The field property that determines what field values you can enter for the field and what other properties the field will have. (AC 11)

Question 11: Form Wizard

Answer:

An Access tool that asks you a series of questions, and then creates a form based on your answers.

(AC 22)

Question 12: ID column

Answer:

The default field Access creates to serve as the primary key field for all new tables. (AC 2)

Question 13: database management system (DBMS)

Answer:

A software program that lets you create databases and then manipulate data in them. (AC 6)

Question 14: Access

Answer:

A database program you use to enter, organize, display, and retrieve related information. (AC 1)

Question 15: AutoNumber

Answer:

An Access data type that automatically assigns a unique number to a record. (AC 11)

Question 16: relational database management system

Answer:

A software program in which data is organized as a collection of tables, and relationships between tables are formed through a common field. (AC 6)

Question 17: compacting

Answer:

A process that rearranges the data and objects in a database to decrease its file size, thereby making more space available on your disk and letting you open and close the database more quickly. (AC 38)

Question 18: Current Record box

Answer:

The box that appears at the bottom of a datasheet or form and that indicates the current record and total number of records displayed. (AC 20)

Question 19: Form tool

Answer:

An Access tool that creates a form containing all the fields in the table or query on which the form is based. (AC 22)

Question 20: Report tool

Answer:

An Access tool that places all the fields from a table or query on a report. (AC 23)

Question 21: Create tab

Answer:

A tab on the Ribbon that provides options for creating various database objects, including tables, forms, and reports. (AC 23)

Question 22: table

Answer:

A collection of fields that describe a person, place, object, event, or idea. (AC 4)

Question 23: Fields tab

Answer:

A tab on the Ribbon that provides options for adding, removing, and formatting the fields in a table. (AC 2)

Question 24: relational database, or database

Answer:

A collection of related tables stored in the same file. (AC 4)

Question 25: Add & Delete group

Answer:

A group on the Fields tab in Table Datasheet view that contains options for adding different types of fields to a table. (AC 2)

Question 26: field selector

Answer:

In a datasheet, the column heading (also called the column selector)that you click to select the entire column. (AC 14)

Question 27: Simple Query Wizard

Answer:

An Access wizard that lets you quickly select the records and fields to display in a query datasheet. (AC 22)