Find study materials for any course. Check these out:
Browse by school
Make your own
To login with Google, please enable popups
To login with Google, please enable popups
Don’t have an account?
To signup with Google, please enable popups
To signup with Google, please enable popups
Sign up withor
The main purpose of a form is to:
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.
Each individual chunk of data that collectively make up a record in a database is called a:
If a relationship is established between two tables they will share a common:
The field that uniquely identifies each record in a table is called a:
RDBMS is an acronym for:
relational database management system
The purpose of a query is to:
ask questions and display specific data from a table.
Which of the following views in Microsoft Access is used for changing the design and structure of tables?
When designing a table, each field must have a defined ______ which identifies the kind of data that may be stored in that field.
Information in a database is typically stored in this, which consists of vertical columns and horizontal rows.
A database object that summarizes the fields and records from a table in an attractive, easy-to-read format is a:
Which of the following views in Microsoft Access is used for entering actual data into records?
(Access) When referring to external sources of data, which Microsoft Access method, importing or linking, will allow changes to data from another application to automatically be reflected in the Access database tied to it?
(Access) This data type is used to store up to 255 alphanumeric characters, spaces, and symbols
(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.
Find and Replace
(Access) Each row in a table contains a(n):
(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:
hide the field
(Access) A single field in a table can have more than one data type defined.
(Access) To quickly rearrange a table's records, you can do this to the table data.
(Access) If you want to sort a table by the price field with the highest prices coming first, you should sort on the:
price field in descending order
(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.
(Access) Formatting the appearance of the table will not change the data, just the way you're looking at it. True or False?
(Access) A ______ can be used to add a custom error message for users when they enter an invalid entry for a data field.
(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?
filter the table on the state field
(Access) By indexing a field, Access can
speed up searching and sorting records in the table
(Access) The data type for a telephone number field is:
(Access) In order to restrict the data that is inputted into a field, Access can use
data validation rules
(Access) Each of the following is an Access data type, EXCEPT:
(Access) The ______ of a field tells Access what kind of data may be stored in the field.
(Access) The data type of an item price, such as $10.50 is :
(Access) The maximum field size for a Short Text field is ___ characters.
(Access) When data is changed using a form, the corresponding data in the table it is based on is automatically updated. (True or False?)
(Access) A graphical, intuitive, and dynamic way of effecting most changes to a form which presents an active preview of data and allows for accurate control sizing and optimal functionality.
(Access) When entering data into a form, instead of using the mouse to go from one text box to another, this key on the keyboard can be used to jump to the next text box in the preset order.
(Access) An Access view that provides a grid-like environment for precision placement of controls and allows a controlled and deliberate approach to creating forms.
(Access) Which of the following is a form-creation tool that automatically creates a form based on table fields and other options selected by the user?
Form Wizard button
(Access) A(n) ______ is a type of template found on the Create tab of the ribbon that lets you quickly add new objects to an Access database.
(Access) Objects such as Labels, Text boxes, List boxes, and Check boxes that are added to a form are called:
(Access) In order to use the Form button found in the Forms group of the Create ribbon tab, you must first:
select a table or query to base it on
(Access) Mary wants to quickly create a form containing all of the fields from a selected Employee Information table. What button from the Forms group of the ribbon will most quickly do this?
(Access) Which Access database object is often used as a user interface to the underlying data source to enter and display data quickly and easily?
(Access) With an "Update" query, you can:
make changes to the data in an existing table
(Access) You've created a query and you'd like to determine the total for each item in order for any duplicate values to be removed from the query results. Identify the command you use to do this.
(Access) You've started creating a query, but you want to add a calculated value for new shipping fees to the first available column. These shipping fees are calculated by subtracting 20 from the Shipping Fee. Assuming the label of the calculated field is New Fees, which option is correct?
New Fees:[Shipping Fee]-20
(Access) Which type of query allows us to reuse the same query for multiple criteria for which the user will type in when they are prompted upon running the query?
(Access) Which access feature provides a step-by-step guided process for creating simple queries?
(Access) Editting a query by adding new column or changing the order of the columns is done easily through Design View.
(Access) Which of the following is a TRUE statement in regards to queries in Access?
A single query can consist of fields from several tables.
(Access) Suppose you want to use a field entitled "State" to list only those employees living in Florida, but you do not want the field column displayed in the results after you run the query. What can you do in the query design to achieve this?
Uncheck the "Show" checkbox to hide the State column from displaying in the results.
(Access) Which of the following is a special-purpose programming language used for manipulating database information?
(Access) Which Access object can be used to update data and is designed to answer questions by retrieving, filtering, assembling, and sorting data from a database?
(Access) With a "Make Table" query, you can:
select records from the database and save them as a new table
(Access) With a "Delete" query, you can:
delete information from an existing table where the data matches a specified criteria
(Access) With a "Select" query, you can:
select and display records from the database
(Access) To view what the report will look like when printed on paper and to access different print options, use the:
(Access) One of the quick and easy ways to format the whole report at once is by utilizing a ____ which gives us some nice combinations of color and font altogether.
(Access) Reports and tables are typically used for the same purposes.
(Access) When creating a report, the user is limited to choosing fields from a single table. If you need fields from multiple tables, then you must use a query to accomplish this. (True or False?)
(Access) Which item in the Access program window allows the user to most quickly save a report?
Quick Access Toolbar
(Access) A document within Access that displays and summarizes data from one or more queries or tables for easy interpretation, printing, and sharing with others is known as a:
(Access) In order to create a report, you must first select an Access object such as a table or query.
(Access) Clicking the Report Wizard button found on the Create tab of the ribbon will automatically add all of the fields of the selected table to the report.
(Access) Which button from the Reports group would you use if you want a guided approach to creating a report with only the fields that you indicate in the report?
Report Wizard button
(Access) A graphical representation of numerical data is called a:
(Access) Each object such as a label or button that is placed in the report is typically referred to as a(n):
(Access) If I sort my report based on Last Name going from A to Z, that is known as:
Sign up for free and study better.
Get started today!