logo image

Comp Apps Access

used on a form to display data from a field
bound control
created by entering an expression into a text box
calculated control
controls placed here print once for every record in the underlying record source
detail selection
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
the way the focus moves from one bound control to the next in Form View
tab order
controls placed here print only once at the end of the printout
form footer section
Every element on a form is called a(n)
control
which of the following is probably not a graphic image?
calculation
The most common bound control is the
text box
The most common unbound control is the
label
which view cannot be used to view data?
design
Which property helps you bind a text box to a field?
control source
when you enter a calculation in a text box, the first character is a(n):
equal sign
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 collection of records for a single subject, such as all the customer records
table
a group of related fields for one item, such as all the demographic information for one customer
record
a category of information in a table, such as a customer’s name, city, or state
field
a spreadsheet-like grid that displays fields such as columns and records as rows
datasheet
an Access object that provides an easy-to-use data entry screen
form
a small pencil icon that appears in the record selector box
edit record symbol
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
The object that creates a professional printout of data that includes headers, footers, and graphics is the:
report
The object that contains all of the database data is the:
table
What can you use to quickly create a new database?
template
a combination of field names, operator, and functions that result in a single value before and after the group of records
expression
determines where a control appears on the report and how often it prints
section
prints once for every record
detail section
used to identify which fields and records are passed to the report
record source property
enhancing the appearance of information displayed in the report
formatting
sorting records plus providing a section
grouping
You press and hokd which key to select more than one control in Report Design View?
[shift]
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
A calculated expression is most often placed in which report section?
group footer
Which of the following would be the appropriate expression to count the number of records using the FirstName field?
=Count([FirstName])
To align the edges of several controls with respect to one another, you use the alignment commands on the:
arrange tab
Which of the following cannot be changed in Print Preview?
font size
the lower pane in Query Design View
Query Grid
limiting conditions used to narrow the number of records that appear in a datasheet
criteria
creates a temporary subset of records
filter
rules that determine how criteria is entered
syntax
creates a datasheet of selected fields and records from one or more tables
query
putting records in ascending or descending order based on the values of a field
sorting
used to search for a pattern
Wildcard
criterion that finds all records where no entry has been made in the field
Is Null
The rules by which criteria need to be entered in the query grid are referred to as:
syntax
SQL stands for which of the following?
Structured Query Language
A query is sometimes called a “logical view” of data because:
queries do not store data, they only display a view of the data
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 true about a query?
a query is the same thing as a filter

Need essay sample on "Comp Apps Access"? We will write a custom essay sample specifically for you for only $ 13.90/page

Can’t wait to take that assignment burden offyour shoulders?

Let us know what it is and we will show you how it can be done!
×
Sorry, but copying text is forbidden on this website. If you need this or any other sample, please register

Already on Businessays? Login here

No, thanks. I prefer suffering on my own
Sorry, but copying text is forbidden on this website. If you need this or any other sample register now and get a free access to all papers, carefully proofread and edited by our experts.
Sign in / Sign up
No, thanks. I prefer suffering on my own
Not quite the topic you need?
We would be happy to write it
Join and witness the magic
Service Open At All Times
|
Complete Buyer Protection
|
Plagiarism-Free Writing

Emily from Businessays

Hi there, would you like to get such a paper? How about receiving a customized one? Check it out https://goo.gl/chNgQy