__ is concerned with risk management, confidentiality, integrity, and the availability of electronic information processed and stored on a computing system.
A. Computer Security
Computer __ may hijack information, computing processing cycles and speed, or storage space.
D. hackers
A firewall controls the flow of data between networks by opening and closing __ for various transmission protocols.
C. ports
__, which includes viruses, worms, and spyware, are programs specifically intended to penetrate or damage a computer system without the user's knowledge.
D. Malware
Any unsolicited email should be considered __.
D. Spam
What type of software attempts to identify, prevent, and eliminate computer viruses and malware?
A. Anti-Virus
__ typically uses a legitimate-looking email to masquerade as a legitimate business organization and gain private information, such as usernames, PIN's, passwords, and account numbers.
D. Phishing
__ can be defined as the ability to keep your personal information out of public view.
D. Privacy
The advantage to a __ is that the user does not have to fill out tedious information twice into the same web page.
D. Cookie
__ refers to a crime in which someone wrongfully obtains and uses another person's personal information, typically for economic gain.
B. Identity theft
What would be the output of the expression 2+2*3?
C. 8
An expression may include indentifiers, operators, functions, and __.
C. Constants
What is the general syntax for a calculated field?
A. CalculatedFieldName: [InputField1] operator [InputField2]
An expression for a calculated field is entered into the __ row.
A. Field
The __ builder is a tool that helps you create a formula that performs calculations.
A. Expression
A(n) __ is an input component required to produce the output for a function.
D. Argument
The __ function evaluates a condition, executing one action when the condition is true and an alternate action when the condition is false.
D. IIf
The function DatePart("yyyy",[BirthDate]) will return a value of 2006 if the Bithdate is __.
A. 02/05/2006
The __ row displays as the last row and displays a variety of summary statistics.
D. Total
A totals query organizes the results of a query into __ to perform aggregate calculations.
B. Groups
It is the job of the __ department to administer people.
A. Human Resources
The __ department measures and provides financial information about an organization primarily for its decision makers, investors, and taxing authorities.
D. Accounting
Making goods and services to be sold is the job of the __ department.
C. Production
Which department lets the world know about a product through advertising and branding?
A. Marketing
The focus of the __ department is to evolve a business' original ideas and devise new ones.
C. research and development
Business departments need to communicate with one another through data and information sharing called __.
D. Collaboration
Many reports are __ in nature, meaning that they are produced at given intervals.
D. Periodic
__ processing systems and the data they provide are the groundwork for all other reports.
C. Transaction
__ reports lend themselves to graphical reporting which can reveal trends within a business.
D. Summarized
Management reporting is summarized from __ reports and can sometimes be used for the strategic decisions, but generally is used for tactical decisions that require specific actions.
C. TPS
A __ is a printed document that displays information from a database.
C. Report
Which view allows you to alter the report design while viewing the data?
B. Layout View
Which view displays the report as it will be printed?
A. Print Preview
Which view displays the report's infrastructure, but no data?
A. Design View
To use the Report tool, first determine the __ and open in datasheet view.
D. Record Source
You can only see sectional boundaries when you display the report in __.
D. Layout View
The report footer section __ .
D. Appears once at the end of each report.
Most __ controls display as two small boxes in desing view with the left box containing the control's label and the right box displaying the records value.
C. Bound
To display the __ pane at the bottom of a report, click Group & Sort in the Grouping & Totals group on the Format tab.
D. Group, Sort and Total
The __ Wizard ask questions and then, depending on the answers, generates the report.
A. Report
IT stands for __.
C. Information Technology
The board-level head of an IT department within a business organization is called a __.
D. CIO
Many times a head application developer must modify an existing system also known as a __ system.
C. Legacy
A database administrator, or __ , categorizes data requirements and creates database entities and models.
A. DBA
Which IT professional is responsible for the smooth operation and maintenance of a business' networks?
D. Network Administrator
A senior __ may be asked to rewrite a legacy system, making it browser-based so it can be deployed on the World Wide Web.
A. Web Developer
__ software is a business-wide computer system that uses shared data stores.
A. ERP
One of the advantages of ERP is __.
B. functional departments can share information
UML is typically used with __ programming languages, which encourage the programmer to reuse parts of an application.
B. Object-Oriented
The first step of the System Development Life Cycle tries to determine the __ of the project and whether it is feasible.
B. Goals
A company performs data mining to __.
B. identify patterns and relationships in data
After a PivotTable is constructed, __.
B. it is very easy to alter
To organize data in a PivotTable, drag fields to the __ zones.
B. Drop
The largest drop zone contains the __ field.
B. Detail
Which aggregate function may be used for a text field?
B. Count
A detail data point must be activated for the __ feature to engage.
B. Auto Calc
A __ chart displays quantitative values veritcally to compare values across categories.
D. Column
A __ chart describes part in relation to a whole.
B. Pie
When editing an element in an Access PivotChart, you must select it __.
D. Using the property sheet
A(n) __ field is useful to generate custom total calculations.
C. Calculated Total
In a __ database, tables are connected to other tables with related information.
A. Relational
A database __ is a "map" of data tables and their relationships to each other.
B. Schema
Database designers construct a conceptual representation of a database using __.
A. ERM
A(n) __ check ensures that a field contains only numbers.
C. Numeric
A column in a table is called a __.
C. Field
A well-thought out DBMS helps a business avoid data __, or repetition.
B. Redundancy
Different levels of __ can be implemented in a DBMS by determining who has access to see what in a business.
C. Security
SQL is the most widely used standard computer language for __ databases that allows a programmer to manipulate and query data.
D. Relational
What results will the following SQL statement give?
SELECT Title FROM Book WHERE Price<200 ORDER BY Title
B. Books that cost less than $200
__ practice is a managment process, technique, or method that is most effective at arriving at a desired outcome.
B. Best
You use a(n) __ query when you want the user to interactively select one or more criteria.
B. Parameter
A(n) __ query alters data in a database, whereas a select query does not.
D. Action
To identify duplicated values in a table, you should use the __ query.
D. Find Duplicates
Which query summarizes values by two sets of unrelated facts?
C. Crosstab
By comparing records in two related tables, a(n) __ query will return the records found in one table, but not found in both.
C. Find Unmatched
An append query will __.
B. Select at least one record and add it to a different existing table
When entered in the criteria row of a parameter query, which of the following would ask the user to enter a city name?
D. [Enter the city name]
In a crosstab query, column headings describe __.
A. The list of facts listed veritcally
In order for a find unmatched query to work, the two tables must __.
C. Share a common field
You might run a find duplicated query to __.
D. Identify any repeating values in a primary key field
