Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
150 Cards in this Set
- Front
- Back
The ____ tag creates a blank line in a Web page.
a. <BR> c. <B> b. <BL> d. <LINE> |
a. <BR>
|
|
The ____ tag indicates the end of an HTML document.
a. </PAGE> c. </HTTP> b. </HTML> d. </URL> |
b. </HTML>
|
|
Microsoft Internet Explorer is an example of a Web ____.
a. server c. manager b. browser d. resource |
b. browser
|
|
A(n) ____ identifies where the Web page is stored.
a. HTML c. HTTP b. URL d. FTP |
b. URL
|
|
A Web page’s ____ can be an Internet Web server or a location on a hard drive.
a. HTML c. path b. protocol d. URL |
d. URL
|
|
In a ____ file, each line is a record containing the same number of values in the same positions.
a. CSV c. CVS b. TSV d. CPP |
a. CSV
|
|
____ is a programming language similar in format to HTML that is more customizable and suited to the exchange of data between different programs.
a. XML c. DHTML b. WML d. Java |
a. XML
|
|
From an XML file, you can do all of the following EXCEPT ____.
a. append the data in the XML file to a recently deleted table b. import only the table structure to a new table c. import the table structure and data to a new table d. append the data in the XML file to an existing table |
a. append the data in the XML file to a recently deleted table
|
|
A(n) ____ file provides formatting instructions so that a browser or another program can display the data in the XML file in a readable way.
a. XMX c. XSD b. XSP d. XSL |
d. XSL
|
|
You can export a table’s structure, including information about its primary key and indexes, in a(n) ____ file.
a. UTF-8 c. UTF-16 b. XSD d. WML |
b. XSD
|
|
All of the following are Access export options EXCEPT ____.
a. a Snapshot file c. an ODBC database b. a Word document d. an XPS file |
a. a Snapshot file
|
|
All of the following are Access export options EXCEPT ____.
a. a PowerPoint chart c. a PDF file b. a text file d. an Excel workbook |
a. a PowerPoint chart
|
|
The ____ area of a PivotChart provides a background for the data markers and gridlines.
a. plot c. background b. wallpaper d. grid |
a. plot
|
|
The item marked 1 in the accompanying figure is the ____ area.
a. background c. label b. category d. plot |
d. plot
|
|
A data ____ is a bar, dot, segment, or other symbol that represents a single data value.
a. marker c. icon b. key d. grid |
a. marker
|
|
In a PivotChart, the ____ field identifies the data markers’ subdivisions.
a. legend c. row b. series d. column |
b. series
|
|
In a PivotChart, the ____ provides a list of the series field values and how these values are indicated on the data markers.
a. map c. key b. legend d. roster |
b. legend
|
|
The Navigation ____ property lets you change the navigation label from one value to another.
a. Key c. Caption b. Label d. Icon |
c. Caption
|
|
For objects in forms or reports, you ____ an object when you want a copy of the object in your form or report and you do not intend to make any changes to the object.
a. embed c. import b. link d. append |
c. import
|
|
When you embed an object in a form, report, or field, you preserve its connection to the ____ program.
a. origin c. destination b. source d. embedded |
b. source
|
|
When you ____ an object to a form, report, or field, you include a connection in the destination program to the original file maintained by the source program.
a. embed c. link b. append d. import |
c. link
|
|
You ____ an object when you want your edits to the object in the destination program to affect the object used by other programs.
a. link c. append b. embed d. import |
a. link
|
|
After using the Chart Wizard to create and embed a chart in a form or report, you can edit the chart by using Microsoft ____.
a. Access c. Graph b. Excel d. Chart |
c. Graph
|
|
The ____ area of a PivotTable lets you restrict which data appears in the PivotTable.
a. restriction c. filter b. sort d. key |
c. filter
|
|
The items marked 1 in the accompanying figure are the ____ field items.
a. row c. column b. filter d. detail |
a. row
|
|
The item marked 2 in the accompanying figure is the ____ field.
a. row c. column b. filter d. detail |
a. row
|
|
The item marked 4 in the accompanying figure is the ____ field.
a. row c. column b. filter d. detail |
b. filter
|
|
The item marked 5 in the accompanying figure is the ____ field item.
a. row c. column b. filter d. detail |
c. column
|
|
The item marked 5 in the accompanying figure is the ____ field item.
a. row c. column b. filter d. detail |
d. detail
|
|
A(n) ____ field summarizes field values from a source field.
a. summary c. summation b. aggregate d. total |
d. total
|
|
The item marked 1 in the accompanying figure is the ____ field.
a. row c. filter b. column d. detail |
a. row
|
|
The item marked 2 in the accompanying figure is the ____ field.
a. row c. filter b. column d. detail |
c. filter
|
|
The item marked 3 in the accompanying figure is the ____ field.
a. row c. filter b. column d. detail |
b. column
|
|
Which of the following is NOT true of any Excel chart that Jamal embeds in an Access form or report?
a. Any changes he makes to the embedded chart can be made using the features of Excel. b. Any changes he makes to the embedded chart are reflected in both the original chart and the embedded version. c. He preserves its connection to Excel. d. If he starts Excel outside of Access and makes changes to the original chart, these changes are not reflected in the embedded version. |
b. Any changes he makes to the embedded chart are reflected in both the original chart and the embedded version.
|
|
Which of the following is a type of action query?
a. make-delete query c. history query b. update query d. all of the above |
b. update query
|
|
Which of the following is a use of the make-table query?
a. creating customized tables for others to use b. removing records permanently from a database c. adding records from an existing table to the end of another table d. all of the above |
a. creating customized tables for others to use
|
|
A(n) ____ table contains data that is no longer needed for current processing but that you might need to reference in the future.
a. append c. current b. delete d. history |
d. history
|
|
A(n) ____query changes selected fields and records in one or more tables.
a. change c. append b. update d. delete |
b. update
|
|
A(n) ____ query adds records from an existing table or query to the end of another table.
a. additive c. append b. update d. make-table |
c. append
|
|
A(n) ____ query creates a new table from one or more existing tables.
a. creation c. append b. update d. make-table |
d. make-table
|
|
You would use a(n) ____ table to holds records no longer needed for current processing in the original table.
a. append c. action b. query d. history |
d. history
|
|
Once records have been appended to a(n) ____ table, you can delete the records from the original table.
a. append c. history b. query d. action |
c. history
|
|
____ records removes them permanently from the database.
a. Archiving c. Appending b. Filtering d. Deleting |
d. Deleting
|
|
You need to combine the information from a table containing addresses with a table containing phone numbers in a customer database. What type of query should you use?
a. action c. make-table b. append d. update |
b. append
|
|
When you create an update query, in the design grid, Access replaces the Sort and Show rows with the ____ row.
a. Field c. Criteria b. Table d. Update To |
d. Update To
|
|
A one-to-many relationship is abbreviated as ____.
a. M:1 c. 1:M b. 1-M d. 1_M |
c. 1:M
|
|
A many-to-many relationship is abbreviated as ____.
a. M:N c. M:M b. N:M d. M_M |
a. M:N
|
|
When you have a ____ relationship between two tables, you must create a third table and form one-to-many relationships between the two original primary tables and the new related table.
a. one-to-many c. many-to-many b. many-to-one d. one-to-one |
c. many-to-many
|
|
When you join tables that have a ____ relationship, you can extract data from them as if they are one larger table.
a. one-to-one c. many-to-one b. many-to-many d. one-to-many |
b. many-to-many
|
|
A relationship like the one in the accompanying figure is abbreviated as ____.
a. 1:1 c. 1/1 b. 1_1 d. 1-1 |
a. 1:1
|
|
You are in a database containing a student table and a class table. What two items show all students whether or not the students are enrolled in the class, and all classes whether or not there are any students enrolled in them?
a. Outer joins c. Common threads b. Inner joins d. Join threads |
a. Outer joins
|
|
As made available by the dialog box in the accompanying figure, a(n) ____ join is a join in which Access selects records from two tables only when the records have the same value in the common field that links the tables.
a. outer c. real b. inner d. related |
b. inner
|
|
Because primary key values cannot be null, records with null ____ values do not appear in a query recordset based on a join marked as option 1 in the accompanying figure.
a. contact c. index b. foreign key d. selection |
b. foreign key
|
|
Which of the following is a true statement?
a. Accessing disk storage is very slow and performing operations in computer memory is very fast. b. Indexes are usually too large to fit completely in computer memory. c. Access sorts and selects records based on indexes with a heavy reliance on disk storage. d. Using indexes in large tables is slower than using them in small tables. |
a. Accessing disk storage is very slow and performing operations in computer memory is very fast.
|
|
Without ____, many database operations in large tables would not be practical.
a. indexes c. relations b. foreign keys d. contacts |
a. indexes
|
|
You can add an index if you think ____ would be faster as the number of records in the database increases.
a. rekeying c. searching b. querying d. both b and c |
d. both b and c
|
|
Because it is the start of a new semester, Jeremy does not want information about past students in his database. To remove this information, he can run a(n) _____ query with selected criteria such as course and year.
a. append c. make-table b. delete d. update |
b. delete
|
|
After the first few weeks of school, Jeremy finds that there are students who have added his classes. To add these students to his database, he can make a table containing the new students and then run a(n) _____ query.
a. make-table c. append b. delete d. update |
c. append
|
|
Because the relationship between the Airline and Flight tables is one-to-many, we know that each Airline record is connected to _____ Flight record(s).
a. at most one c. exactly one b. at least one d. zero, one, or more |
d. zero, one, or more
|
|
In addition to connecting records from the Airline and Flight tables with the same Airline ID, a(n) _____ join would also include Airline records without a matching Flight record.
a. inner c. self b. outer d. none of the above |
b. outer
|
|
Dottie is considering adding indexes to the Airline Reservation System database, and she asks you for more information about them. Which of the following statements about indexes is NOT true?
a. An index adds disk storage requirements to the database. b. Indexes are usually small enough to fit in computer memory. c. You can add or delete an index on a table’s primary key. d. It takes time to update an index as you add and delete records. |
c. You can add or delete an index on a table’s primary key.
|
|
You must enter tab names and drag objects to the navigation form in the accompanying figure in ____ view.
a. Navigation c. Form b. Design d. Layout |
d. Layout
|
|
The prefix tag used to identify the macro object type is ____.
a. mac c. mro b. mcr d. mco |
b. mcr
|
|
You can use ____ to open an application in a special way, such as displaying a user interface.
a. VBA c. SQL b. macros d. all of the above |
b. macros
|
|
The ____ action closes the active window if none is specified.
a. CloseWindow c. CloseActive b. QuitAccess d. ShutDown |
a. CloseWindow
|
|
Access lets you automate most tasks using either macros or ____.
a. HTML c. VBA b. Java d. JavaScript |
c. VBA
|
|
The ____ action causes Access to open a message box like the one in the accompanying figure.
a. OpenBox c. MessageBox b. OpenMsg d. BoxMsg |
c. MessageBox
|
|
____ is a Yes/No argument associated with the action, which specifies whether a beep will sound when a message box like the one in the accompanying figure is closed.
a. Alert c. Sound b. Beep d. Alarm |
b. Beep
|
|
Which of the following is an argument of the MessageBox action?
a. Comment c. Type b. Sound d. all of the above |
c. Type
|
|
The ____ action is used to find the first record that satisfies a given criterion, or the next record if the action is used again.
a. FindRecord c. LocateNum b. GoToRecord d. both a and b |
a. FindRecord
|
|
The ____ dialog box shows the macro’s name and the action’s condition, name, and arguments.
a. Debugging c. Automating Macros b. Macro Properties d. Macro Single Step |
d. Macro Single Step
|
|
After adding a(n) ____ button to a form and while still in Design view, you can attach a macro with the desired actions to the button.
a. dialog c. command b. action d. dynamic |
c. command
|
|
A(n) ____ button is a control on a form that starts an action, or a set of actions.
a. command c. agent b. acting d. index |
a. command
|
|
All of the following are event properties associated with a form EXCEPT ____.
a. OnActivate c. OnClose b. OnSearch d. OnOpen |
b. OnSearch
|
|
The ____ form event occurs when the form becomes the active window.
a. Open c. New b. Activate d. This |
b. Activate
|
|
Instead of creating several separate macros, you can combine them in a(n) ____.
a. aggregate c. combo b. cluster d. submacro |
d. submacro
|
|
A submacro is a complete macro with a Submacro ____ within a macro.
a. container c. argument b. link d. header |
d. header
|
|
The ____ action argument of the OpenForm action lets you specify a form’s data-entry options.
a. Specify Data Entry c. Entry Options b. Data Entry d. Data Mode |
d. Data Mode
|
|
____ is the default setting for the Data Mode action argument of the OpenForm action.
a. Read Only c. Edit b. Add d. New |
c. Edit
|
|
Which of the following is an allowable setting for the Data Mode argument?
a. Add c. New b. Change d. all of the above |
a. Add
|
|
The ____ setting for the Window Mode argument of the OpenForm action opens the form minimized as a small title bar at the bottom of the screen.
a. Normal c. Dialog b. Icon d. Minimized |
b. Icon
|
|
The ____ setting for the Window Mode argument of the OpenForm action opens the form as it typically would from the Database window.
a. Usual c. Typical b. Normal d. Standard |
b. Normal
|
|
You can type the first few letters of an action until the full action name appears, and then press the ____ key to select the action.
a. Ctrl c. Tab b. Alt d. F2 |
c. Tab
|
|
A(n) _____ box is a control that displays a scrollable list of values.
a. control c. index b. list d. tab |
b. list
|
|
A(n) ____ statement retrieves the list of query names appearing in a list box.
a. SQL c. Perl b. HTML d. control |
a. SQL
|
|
A user ____ is what you see and use when you communicate with a computer program.
a. switchboard c. form b. interface d. register |
b. interface
|
|
Database users should not be allowed to ____.
a. add data c. delete data b. change data d. change the design of the user interface |
d. change the design of the user interface
|
|
The ____ property of a form is the value that appears on a form’s object tab when the form is open.
a. Name c. Caption b. Title d. TabValue |
c. Caption
|
|
The ____ property of a form disables the display of the Close button on the form’s object tab.
a. Disable c. Close Button b. NoClose d. DisableCloseOption |
c. Close Button
|
|
The ____ property of a form disables the display of navigation buttons at the bottom of the form.
a. NoNavigation c. DisableNav b. Hide Navigation d. Navigation Buttons |
d. Navigation Buttons
|
|
For ____ forms, users do not need to navigate from record to record.
a. bound c. unbound b. indexed d. navigational |
c. unbound
|
|
The item marked 4 in the accompanying figure is a(n) ____.
a. argument filter c. command box b. list box d. attribute list |
b. list box
|
|
The item marked 3 in the accompanying figure is a(n) ____.
a. control wizard c. attribute b. index d. label |
d. label
|
|
SQL stands for ____, a language used to query, update, and manage relational databases.
a. Standard Query Language c. Structured Query Logic b. Standard Query Logic d. Structured Query Language |
d. Structured Query Language
|
|
SQL uses the ____ statement to define what data it retrieves from a database and how it presents the data.
a. DEFINE c. SELECT b. DATA d. PRESENT |
c. SELECT
|
|
The ____ SQL clause selects records from two tables only when the records have the same value in the common field that links the tables.
a. JOIN c. SELF JOIN b. INNER JOIN d. OUTER JOIN |
b. INNER JOIN
|
|
In a SELECT statement, you list the selection criteria after ____.
a. CRITERIA c. FROM b. WHERE d. ORDER BY |
b. WHERE
|
|
In a SELECT statement, if a field name includes a space or special symbol, enclose the field name in ____.
a. parentheses c. ampersands b. brackets d. carets |
b. brackets
|
|
In a SELECT statement, separate field names and table names with ____.
a. semicolons c. apostrophes b. colons d. commas |
d. commas
|
|
End a SELECT statement with a(n) ____.
a. period c. apostrophe b. comma d. semicolon |
d. semicolon
|
|
____ tables are special tables maintained by Access that store information about the characteristics of a database and about the structure of the objects in a database.
a. Object c. Hidden b. System d. Restricted |
b. System
|
|
An Access-created query has a name that begins with the ____ character.
a. apostrophe c. ampersand b. tilde d. comma |
b. tilde
|
|
For another macro, Pedro wants to be able to locate the first or next record that meets a set of criteria. What Access action should he add to the macro?
a. FindRecord c. GoToRecord b. ApplyFilter d. SelectObject |
a. FindRecord
|
|
Pedro is using the Macro Designer to add a MessageBox action to a macro. This action will display a message at the beginning of the macro and wait for the user to click the OK button. Pedro wants an icon to appear in the message box to indicate that the message is critical. Which MessageBox argument should he use to specify the icon?
a. Message c. Type b. Warning d. Title |
c. Type
|
|
Julia wants the form to be opened in Form view. Which OpenForm action argument should she use to specify this?
a. Data Mode c. View b. Filter Name d. Window Mode |
c. View
|
|
Julia uses the _____ argument to specify the SQL statement that will be used to select the records displayed in the form.
a. SQL Mode c. Where Condition b. Filter Name d. Window Mode |
c. Where Condition
|
|
To specify that the form should be opened as a dialog box, Julia uses the _____ argument.
a. Data Mode c. View b. Filter Name d. Window Mode |
d. Window Mode
|
|
VBA is a(n) ____ language.
a. modal c. event-oriented b. object-oriented d. procedural |
b. object-oriented
|
|
VBA instructions are called ____.
a. keys c. statements b. properties d. events |
c. statements
|
|
A group of statements is called a ____.
a. procedure c. logical b. condition d. mode |
a. procedure
|
|
Access has over ____ events and associated event properties.
a. 60 c. 250 b. 120 d. 550 |
a. 60
|
|
A function ____.
a. performs operations c. can be used in expressions b. returns a value d. any of the above |
d. any of the above
|
|
The ____ event occurs when the focus moves to a record.
a. Current c. Open b. Focus d. Load |
a. Current
|
|
A ____ performs operations and can accept input values, but does not return a value and cannot be used in expressions.
a. procedure c. subroutine b. mode d. return process |
c. subroutine
|
|
The ____ event occurs when a form opens and when the focus moves to another record.
a. Open c. Display b. Current d. Show |
b. Current
|
|
The ____ event occurs when a form opens and when the focus moves to another record.
a. Open c. Display b. Current d. Show ` |
c. Display
|
|
You store a group of related procedures together in a ____.
a. mode c. cluster b. key d. module |
d. module
|
|
Each module starts with a ____.
a. class module c. Declarations section b. standard module d. procedure |
c. Declarations section
|
|
A(n) ____ module is a database object that is stored in memory with other database objects when you open the database.
a. local c. public b. standard d. indexed |
b. standard
|
|
A procedure that more than one object can use is called a ____ procedure.
a. private c. public b. library d. local |
c. public
|
|
A ____ module is usually associated with a particular form or report.
a. class c. report b. library d. private |
a. class
|
|
____ refers to the record and control that are currently active and awaiting user action.
a. Current c. Active b. This d. Focus |
d. Focus
|
|
In the accompanying figure, the event name for the event procedure in the Procedure box is ____.
a. Form c. Employer b. Database d. Current |
d. Current
|
|
In the accompanying figure, the current control is ____.
a. Database c. Employer b. Current d. Form |
d. Form
|
|
In the accompanying figure, item 1 refers to the ____ procedure for the form’s Current event.
a. Private c. Sub b. Form d. Object |
c. Sub
|
|
In the accompanying figure, item 1 refers to the ____ procedure for the form’s Current event.
a. Private c. Sub b. Form d. Object |
c. Sub
|
|
The ____ window is the window in which you create, modify, and display VBA code.
a. Code c. Program b. Debugging d. Visual Basic |
a. Code
|
|
In the Code window, the ____ box indicates the current control and the Procedure box indicates the event name for the event procedure you are viewing.
a. Object c. Code b. Control d. Program |
a. Object
|
|
All event procedures are ____.
a. functions c. control structures b. options d. subroutines |
d. subroutines
|
|
A ____ structure is a set of VBA statements that work together as a unit.
a. property c. logical b. condition d. control |
d. control
|
|
A field’s ____ property determines the field’s font color.
a. FontColor c. Font b. ForeColor d. ColorFont |
b. ForeColor
|
|
Each color component value for the RGB function must be in the range 0 through ____.
a. 25 c. 128 b. 56 d. 255 |
d. 255
|
|
Access displays a control when its Visible property is ____.
a. True c. Display b. Show d. Reveal |
a. True
|
|
Whenever a user enters or changes a field value in a control on a form, Access automatically triggers the ____ event, which simply accepts the new or changed entry.
a. FieldChange c. AfterUpdate b. ChangeValue d. NewEntry |
c. AfterUpdate
|
|
Each function ends with a(n) ____ Function statement.
a. Cease c. Exit b. Close d. End |
d. End
|
|
A placeholder like FValue in the function CapAll(FValue) is called a ____.
a. variable c. character b. parameter d. property |
b. parameter
|
|
The value passed to a function and used in place of the parameter when the function is executed is called a(n) ____.
a. pass c. argument b. formula d. case |
c. argument
|
|
When working in the Code window, you can use the ____ window to test VBA procedures without changing any data in the database.
a. Visual Basic c. Debugging b. Immediate d. Intermediate |
b. Immediate
|
|
A(n) ____ statement executes one of two groups of statements based on a condition, similar to common English usage.
a. Case c. Select b. If d. Where |
b. If
|
|
The ____ data type is the equivalent of the Access text data type.
a. Variant c. Word b. String d. Character |
b. String
|
|
The ____ data type stores True/False values.
a. Byte c. Date b. Boolean d. Double |
b. Boolean
|
|
The ____ data type stores non-integer values with 0 to 28 decimal places.
a. Byte c. Decimal b. Non-integer d. Double |
c. Decimal
|
|
The ____ data type stores non-integer values to many decimal places (but not as many as the double data type).
a. String c. Long b. Single d. Decimal |
b. Single
|
|
If you use a(n) ____ in a module, you must explicitly declare it in the Declarations section or in the procedure where it is used.
a. event c. variable b. key d. process |
c. variable
|
|
A(n) ____ is an action that operates on specific objects or controls.
a. key c. method b. process d. objective |
c. method
|
|
Ellen knows that there is an event that occurs when a form is opened but before the first record is displayed. What is this event called?
a. AfterUpdate c. Open b. Click d. GotFocus |
c. Open
|
|
Ellen knows that a _____ event occurs when a user presses and releases a mouse button over a control in a form.
a. Click c. GotFocus b. DblClick d. MouseDown |
a. Click
|
|
If Caryn wants a VBA data type that holds integer values from 0 to 255, which of the following should she use?
a. Integer c. Decimal b. Byte d. Double |
b. Byte
|
|
For another variable, Caryn needs to be able to contain text values up to 2 billion characters in length. What data type does she need to use?
a. Text c. String b. Long d. Character |
c. String
|
|
Anita has identified a pattern in the data entry of records in which some users have been entering first and last names in all lowercase letters, perhaps for speed of data entry. In order for her to correct this and change an entry like “christine” to “Christine”, what event procedure would she use?
a. vbLowerCase c. vbUpperCase b. vbProperCase d. either b or c |
b. vbProperCase
|