Concepts of Database Design

STUDY
PLAY
database management system
Access is a ___________.
tabular
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.
record
A _____ contains information about a given person, product, or event.
short text
A field whose data type is _____ can contain any characters.
caption
When you assign a ______ to a field, Access will display the value you assign, rather than the field name, in datasheets and in forms.
Primary ID
When you create a table in Datasheet view, Access automatically adds a field called ____ as the first field in the table.
Rename field
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.
Insert field
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.
EXTERNAL DATA
To import data to a table, tap or click the ____ tab on the ribbon.
S*
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 _____.
>1000
To find all customers whose current due amount is greater than $1,000.00, enter ____ in the criteria row of the Current Due column.
comparisons operators
Less than (<), greater than (>) and NOT (not equal to) are examples of _______.
BETWEEN
The ______ operator allows you to search for a range of values in one field.
sort
To order the records in the answer to a query in a particular way, you _____ the records.
EXTERNAL DATA
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.
Zoom
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 _____.
Enable Content
If a SECURITY WARNING appears when you open a database, tap or click the _____ option button.
Design
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.
lookup
To create a multivalued field, create a _____ field being sure to check the Allow Multiple Values check box.
calculated
A ______ field is a field that can be calculated from other fields.
Update
To create an update query, create a new query and then tap or click the _____ button on the DESIGN tab.
Required
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.
summary
A report that includes the group calculations such as subtotals, but does not include that individual detail lines is called a ______ report.
Form Title
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 _____.
Totals
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.
Layout View
______ shows the report on the screen but also allows you to make changes to the report.
theme
A _____ consists of a selection of colors and fonts for the various sections in a report or form.
Title
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.
Insert Object
To insert data into an OLE Object field, use the _____ command of the OLE's shortcut menu.
Manage Attachments
To insert data into an Attachment field, use the _____ command on the OLE's shortcut menu.
subform
A form that is contained within another form is called a ______.
Background Color
To change the background color of a form, you can use the ______ button on the FORM DESIGN TOOL FORMAT tab.
Title
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.
Table Design
To create a table in Design View, tap or click the _____ button on the CREATE tab.
Text File
To import a text file, tap or click the _____ button on the EXTERNAL DATA tab.
Query Design
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.
Report Design
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.
ARRANGE
You can align controls in the Report Design window using the Align button on the REPORT DESIGN TOOLS _______ tab.
Print Preview
To periodically view a report to gauge how it will look containing data, tap or click ______ on the View menu.
DELETE
To delete a control from a report, tap or click the control and press the ______ key.
SHIFT+ENTER
To delete a control from a report, tap or click the control and press the ____ key.
Can Grow
To spread data over two lines, change the value of the _____ property.
Title
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.
MIN
The _____ aggregate function finds the smallest value.
MAX
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 _______.
SUM
To calculate the total of a field, such as Amount Paid, use the _____ aggregate function.
Format
To ensure that a calculated control displays as currency, change the ______ property.
IIF
To assign a conditional value, use the ____ function.
Text Box
To add a text box to a report, tap or click the _____ tool in the Tools group on the REPORT DESIGN TOOLS DESIGN tab.
Blank Form
To create a form in Design view, tap of click the CREATE tab, and then tap or click the _____ button.
Record Source
To select a table as the basis for a form, display the property sheet and tap or click the ____arrow.
Caption
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.
combo box
With a ______, you can enter a value either by typing that value or by selecting it from a list.
Combo Box
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.
Background Color
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.
Special Effect
To change the appearance of a control so that it appears sunken, change the ______ property for the control.
Font Weight
To change the appearance of a control so that the text in the control displays as semi-bold, change the _____ property for the control.
Format painter
To copy the formatting of one control to other controls, use the _______ button on the FORM DESIGN TOOLS FORMAT tab.
Background Image
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.
Button
To add command buttons to a form, use the _____ tool on the FORM DESIGN TOOLS DESIGN tab in the Controls Group.
focus
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.
GoToControl
The _____ macro action will move the focus to a specific control.
Text Box
To add a concatenated field to a form, use the _____ tool in the Controls group on the FORM DESIGN TOOLS DESIGN tab.
Chart
To insert a chart in a form, use the _____ tool on the FORM DESIGN TOOLS DESIGN tab.
Edit
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
Tab Control
To insert a tab control on a form, tap or click the _____ tool in the FORM DESIGN TOOLS DESIGN tab in the Controls Group.
Multipage Form
A form that contains more than one page of information.
Text box
A box into which you can type an entry.
List Box
A box you can use to display a list from which to select a value.
Combo Box
Type of box which combines the properties of a list box and a combo box.
Command Button
Button placed on a form that users can click to carry out specific actions.
Query
A series of actions that Access performs when a particular event occurs.
Concatenation
Simply means joins two objects together
Macro
Simply a question presented in a way that Access can process
Format Painter
Button used to copy the format from one control to other controls
Image
A picture that can be used on a form or as a background image.
YOU MIGHT ALSO LIKE...