CGS 1060 Study Guide Final with
Complete Solutions
(Access) A ______ can be used to add a custom error message for users when they
enter an invalid entry for a data field. - ANSWER-Field Validation Text
(Access) A database object that summarizes the fields and records from a table in an
attractive, easy-to-read format is a: - ANSWER-report
(Access) A single field in a table can have more than one data type defined. -
ANSWER-False
(Access) A(n) ____ is a combination of literal and mask characters that specifies the
format that Access allows users to use when inputting data into a field in a table and is
useful for inputting such things as telephone numbers and social security numbers. -
ANSWER-input mask
(Access) By default, Access 2016 saves your file in what format? - ANSWER-ACCDB
(Access) By indexing a field, Access can - ANSWER-speed up searching and sorting
records in the table
(Access) Each individual chunk of data that collectively make up a record in a database
is called a: - ANSWER-field
(Access) Each of the following is an Access data type, EXCEPT: - ANSWER-Data
(Access) Each row in a table contains a(n): - ANSWER-record
(Access) Each row in an Access table contains a(n) _____ which consists of multiple
fields of information. - ANSWER-record
(Access) If a relationship is established between two tables they will share a common: -
ANSWER-field
(Access) If there is important calculated data being stored in a field that you do not want
displayed to the user, then you may choose to: - ANSWER-hide the field
(Access) If you want to sort a table by the price field with the highest prices coming first,
you should sort on the: - ANSWER-price field in descending order
(Access) In order to restrict the data that is inputted into a field, Access can use -
ANSWER-data validation rules
,(Access) Information in a database is typically stored in this, which consists of vertical
columns and horizontal rows. - ANSWER-Table
(Access) RDBMS is an acronym for: - ANSWER-relational database management
system
(Access) Since each Social Security Number is unique per person, in the past many
companies and organizations used it as a _____ field to uniquely identify their patients,
employees, and so on. - ANSWER-Primary key
(Access) Suppose you want to view only the records in a table that have a value of "FL"
in the state field. What can you do to quickly display only those records that meet that
criteria? - ANSWER-filter the table on the state field
(Access) The ______ of a field tells Access what kind of data may be stored in the field.
- ANSWER-data type
(Access) The 348 exchange has been moved to the 704 area code. To quickly update
the telephone number field of all the records in a table, use this feature in Access. -
ANSWER-Find and Replace
(Access) The data type for a telephone number field is: - ANSWER-Short Text
(Access) The data type of an item price, such as $10.50 is : - ANSWER-Currency
(Access) The field that uniquely identifies each record in a table is called a: - ANSWER-
primary key
(Access) The main purpose of a form is to: - ANSWER-view and enter data into tables.
(Access) The purpose of a query is to: - ANSWER-ask questions and display specific
data from a table.
(Access) This data type is used to store up to 255 alphanumeric characters, spaces,
and symbols. - ANSWER-Short Text
(Access) To quickly rearrange a table's records, you can do this to the table data. -
ANSWER-Sort
(Access) When designing a table, each field must have a defined ______ which
identifies the kind of data that may be stored in that field. - ANSWER-data type
(Access) Which of the following views in Microsoft Access is used for changing the
design and structure of tables? - ANSWER-Design view
, (Access) Which of the following views in Microsoft Access is used for entering actual
data into records? - ANSWER-Datasheet view
(Excel) ____________ is the process of changing the appearance of cells and the
overall layout of the worksheet. - ANSWER-Formatting
(Excel) ____________ is used to copy the formatting of one cell to other cells. -
ANSWER-Format Painter
(Excel) A new Blank Workbook in Excel 2016 contains one worksheet named: -
ANSWER-Sheet1
(Excel) A rectangular block of adjoining cells, for example A5:E5, is referred to as a cell
____ . - ANSWER-range
(Excel) All formulas begin with the ____________ sign. - ANSWER-= (equal)
(Excel) An Excel file is referred to as a: - ANSWER-workbook
(Excel) An Excel workbook can consist of multiple _______ or "pages" each referenced
by a tab at the bottom of the Excel program window. - ANSWER-worksheets
(Excel) Applying Excel's Percent Style number format to the decimal value 0.17 will
result in which of the following being displayed in the cell? - ANSWER-17%
(Excel) By clicking the File tab from the Excel ribbon, you have entered the _________
view. - ANSWER-Backstage
(Excel) By default, textual data is ____ aligned within Excel cells. - ANSWER-left
(Excel) Cell ________ such as Heading and Title allow you to apply multiple formats to
a cell at once. - ANSWER-styles
(Excel) Combining two or more cells into a single cell creates a: - ANSWER-merged cell
(Excel) Copying the formula =A1*B1 from cell C1 to cell C2 would yield which of the
following formulas in cell C2? - ANSWER-=A2*B2
(Excel) Excel 2016 files have names that end with a default file extension of ____ . -
ANSWER-.xlsx
(Excel) Excel's prewritten formulas such as =SUM() or =AVERAGE() are normally
referred to as: - ANSWER-functions
(Excel) Flash Fill is: - ANSWER-an Excel tool that automatically completes the data
being inserted, following a pattern it recognizes in the data.
Complete Solutions
(Access) A ______ can be used to add a custom error message for users when they
enter an invalid entry for a data field. - ANSWER-Field Validation Text
(Access) A database object that summarizes the fields and records from a table in an
attractive, easy-to-read format is a: - ANSWER-report
(Access) A single field in a table can have more than one data type defined. -
ANSWER-False
(Access) A(n) ____ is a combination of literal and mask characters that specifies the
format that Access allows users to use when inputting data into a field in a table and is
useful for inputting such things as telephone numbers and social security numbers. -
ANSWER-input mask
(Access) By default, Access 2016 saves your file in what format? - ANSWER-ACCDB
(Access) By indexing a field, Access can - ANSWER-speed up searching and sorting
records in the table
(Access) Each individual chunk of data that collectively make up a record in a database
is called a: - ANSWER-field
(Access) Each of the following is an Access data type, EXCEPT: - ANSWER-Data
(Access) Each row in a table contains a(n): - ANSWER-record
(Access) Each row in an Access table contains a(n) _____ which consists of multiple
fields of information. - ANSWER-record
(Access) If a relationship is established between two tables they will share a common: -
ANSWER-field
(Access) If there is important calculated data being stored in a field that you do not want
displayed to the user, then you may choose to: - ANSWER-hide the field
(Access) If you want to sort a table by the price field with the highest prices coming first,
you should sort on the: - ANSWER-price field in descending order
(Access) In order to restrict the data that is inputted into a field, Access can use -
ANSWER-data validation rules
,(Access) Information in a database is typically stored in this, which consists of vertical
columns and horizontal rows. - ANSWER-Table
(Access) RDBMS is an acronym for: - ANSWER-relational database management
system
(Access) Since each Social Security Number is unique per person, in the past many
companies and organizations used it as a _____ field to uniquely identify their patients,
employees, and so on. - ANSWER-Primary key
(Access) Suppose you want to view only the records in a table that have a value of "FL"
in the state field. What can you do to quickly display only those records that meet that
criteria? - ANSWER-filter the table on the state field
(Access) The ______ of a field tells Access what kind of data may be stored in the field.
- ANSWER-data type
(Access) The 348 exchange has been moved to the 704 area code. To quickly update
the telephone number field of all the records in a table, use this feature in Access. -
ANSWER-Find and Replace
(Access) The data type for a telephone number field is: - ANSWER-Short Text
(Access) The data type of an item price, such as $10.50 is : - ANSWER-Currency
(Access) The field that uniquely identifies each record in a table is called a: - ANSWER-
primary key
(Access) The main purpose of a form is to: - ANSWER-view and enter data into tables.
(Access) The purpose of a query is to: - ANSWER-ask questions and display specific
data from a table.
(Access) This data type is used to store up to 255 alphanumeric characters, spaces,
and symbols. - ANSWER-Short Text
(Access) To quickly rearrange a table's records, you can do this to the table data. -
ANSWER-Sort
(Access) When designing a table, each field must have a defined ______ which
identifies the kind of data that may be stored in that field. - ANSWER-data type
(Access) Which of the following views in Microsoft Access is used for changing the
design and structure of tables? - ANSWER-Design view
, (Access) Which of the following views in Microsoft Access is used for entering actual
data into records? - ANSWER-Datasheet view
(Excel) ____________ is the process of changing the appearance of cells and the
overall layout of the worksheet. - ANSWER-Formatting
(Excel) ____________ is used to copy the formatting of one cell to other cells. -
ANSWER-Format Painter
(Excel) A new Blank Workbook in Excel 2016 contains one worksheet named: -
ANSWER-Sheet1
(Excel) A rectangular block of adjoining cells, for example A5:E5, is referred to as a cell
____ . - ANSWER-range
(Excel) All formulas begin with the ____________ sign. - ANSWER-= (equal)
(Excel) An Excel file is referred to as a: - ANSWER-workbook
(Excel) An Excel workbook can consist of multiple _______ or "pages" each referenced
by a tab at the bottom of the Excel program window. - ANSWER-worksheets
(Excel) Applying Excel's Percent Style number format to the decimal value 0.17 will
result in which of the following being displayed in the cell? - ANSWER-17%
(Excel) By clicking the File tab from the Excel ribbon, you have entered the _________
view. - ANSWER-Backstage
(Excel) By default, textual data is ____ aligned within Excel cells. - ANSWER-left
(Excel) Cell ________ such as Heading and Title allow you to apply multiple formats to
a cell at once. - ANSWER-styles
(Excel) Combining two or more cells into a single cell creates a: - ANSWER-merged cell
(Excel) Copying the formula =A1*B1 from cell C1 to cell C2 would yield which of the
following formulas in cell C2? - ANSWER-=A2*B2
(Excel) Excel 2016 files have names that end with a default file extension of ____ . -
ANSWER-.xlsx
(Excel) Excel's prewritten formulas such as =SUM() or =AVERAGE() are normally
referred to as: - ANSWER-functions
(Excel) Flash Fill is: - ANSWER-an Excel tool that automatically completes the data
being inserted, following a pattern it recognizes in the data.
