Comp Apps Access

50 terms by mtheisen

Create a new folder

Advertisement Upgrade to remove ads

an Access database object that allows you to arrange the fields of a record in any layout and which is used to enter, edit, and delete records

form

an Access object that provides an easy-to-use data entry screen

form

A calculated expression is most often placed in which report section?

group footer

a category of information in a table, such as a customer's name, city, or state

field

a collection of records for a single subject, such as all the customer records

table

a combination of field names, operator, and functions that result in a single value before and after the group of records

expression

controls placed here print once for every record in the underlying record source

detail selection

controls placed here print only once at the end of the printout

form footer section

created by entering an expression into a text box

calculated control

creates a datasheet of selected fields and records from one or more tables

query

creates a temporary subset of records

filter

criterion that finds all records where no entry has been made in the field

Is Null

determines where a control appears on the report and how often it prints

section

enhancing the appearance of information displayed in the report

formatting

Every element on a form is called a(n)

control

a group of related fields for one item, such as all the demographic information for one customer

record

limiting conditions used to narrow the number of records that appear in a datasheet

criteria

the lower pane in Query Design View

Query Grid

The most common bound control is the

text box

The most common unbound control is the

label

The object that contains all of the database data is the:

table

The object that creates a professional printout of data that includes headers, footers, and graphics is the:

report

prints once for every record

detail section

putting records in ascending or descending order based on the values of a field

sorting

A query is sometimes called a "logical view" of data because:

queries do not store data, they only display a view of the data

The rules by which criteria need to be entered in the query grid are referred to as:

syntax

rules that determine how criteria is entered

syntax

seven types of these are contained in an Access database and are used to enter, enhance, and use the data within the database

objects

a small pencil icon that appears in the record selector box

edit record symbol

sorting records plus providing a section

grouping

a spreadsheet-like grid that displays fields such as columns and records as rows

datasheet

SQL stands for which of the following?

Structured Query Language

To align the edges of several controls with respect to one another, you use the alignment commands on the:

arrange tab

used on a form to display data from a field

bound control

used to identify which fields and records are passed to the report

record source property

used to search for a pattern

Wildcard

the way the focus moves from one bound control to the next in Form View

tab order

What can you use to quickly create a new database?

template

when you enter a calculation in a text box, the first character is a(n):

equal sign

Which of the following cannot be changed in Print Preview?

font size

Which of the following describes OR criteria?

using two or more rows of the query grid to select only those records that meet given criteria

Which of the following is not an advantage of managing data with relational databse software such as Access versus spreadsheet software such as Excel?

uses a single table to store all data

Which of the following is not true about a query?

a query is the same thing as a filter

which of the following is probably not a graphic image?

calculation

Which of the following would be the appropriate expression to count the number of records using the FirstName field?

=Count([FirstName])

Which property helps you bind a text box to a field?

control source

Which type of control is most commonly placed in the detail section?

text box

Which type of control is most commonly placed in the Page Header section?

label

which view cannot be used to view data?

design

You press and hokd which key to select more than one control in Report Design View?

[shift]

Please allow access to your computer’s microphone to use Voice Recording.

Having trouble? Click here for help.

We can’t access your microphone!

Click the icon above to update your browser permissions above and try again

Example:

Reload the page to try again!

Reload

Press Cmd-0 to reset your zoom

Press Ctrl-0 to reset your zoom

It looks like your browser might be zoomed in or out. Your browser needs to be zoomed to a normal size to record audio.

Please upgrade Flash or install Chrome
to use Voice Recording.

For more help, see our troubleshooting page.

Your microphone is muted

For help fixing this issue, see this FAQ.

Star this term

You can study starred terms together

NEW! Voice Recording

Create Set