Question 1

A user can readily create data entry forms,queries,and sophisticated and professional reports with the help of ________.

Accepted Answer

A)  Microsoft Publisher 
B)  Microsoft Access 
C)  Microsoft Word 
D)  Microsoft Excel 
A)  Microsoft Publisher 
B)  Microsoft Access 
C)  Microsoft Word 
D)  Microsoft Excel

Question 2

How can Excel be used to graph Access data?

Accepted Answer

Access data,including queries,can be imp

Question 3

If a column heading and the corresponding numerical data are highlighted and used to create a pie chart,the heading will appear as the chart title.

Accepted Answer

A) True 
 B)False

Question 4

What is import/export of data? Why is it necessary to refresh the import/export data in Excel and Access on a timely basis?

Accepted Answer

Import/export is the process of transfer

Question 5

The Average function and Group By cannot be used in the same query.

Accepted Answer

A) True 
 B)False

Question 6

Which of the following statements is true of delimited files?

Accepted Answer

A)  Access can import only tab-delimited files. 
B)  Delimited files cannot be imported by Excel. 
C)  A comma-delimited file has data that contains commas. 
D)  Field values in a tab-delimited file are separated by tabs. 
A)  Access can import only tab-delimited files. 
B)  Delimited files cannot be imported by Excel. 
C)  A comma-delimited file has data that contains commas. 
D)  Field values in a tab-delimited file are separated by tabs.

Question 7

Excel is superior to Access for tracking orders,inventory,equipment,and people.

Accepted Answer

A) True 
 B)False

Question 8

How are group totals created in Access?

Accepted Answer

Open the relevant database,click the CRE

Question 9

A user can produce two different reports from a single set of Excel data,by importing this data into Access and using the Access report generator.

Accepted Answer

A) True 
 B)False

Question 10

A school stores attendance records of its students on an Access database: The Attendance table has StudentName,StudentID,Grade,and DateAbsent columns: Each time a student is absent,an entry is made into the database: Which of the following statements is true?

Accepted Answer

A)  To find the average number of days students of each grade are absent, Group By should be selected under Grade and Avg under StudentID. 
B)  To find the number of days each student is absent, Group By should be selected for StudentID and Count for DateAbsent. 
C)  To see which students were absent on a particular day, Group By should be selected for StudentName. 
D)  To see the number of students absent in a particular grade on a given day, Group By should be selected for both DateAbsent and StudentID. 
A)  To find the average number of days students of each grade are absent, Group By should be selected under Grade and Avg under StudentID. 
B)  To find the number of days each student is absent, Group By should be selected for StudentID and Count for DateAbsent. 
C)  To see which students were absent on a particular day, Group By should be selected for StudentName. 
D)  To see the number of students absent in a particular grade on a given day, Group By should be selected for both DateAbsent and StudentID.

A user can readily create data entry forms,queries,and sophisticated and professional reports with the help of ________.

How can Excel be used to graph Access data?

If a column heading and the corresponding numerical data are highlighted and used to create a pie chart,the heading will appear as the chart title.

What is import/export of data? Why is it necessary to refresh the import/export data in Excel and Access on a timely basis?

The Average function and Group By cannot be used in the same query.

Which of the following statements is true of delimited files?

Excel is superior to Access for tracking orders,inventory,equipment,and people.

How are group totals created in Access?

A user can produce two different reports from a single set of Excel data,by importing this data into Access and using the Access report generator.

A school stores attendance records of its students on an Access database: The Attendance table has StudentName,StudentID,Grade,and DateAbsent columns: Each time a student is absent,an entry is made into the database: Which of the following statements is true?

The Importance of Mis

Business Processes information Systems and Information

Organizational Strategy information Systems and Competitive Advantage

Hardware and Software

Database Processing

The Cloud

Organizations and Information Systems

Social Media Information Systems

Business Intelligence Systems

Information Systems Development

Information Systems Management

Information Security Management

Collaboration Information Systems for Decision Making problem Solving and Project Management

Collaborative Information Systems for Student Projects

Mobile Systems

Introduction to Microsoft Excel 2013

Database Design

Using Microsoft Access 2013

Network and Cloud Technology

Enterprise Resource Planning ERP Systems

Supply Chain Management

Hyper-Social Organizations and Knowledge Management

Database Marketing

Reporting Systems and OLAP

Geographic Information Systems GIS

Systems Development Project Management

Agile Development

Business Process Management

International Mis

Filters

Exam 19: Using Excel and Access Together

A user can readily create data entry forms,queries,and sophisticated and professional reports with the help of ________.

How can Excel be used to graph Access data?

If a column heading and the corresponding numerical data are highlighted and used to create a pie chart,the heading will appear as the chart title.

What is import/export of data? Why is it necessary to refresh the import/export data in Excel and Access on a timely basis?

The Average function and Group By cannot be used in the same query.

Which of the following statements is true of delimited files?

Excel is superior to Access for tracking orders,inventory,equipment,and people.

How are group totals created in Access?

A user can produce two different reports from a single set of Excel data,by importing this data into Access and using the Access report generator.

A school stores attendance records of its students on an Access database: The Attendance table has StudentName,StudentID,Grade,and DateAbsent columns: Each time a student is absent,an entry is made into the database: Which of the following statements is true?

The Importance of Mis

Business Processes information Systems and Information

Organizational Strategy information Systems and Competitive Advantage

Hardware and Software

Database Processing

The Cloud

Organizations and Information Systems

Social Media Information Systems

Business Intelligence Systems

Information Systems Development

Information Systems Management

Information Security Management

Collaboration Information Systems for Decision Making problem Solving and Project Management

Collaborative Information Systems for Student Projects

Mobile Systems

Introduction to Microsoft Excel 2013

Database Design

Using Microsoft Access 2013

Network and Cloud Technology

Enterprise Resource Planning ERP Systems

Supply Chain Management

Hyper-Social Organizations and Knowledge Management

Database Marketing

Reporting Systems and OLAP

Geographic Information Systems GIS

Systems Development Project Management

Agile Development

Business Process Management

International Mis

Filters