Sem 2- (6 week 2)

Question 1

Using MS Access, which statement best represents the view most likely used to create the table headings shown in Table 1?
Design view is the screen on which you actually enter the data into those fields.
Design view is where you create data fields and types that contain the data.
Datasheet view is the screen on which you actually enter the fields into those types.
Datasheet view is where you create data entry and sorts that contain the fields.

Answer 1

Design view is where you create data fields and types that contain the data.

Question 2

What is MOST likely field being tracked using the type of data in Table 2?
  Location by County 
  Business Partners 
  Identifiers 
  Customer Last Names

Answer 2

Customer Last Names

Question 3

Which of the following best describes a data warehouse?
A folder of multiple databases.
Multiple databases with data from one or more sources.
A single database with data from multiple sources.
A single database with data from a single source.

Answer 3

Multiple databases with data from one or more sources.

Question 4

Which of the following is the best example of a sort in descending order for Table 2?
Crowley, Polan, Sonez, Sterling, Trevino, Yung.
Polan, Sterling, Trevino, Yung, Crowley, Sonez.
Yung, Trevino, Sterling, Sonez, Polan, Crowley.
Crowley, Polan, Sterling, Sonez, Trevino, Yung.

Answer 4

Yung, Trevino, Sterling, Sonez, Polan, Crowley.

Question 5

Suppose you created the customer data Table 2 using database software. Then, you created a query using only the following fields:

Last Name, Company Name, and Position.
If you sorted the query by last name in descending order (Z to A), which answer would represent the first line of data in the table?

Yung, Fun Fitness Club, Trainer
Crowley, Rowen Mfg. Co., Sales Asst.
Yung, Fun Fitness Club, Pro
Crowley, Rowen Mfg. Co., Manager

Answer 5

Yung, Fun Fitness Club, Trainer

Question 6

Data mining is commonly used by retailers to increase sale to existing customers. Which statement MOST ACCURATELY explains how retail data might be used?
Data mining detects which offers are most valued by customers.
Data mining also eliminates which offers are most valued by customers.
Data mining detects which purchases are least valued by wholesalers.
Data mining eliminates which products are too expensive for retailers.

Answer 6

Data mining detects which offers are most valued by customers.

Question 7

While mining for data, you find you need to rearrange the order of your information. What is a MAJOR advantage to using a Query Wizard instead of Filtering?
Filters are more long-term in that they can be saved and accessed again later.
Queries are more temporary in that they cannot be saved and accessed again later.
Filters are more temporary in that they can be saved and accessed again later.
Queries are more long-term in that they can be saved and accessed again later.

Answer 7

Queries are more long-term in that they can be saved and accessed again later.

Question 8

Ava has a large inventory of electric generators in a database table. Her boss asked her to create a table of 100 to 500 kilowatt generators that can also be used during freezing weather. How can Ava use this table to create a promotion for their customers?
Create a query to display purchase information based on a specific generator’s kilowatt value.
Create a filtered list to display purchase information based on a 100 kilowatt generators.
Create a query to display inventory information based on a specific generator’s kilowatt value.
Create a new table to display purchase information based on a specific generator’s kilowatt value.

Answer 8

Create a query to display purchase information based on a specific generator’s kilowatt value.

Question 9

Janus needs to search her alumni class table in ascending order by city names. Which of the following is the BEST example of a sort in ascending order?
Austin, Bakersfield, Van Dyke, Van Dyke
Bakersfield, Louisville, Austin, Van Dyke
Austin, Bakersfield, Louisville, Van Dyke
Van Dyke, Louisville, Bakersfield, Austin

Answer 9

Austin, Bakersfield, Louisville, Van Dyke

Question 10

A local provider of safe shelters for animals wants to use a database to find those donors who might be willing to make multiple donations to their cause, they’re unsure if MS Access is a good choice for this process. Which of the following tasks would be MOST appropriate for using Access database?
Organizing civil records concerning animal abuse..
Delivering an oral presentation for policymakers.
Tracking and studying data about prior donors.
Keeping data on contributors any non-profit organization.

Answer 10

Tracking and studying data about prior donors.

Question 11

You’ve need to build a database for your Personal Protection firm to store unique and separate information about for the education level, population growth, crimes by geographical area. What is the MOST REPRESENTATIVE order used in MS Access to gather information from each table and combine the data into a new report for analysis by management?
Create a large table, then create a new Query Report.
Create three separate tables, connect with a Primary Key, then create a new Query Report.
Create three separate tables, connect with a Primary Key, then create a new Blank Database.
Combine the data from three separate tables, then create a new Table Report.

Answer 11

Create three separate tables, connect with a Primary Key, then create a new Query Report.

Question 12

Cassie created a basic report using her data mining skills from a data table she received from her employer. After giving her employer the report, Cassie was told the information lacked relevant information and needs to be reordered by city. Which of the following would allow Cassie to design the most complete report?
Create a new table with more fields of relevance.
Create a new report with the new fields and sorted by city.
Create a new report and remove all unnecessary fields.
Create a new report filtered by city with the new data fields.

Answer 12

Create a new report with the new fields and sorted by city.

Question 13

Which of the following is a technique which applies a predictive model that learns through training?
  An actual natural network. 
  An artificial natural network. 
  An accredited neural network. 
  An artificial neural network.

Answer 13

An artificial neural network.

Question 14

Marta needs to create a database of all the patients in a hospital along with their patient name, age, gender, physical condition, weight information and dietary requirements. Her coworkers need an copy of this information alphabetized by patient, age, weight and food restrictions. What are the BEST procedures for Kayla take to complete this reporting requirement?
Enter the data into separate tables and create a report.
Design the report, sort, and print the report.
Create the table, enter the data, and create a Query.
Create the table structure, create the report, and enter the data.

Answer 14

Create the table, enter the data, and create a Query.

Question 15

Which answer BEST represents how we think about artificial intelligence, statistics and the technical aspects of data mining?
We call data mining advanced learning for marketing applications.
We call data mining machine learning for business applications.
We call data mining system utilization for technical applications.
We call data mining machine learning for business instruction.

Answer 15

We call data mining system utilization for technical applications.

Question 16

Which of these best describes the predictive capacity of data mining?
Data Mining has changed the design of business strategies by helping us understand the present in order to anticipate the future.
Data Mining has caused reversals of database strategies by helping us understand the present in order to recall the past.
Data Mining has slowed the execution of business strategies.
Data Mining has changed the development Database Management Systems.

Answer 16

Data Mining has changed the design of business strategies by helping us understand the present in order to anticipate the future.

Question 17

According to a April, 2018 edition of Forbes Magazine, what percentage of organizations apply data mining as a strategic practice which they consider to be important to their business intelligence?
  Almost 60%. 
  Almost 70%. 
  Almost 80%. 
  Almost 90%.

Answer 17

Almost 80%.

Question 18

Which of the following best represent the purposes of data mining?
Data Mining eliminates relevant information and uses it to evaluate possible results.
Data Mining identifies irrelevant information and uses it to evaluate possible results.
Data Mining identifies relevant information and uses it to evaluate possible results.
Data Mining identifies realistic inquiries and uses it to eliminate possible results.

Answer 18

Data Mining identifies relevant information and uses it to evaluate possible results.

Question 19

Many industries use data mining for help their business perform better. What is one way banks use information to analyze their performance?
Banks use data mining to take more financial risks.
Banks use data mining to completely eliminate market risks.
Banks use data mining to pick company industry winners and losers.
Banks use data mining to better understand market risks.

Answer 19

Banks use data mining to better understand market risks.

Question 20

In Unit 08, Lesson 02, you learned more about how to create a form. What process did you see used to create a form?
  A Form Creator. 
  A Form View. 
  A Form Wizard. 
  A Form Design.

Answer 20

A Form Wizard.

Question 21

Mia is responsible for the Robot Club’s database. When she is asked to sort a database, which statement BEST REPRESENTS what she would be expected to do?
Find a professional who can take a computer apart.
Identify the fields and types.
Divide the database into different folders.
Arrange the data in a certain order.

Answer 21

Arrange the data in a certain order.

Question 22

Once your data table is built and your data has been entered, what is the difference between sorting and filtering records?
Sorting reduces the number of records being viewed. Filtering only changes the order of records.
Sorting and filtering records performs the same function.
Sorting changes the order of records. Filtering creates a new word processing document containing the selected data.
Sorting changes the order of records. Filtering only reduces the number of records being viewed.

Answer 22

Sorting changes the order of records. Filtering only reduces the number of records being viewed.

Question 23

In Unit 08, Lesson 02, you learned how to save a MS Access Form as a document, how was this accomplished?
Click Save As, Save Data As a .pdf.
Click Save As, Save Form As a .pdf.
Click Save As, Save Object As a .xlxs.
Click Save As, Save Object As a .pdf.

Answer 23

Click Save As, Save Object As a .pdf.

Question 24

Data mining is commonly used by supermarkets and other retailers to encourage new sales to existing customers. Which statement best explains how retailers might apply data mining?
Data mining allows retailers to respect the privacy of their customers which helps them avoid offers that are most valued by the customers.
Data mining allows retailers to get to know their customers which helps them identify which offers are most valued by the customers.
Data mining detects which purchases are least valued by wholesalers and helps customers optimize the return on their marketing campaigns.
Data mining identifies which products are too expensive for retailers and and helps strengthen relationships between customers.

Answer 24

Data mining allows retailers to get to know their customers which helps them identify which offers are most valued by the customers.

Question 25

How do media networks commonly use data to gain valuable knowledge for their advertisers? To target their past customers more swiftly. To target their potential customers more accurately. To target customers of competitors more accurately. To target their potential employees.

Answer 25

To target their potential customers more accurately.

Question 26

Darrell is the Captain of the basketball team at his school. At new player orientation, he wants to leave a computer on a table for interested students to enter their contact information without seeing other player's information. What is the BEST way for Darrell to do this? Open a database in Design View. Open a database in Layout View. Lock the database from editing so players can not see other players' information when they enter their own information. Create a form for potential players to enter their information.

Answer 26

Create a form for potential players to enter their information.

Question 27

How can applications like MS Excel or Google Sheets be used similarly to MS Access to create a data table with data types? The applications can show forms intended to replicate the data entry task. The applications can show cells intended to activate the data type system. The applications can show cells intended to replicate the data field structure. The applications can show forms and fields that exactly duplicate the data field structure.

Answer 27

The applications can show cells intended to replicate the data field structure.

Question 28

When modifying an information database, what modification is MOST risky in terms of potentially losing data? Adding rows and columns can eliminate needed data and fields. Deleting needed data and fields can eliminate rows and columns . Deleting rows and columns can eliminate unneeded data and fields. Deleting rows and columns can eliminate fields needed for data input and retrieval, so be cautious.

Answer 28

Deleting rows and columns can eliminate fields needed for data input and retrieval, so be cautious.

Question 29

Why is having all of the patient's information such as medical records, physical examinations, and treatment patterns generally important to hospitals and doctors? This allows for dictating more accurate fee structures and effective treatments. This allows for making more accurate medical diagnoses and prescribing more effective treatments. This allows for directing more accurate record keeping and effective storage. This allows for prescribing more accurate diagnostics and expensive treatments.

Answer 29

This allows for making more accurate medical diagnoses and prescribing more effective treatments.

Question 30

``` Which industry would MOST benefit from intelligent use of anti-fraud systems to analyze purchasing patterns and transactions, apply credit ratings to card issuance and customer financial data? The Marketing Industry. The Commercial Media Industry. The Retailing Industry. The Banking Industry. ```

Answer 30

The Banking Industry.

Question 31

As a Data Mining Analyst, which of the following would BEST describe your expertise? You would be an expert in standard information delivery, capable of envisioning creative ideas from the results of mined data. You would be an expert in intelligence management, capable of envisioning creative ideas as a result data entry. You would be an expert in intelligence information dissemination, capable of creating reports from the results of competitors data. You would be an expert in intelligence information gathering, capable of envisioning creative ideas from the results of mined data.

Answer 31

You would be an expert in intelligence information gathering, capable of envisioning creative ideas from the results of mined data.

Question 32

Before you invest time and money into creating a database, you need a plan. Which summary BEST describes a good database plan? The plan would create an outline for understanding the way data is stored and managed by most people using it. The plan would develop a general understanding for the way data is entered and delivered by every person using it. The plan would develop a clear understanding for the way data is stored and managed by every person using it. The plan would develop a clear understanding for the way data is stored and utilized by management.

Answer 32

The plan would develop a clear understanding for the way data is stored and managed by every person using it.

Question 33

How would a Database Administrator plan a system for present and future growth? The planning would highlight necessary fields for a solid structure. The planning process would provide a framework to identify a solid structure for growth. The planning process would purchase an outside software to identify a solid structure for more storage capacity. The planning process would mandate a pre-defined structure for growth.

Answer 33

The planning process would provide a framework to identify a solid structure for growth.

Question 34

In database terminology, what is a dataset? A dataset is a collection of data yet to be entered into a database. A dataset is a collection of data fields. A dataset is a culmination of multiple data tables. A dataset is a collection of data.

Answer 34

A dataset is a collection of data.

Question 35

``` When you built the Reptile Hose Database in MS Excel or Google Sheets, why did you delete the text in cells A1 and A2? You needed to "insert" new fields. You needed to "copy" a clean table. You needed to "clean up" the table. you needed to "clean up" the fields. ```

Answer 35

You needed to "clean up" the table.

Question 36

``` Which management function involves evaluating your goals, improving performance, and taking action? organizing planning implementing controlling ```

Answer 36

controlling

Question 37

Lisa has been promoted to a management position in the Marketing department. Her first task as manager is to increase product awareness among the general public. What kind of information does Lisa need to receive in order to determine and create plans? effective accurate important efficient

Answer 37

accurate

Question 38

``` When Ricky speaks to his staff members during their weekly team meetings he uses certain words or non-verbal methods such as body gestures to help translate the information into the message he is delivering to his staff. What are these methods called? sending decoding encoding receiving ```

Answer 38

encoding

Question 39

Which of these is the second step in the information process? Information is processed and organized. Information is communicated to the proper channels. Information is filtered where it needs to go. Technology produces and collects information.

Answer 39

Information is filtered where it needs to go.

Question 40

Lucy is attending leadership development training. During an effective leadership development training, Lucy will learn which of the following? significant problems in an organization the evolution of information systems the difference between software and hardware the strategic role information systems and communication

Answer 40

the strategic role information systems and communication

Question 41

Department and functional areas within an organization are known to have their own set of application programs, or information system that they work with and is specific to their type of work. Regardless of the type of information system, they all have common components. Which one of these is NOT a common component for an information system? Software Data People Competition

Answer 41

Competition

Question 42

What makes the communication process complex? how accurately is the message received the way information is distributed connecting employees implementing procedures

Answer 42

how accurately is the message received

Question 43

``` In the information communication technology process, which one below is the device or technology that is used to transport the message between the encoder and the decoder through a internet network? Sender Receiver Medium Decoder ```

Answer 43

Medium

Question 44

Liz would like to promote a workplace culture that encourages open communication and reduces tension between levels of employees, both professionally and socially. By changing the workplace culture with effective communication, how will this benefit the organization? Creates commitment Builds Relationships Creates commitment Defines expectations

Answer 44

Builds Relationships

Question 45

``` Kevin is part of the management team at a large accounting firm. In his management role, Kevin works with his team to choose appropriate goals and actions to pursue, determine what strategies to use, what actions to take, and to decide what resources are needed to achieve the goals. What management function is Kevin using? Controlling Organizing Leading Planning ```

Answer 45

Planning

Question 46

Steve has been working with his organization for 20 years. He offers effective communications advice to new managers based on his experience. Which advice is Steve most likely to give? People perform much better when they are informed and involved People perform much better when they admired and respected People perform much better when they uncomfortable and uncooperative People perform much better when they reviewed and evaluated

Answer 46

People perform much better when they are informed and involved

Question 47

Michael is the CEO of a large organization and he really wants to listen to the concerns that employees have. Michael has worked with the organization's technology department to develop an employee network that allows employees to submit suggestions on their work and their workplace. The information will be collected, filtered, processed, and communicated to the executive leadership team. What benefit of effective communication will the organization receive by listening and giving consideration to employee suggestions? Provides clarity Builds Relationships Creates commitment Defines expectations

Answer 47

Creates commitment

Question 48

Think about all of the people who are in different departments and clusters within an organization, executives, managers, supervisors, support staff, maintenance, and many others. While each of these departments work separately, there are information systems and various communication technology tools in place that let them work together. Which of these tools is least likely to be used to assist departments in working together? Email Cloud sharing Computer network Scanner

Answer 48

Scanner

Question 49

Sobia has been a manager for 10 years. In her position Sobia has learned that getting clear and accurate information to her employees is a tremendous asset for her department and the organization. But in this "information world" it is not easy to keep information organized for individuals, let alone businesses. As a result, it is important that business leaders that use information systems and information communication technology to do which of these? make their design strategic make their design clear make their design direct make their design focused

Answer 49

make their design strategic

Question 50

When the receiver responds it ensures the receiver has received the message and interpreted it the way it was intended by the sender. The response of the receiver can be verbal or non-verbal. What part of the communication process is this? Feedback Decoding Sender Channel

Answer 50

Feedback

Question 51

``` If executives plan and create a business strategy, then which responsibilities do the managers have? communicate the strategy execute the strategy manage the strategy contribute to the strategy ```

Answer 51

execute the strategy

Question 52

An organization is considering upgrading all the information communication technology in the workplace. Which of these are apporpriate reasons for the upgrade? I. instantly message co workers about weekend plans II. Financial transactions and information retrieval take seconds III. employees can perform work tasks from almost anywhere I only II only I and III only II and III only

Answer 52

II and III only

Question 53

A company achieves strategic advantage by using which of these? strategy to maximize its strengths resulting in a competitive advantage by using computers and other digital devices taking advantage of costumer at a geographical distances Reminding employees that information systems are built with strategic purpose to solve problems

Answer 53

taking advantage of costumer at a geographical distances

Question 54

``` Employees do not have to come to the office to carry out their work as long as their jobs only involve the use and creation of information. This is an example of which of these? Flexible and mobile workforce Better business communication Alternative channels Greater efficiency ```

Answer 54

Greater efficiency

Question 55

Which of these best describe the term telecommunication? the ability to managing and expedite their work transaction a strategic way to improve business processes networking technologies technologies that allow communications over a distance

Answer 55

technologies that allow communications over a distance

Question 56

``` When no physical objects need to be transferred from one place to another, telecommunications technology can make geographical distance irrelevant. This example of which business process? Better business communication Better distribution of data Instant transactions Alternative channels ```

Answer 56

Better business communication

Question 57

Matt Mullenweg, cofounder of Wordpress and CEO of Automattiche described their workforce as which of these? mobile remote distributed telecommute

Answer 57

distributed

Question 58

``` Lucy has request that all staff meetings are recorded electronically. This will allow everyone in the organization to have immediate access to the meeting even when employees are located fin different parts of the world. This is an example of which business process? Instant transactions Greater efficiency Alternative channels Better distribution of data ```

Answer 58

Greater efficiency

Question 59

Carmen has recently completed a research report on how implementing information systems have allowed organizations the ability to create strategies that benefit organizations. Which strategy would you most likely find in Carmen's report? maximized sales and lowered costs departments within an organization to work cohesively, difficulty outperforming competitors creating a market for new products or service

Answer 59

maximized sales and lowered costs

Question 60

Roger would like to present the idea of implementing a new information system to the executive leadership team. He would like to emphasize great efficiency. Which of these areas of business would be his best selling point? employee commitment business operations customer satisfaction organizational structure

Answer 60

business operations

Question 61

``` Leslie has created a product that is not sold any where in the world. This product will be the first of its kind on the market and is an example of which action taken by businesses? Strategic advantage Competition Strategy Competitive advantage ```

Answer 61

Strategy

Question 62

Information systems are built for which strategic purpose? for physical transfer of goods or local services. to solve problems and to seize opportunities. for insignificant in business transactions. to lower sales and increase costs.

Answer 62

to solve problems and to seize opportunities.

Question 63

``` Matt Mullenweg, cofounder of Wordpress and CEO of Automattiche stated "at the base of the decision to go distributed there was a desire to give people" which of the following? Rules Excitement Boundaries Autonomy ```

Answer 63

Autonomy

Question 64

An organization is updating their information systems with technologies that will allow them the ability to broadcast and provide telephone services over the internet. Which strategic way to improve business processes would they be implementing? Flexible and mobile workforce Better business communication Providing alternative channels Greater efficiency

Answer 64

Providing alternative channels

Question 65

``` In a workplace, which of these best categorizes the telephone, email, and the World Wide Web? reliable telecommunications essential business services networking technologies Instant transactions ```

Answer 65

essential business services

Question 66

Laura, project manager for the Information Technology department would like to use a program that could encompass several projects, such as providing more wireless Internet access, upgrading hardware and software, enhancing computer security, and developing and maintaining corporate standards for IT. Which best describes the program that Laura is using? Applications development Immersive Experience Infrastructure User support

Answer 66

Infrastructure

Question 67

Which of these is the best definition for project management? A set of activities that is performed based on knowledge, skills, tools and equipment to ensure the timely and successful completion of a project requirement. Applications facilitate the process of meeting specific scope, time, cost, and quality goals of projects A new system to increase sales, employee productivity, and monitors customer services is designed for companies. The systems will work on laptops, smartphones, and tablet Projects that can range in size, from large too small.

Answer 67

A set of activities that is performed based on knowledge, skills, tools and equipment to ensure the timely and successful completion of a project requirement.

Question 68

``` As project manager, which tool and techniques would best ensure that Liz and her teams stay within the budget allowed for the project they are developing? Data gathering Decision making Data representation Data analysis ```

Answer 68

Data analysis

Question 69

``` Derrick is meeting with his project management team. His goal for this meeting is to brainstorming, create checklists, discuss using focus groups and developing questionnaires and surveys, and statistical sampling. What tools and techniques will the team be using? Data representation Data gathering Communication Data analysis ```

Answer 69

Data gathering

Question 70

``` A project life cycle is defined as being a collection of project phases. Which phase is not part of the project life cycle? Carrying out the work Starting the project Documenting the project Finishing the project ```

Answer 70

Documenting the project