Sem 2- (6 week 2) Flashcards
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.
Design view is where you create data fields and types that contain the data.
What is MOST likely field being tracked using the type of data in Table 2? Location by County Business Partners Identifiers Customer Last Names
Customer Last Names
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.
Multiple databases with data from one or more sources.
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.
Yung, Trevino, Sterling, Sonez, Polan, Crowley.
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
Yung, Fun Fitness Club, Trainer
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.
Data mining detects which offers are most valued by customers.
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.
Queries are more long-term in that they can be saved and accessed again later.
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.
Create a query to display purchase information based on a specific generator’s kilowatt value.
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
Austin, Bakersfield, Louisville, Van Dyke
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.
Tracking and studying data about prior donors.
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.
Create three separate tables, connect with a Primary Key, then create a new Query Report.
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.
Create a new report with the new fields and sorted by city.
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.
An artificial neural network.
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.
Create the table, enter the data, and create a Query.
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.
We call data mining system utilization for technical applications.
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.
Data Mining has changed the design of business strategies by helping us understand the present in order to anticipate the future.
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%.
Almost 80%.
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.
Data Mining identifies relevant information and uses it to evaluate possible results.
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.
Banks use data mining to better understand market risks.
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.
A Form Wizard.
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.
Arrange the data in a certain order.
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.
Sorting changes the order of records. Filtering only reduces the number of records being viewed.
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.
Click Save As, Save Object As a .pdf.
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.
Data mining allows retailers to get to know their customers which helps them identify which offers are most valued by the customers.
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.
To target their potential customers more accurately.
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.
Create a form for potential players to enter their information.
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.
The applications can show cells intended to replicate the data field structure.
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.
Deleting rows and columns can eliminate fields needed for data input and retrieval, so be cautious.
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.
This allows for making more accurate medical diagnoses and prescribing more effective treatments.
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.
The Banking Industry.
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.
You would be an expert in intelligence information gathering, capable of envisioning creative ideas from the results of mined data.
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.
The plan would develop a clear understanding for the way data is stored and managed by every person using it.
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.
The planning process would provide a framework to identify a solid structure for growth.
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.
A dataset is a collection of data.
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.
You needed to “clean up” the table.
Which management function involves evaluating your goals, improving performance, and taking action? organizing planning implementing controlling
controlling
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
accurate
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
encoding
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.
Information is filtered where it needs to go.
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
the strategic role information systems and communication
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
Competition
What makes the communication process complex?
how accurately is the message received
the way information is distributed
connecting employees
implementing procedures
how accurately is the message received
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
Medium
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
Builds Relationships
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
Planning
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
People perform much better when they are informed and involved
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
Creates commitment
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
Scanner
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
make their design strategic
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
Feedback
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
execute the strategy
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
II and III only
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
taking advantage of costumer at a geographical distances
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
Greater efficiency
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
technologies that allow communications over a distance
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
Better business communication
Matt Mullenweg, cofounder of Wordpress and CEO of Automattiche described their workforce as which of these?
mobile
remote
distributed
telecommute
distributed
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
Greater efficiency
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
maximized sales and lowered costs
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
business operations
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
Strategy
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.
to solve problems and to seize opportunities.
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
Autonomy
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
Providing alternative channels
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
essential business services
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
Infrastructure
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.
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.
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
Data analysis
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
Data gathering
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
Documenting the project
