Upgrade to remove ads
Concepts of Database Design
Terms in this set (86)
database management system
Access is a ___________.
In a(n)_____ database such as those maintained by Access, a database consists of a collection of tables, each of which contains information on a specific subject.
A _____ contains information about a given person, product, or event.
A field whose data type is _____ can contain any characters.
When you assign a ______ to a field, Access will display the value you assign, rather than the field name, in datasheets and in forms.
When you create a table in Datasheet view, Access automatically adds a field called ____ as the first field in the table.
To change the name of a field, press and hold or right-click the column heading for the field, tap or click ___ on the shortcut menu, and then type the desired field name.
To insert a field between existing fields, press and hold or right-click the column heading for the field that will foll0w the new field, and then tap or click ____ on the shortcut menu.
To import data to a table, tap or click the ____ tab on the ribbon.
To find all customers whose name begins with S, enter ____ in the Criteria row of the Customer Name Field.
square brackets 
To create a parameter query, enter a parameter rather than a specific value as a criterion in the design grid. The parameter must be enclosed in _____.
To find all customers whose current due amount is greater than $1,000.00, enter ____ in the criteria row of the Current Due column.
Less than (<), greater than (>) and NOT (not equal to) are examples of _______.
The ______ operator allows you to search for a range of values in one field.
To order the records in the answer to a query in a particular way, you _____ the records.
To export data from a query to Excel, select the query in the Navigation Pane, tap or click ______ on the ribbon, and then tap or click the Excel button.
To display the entire entry for a calculated field, select the column in the Field row, right-click to display the short-cut menu, and then click _____.
If a SECURITY WARNING appears when you open a database, tap or click the _____ option button.
To delete a field from a table, open the table in ____ view, tap or click the row selector for the field to be deleted, and then press the DELETE key.
To create a multivalued field, create a _____ field being sure to check the Allow Multiple Values check box.
A ______ field is a field that can be calculated from other fields.
To create an update query, create a new query and then tap or click the _____ button on the DESIGN tab.
To specify that a field is to be required, change the value for the _____ property from No to Yes.
>=0 and <=30000
To specify that entries in the Returns field must be between $0.00 and $30,000.00, enter ______ in the Validation Rule property box.
=HS or =COM or =UNI
To indicate that the only allowable values for the Customer Type field are HS, COM, and UNI, enter ____ in the Validation Rule property box.
A report that includes the group calculations such as subtotals, but does not include that individual detail lines is called a ______ report.
The _____ section appears at the top of the form and usually contains the form title.
If the Customer Number field in a record always should display the three characters in the customer number in uppercase, then the correct format for this field is _____.
To include totals and other statistics at the bottom of the datasheet, tap or click the _____ button on the HOME tab to include the Total row in the datasheet.
______ shows the report on the screen but also allows you to make changes to the report.
A _____ consists of a selection of colors and fonts for the various sections in a report or form.
To add a title to a report, tap or click CREATE on the ribbon and then tap or click the ______ button on the DESIGN tab.
To insert data into an OLE Object field, use the _____ command of the OLE's shortcut menu.
To insert data into an Attachment field, use the _____ command on the OLE's shortcut menu.
A form that is contained within another form is called a ______.
To change the background color of a form, you can use the ______ button on the FORM DESIGN TOOL FORMAT tab.
To add a title to form, tap or click the _____ button on the FORM DESIGN TOOLS DESIGN tab.
FORM DESIGN TOOLS DESIGN
To place a subform on a form, use the Subform/Subreport tool on the _____ tab.
To create a table in Design View, tap or click the _____ button on the CREATE tab.
To import a text file, tap or click the _____ button on the EXTERNAL DATA tab.
To create a new query in Design view, tap or click CREATE on the ribbon to display the CREATE tab, then tap or click the ______ button to create a new query.
To create a report from scratch, tap or click the CREATE tab, and then tap or click the _____ button.
Group and Sort
To display the Group, Sort, and Total pane, tap or click the _______ button on the REPORT DESIGN TOOLS DESIGN tab.
You can align controls in the Report Design window using the Align button on the REPORT DESIGN TOOLS _______ tab.
To periodically view a report to gauge how it will look containing data, tap or click ______ on the View menu.
To delete a control from a report, tap or click the control and press the ______ key.
To delete a control from a report, tap or click the control and press the ____ key.
To spread data over two lines, change the value of the _____ property.
To add a title to a report, tap or click the ______ button on the REPORT DESIGN TOOLS DESIGN tab.
Date and Time
To add a date to a report, tap or click the _______ button on the REPORT DESIGN TOOLS DESIGN tab.
The _____ aggregate function finds the smallest value.
The ______ aggregate function finds the largest value.
square brackets 
To use an item name that contains spaces, such as Amount Paid in a function, enclose the item name in _______.
To calculate the total of a field, such as Amount Paid, use the _____ aggregate function.
To ensure that a calculated control displays as currency, change the ______ property.
To assign a conditional value, use the ____ function.
To add a text box to a report, tap or click the _____ tool in the Tools group on the REPORT DESIGN TOOLS DESIGN tab.
To create a form in Design view, tap of click the CREATE tab, and then tap or click the _____ button.
To select a table as the basis for a form, display the property sheet and tap or click the ____arrow.
To change the caption for a form, use the _____ property in the property sheet.
Add Existing Fields
To display a field list, tap or click the _____ button on the FORM DESIGN TOOLS DESIGN tab in the Tools Group.
With a ______, you can enter a value either by typing that value or by selecting it from a list.
To add a combo box to a form, use the ______ tool in the Controls Group on the FORM DESIGN TOOLS DESIGN tab.
Use Control Wizards
To activate a wizard to help in creating combo boxes and command buttons, make sure the _____ button is selected.
To change the background color of a form, tap or click anywhere in the Detail section but outside all the controls and then tap or click the _____ arrow on the FORM DESIGN TOOLS FORMAT tab in the Font group.
To change the appearance of a control so that it appears sunken, change the ______ property for the control.
To change the appearance of a control so that the text in the control displays as semi-bold, change the _____ property for the control.
To copy the formatting of one control to other controls, use the _______ button on the FORM DESIGN TOOLS FORMAT tab.
To add a background image to a form, tap or click anywhere in the form and then tap or click ______ on the FORM DESIGN TOOLS FORMAT tab in the Background group.
To add command buttons to a form, use the _____ tool on the FORM DESIGN TOOLS DESIGN tab in the Controls Group.
A control is said to have the ______ when it becomes active; that is, when it becomes able to receive user input through mouse, touch or keyboard action.
The _____ macro action will move the focus to a specific control.
To add a concatenated field to a form, use the _____ tool in the Controls group on the FORM DESIGN TOOLS DESIGN tab.
To insert a chart in a form, use the _____ tool on the FORM DESIGN TOOLS DESIGN tab.
To change a chart type, press and hold or right-click the chart in Design View, point to Chart Object on the shortcut menu, and then tap or click ____ on the Chart Object submenu
To insert a tab control on a form, tap or click the _____ tool in the FORM DESIGN TOOLS DESIGN tab in the Controls Group.
A form that contains more than one page of information.
A box into which you can type an entry.
A box you can use to display a list from which to select a value.
Type of box which combines the properties of a list box and a combo box.
Button placed on a form that users can click to carry out specific actions.
A series of actions that Access performs when a particular event occurs.
Simply means joins two objects together
Simply a question presented in a way that Access can process
Button used to copy the format from one control to other controls
A picture that can be used on a form or as a background image.
THIS SET IS OFTEN IN FOLDERS WITH...
Chapter 6- Database Design: Design Method
Access 2016 - Lesson 1 - Database Essentials
Database test 2 chapter 5 and 6
YOU MIGHT ALSO LIKE...
Database Chapter 8 Quiz
Access Section 3
Access 2013 Chapter 5 - 6 Notes
OTHER SETS BY THIS CREATOR
Network Administration (scenario/TorF)