Access Test Concepts

Lakukan tugas rumah & ujian kamu dengan baik sekarang menggunakan Quizwiz!

False

(T/F) AutoFilter by Selection settings are saved with the database object.

True

(T/F) to limit query results to only records that meet all the criteria, enter criteria for multiple fields on the Criteria row, or enter multiple criteria for the same field separated by the word And

2 tables w/ referential integrity enforced

-you cannot add a record to the secondary table w/out an associated record in the primary table -you cannot make changes to the primary table that would cause records in the secondary table to become unmatched

True

A stacked layout places labels across the top, with columns of data (similar to a data sheet or a spreadsheet). (T/F)

be unique for every field

A table's primary key must...

Stores each unique piece of data in only one table

A well-designed database...

Table

All data entered into a form are stored in the underlying...

File

Click this tab to display Backstage view.

False

Creating a backup of the database removes unnecessary file space and hidden, temporary objects from your database. (T/F)

Record

Each row in a table contains all the data for a single...

report footer section

Grand totals in a report are added to where?

False

If you have downloaded a file from the Internet and it opens in Protected View, you should never open the file. (T/F)

Excel

Microsoft _____ is a spreadsheet program.

False

Page numbers can only be added to a footer section. (T/F)

False

The upper pane in query Design view shows the query grid where you specify which fields to include in the query. (T/F)

Split form

This combines the convenience of a continuous Datasheet form with the usability of a Single Record form displaying one record at a time.

Quick Access Toolbar

This gives you quick one-click access to common commands and is located at the top of the application window above the File tab.

Subform

This is a form within a form that displays records related to the record in the main form.

Ribbon

This is located across the top of the application window and organizes common features and commands into tabs.

File properties

This provides information about a file such as the location of the file, the size of file, when the file was created and when it was last modified, the title, and the author.

Right-click

To display a shortcut menu you _______ an area of the file

ctrl + v

To paste an item from the Clipboard, use this keyboard shortcut..

False

To rename a database object, double-click the name in the Navigation Pane and type the new name. (T/F)

True

Users can enter and edit data in an AutoNumber field. (T/F)

Undo the entire record at once

When you are entering data in a new record in a form, the Undo command will...

True

When you save files to your SkyDrive, they are available to access from other computers that have SkyDrive capability. If you are working on an Excel or Word file, others can be working on the same file at the same time you are working on the file. (T/F)

Account

You can change user information from the _____ page in Backstage view.

PDF

You can export Access data to which file format?

False

You can undo a record deletion (T/F)

False

You must manually save the record each time you enter data in a table or form (T/F)

forces users to input data in a consistent format

an input mask...

Calculated

an unbound text box control that contains an expression (formula) is called a _________ control.

criteria

are conditions that the records must meet in order to be included in the query results.

Tables

are the basic building blocks of a database

Field

each column in a table represents a specific data value called a...

not equal to 80

entering <>80 as the criteria for a query will return results that are...

find duplicate query

if you want to create a query that shows records from one table that have no corresponding records in another table, you use this...

True

the Currency field format is the same as the Currency data type (T/F)

False

the Percent field format displays the % symbol in the data table. (T/F)

Page numbers

this design element is not available in forms

calculated field

this display a value returned by an expression

select query

this displays data from one or more tables or queries, based on the fields that you select

bound

this text control displays data from a field.

orientation

to change the direction a report prints on the page, you will change the page to?

the Field Size property

to control the number of characters a user can enter into a table field, use what?

attachment

to include a photo image with each record in a table, use a field with this data type:

double-click the column header, and type the new field name

to rename a field...

parameter query

when you create this, you specify the field or fields that the query will use, but you don't specify the exact criteria.

field list pane

you click and drag fields from this to add controls to a blank report.


Set pelajaran terkait

Part 1: Germinal vs. Somatic mutations

View Set

AP Gov/Econ - Economics (Chapter Six)

View Set

Word Within the Word Lists #31-35

View Set

Text Structures in Wheels of Change, Part 2

View Set

American History Unit 4 imperialism questions

View Set