Filters
Question type
Study Flashcards

The ________ displays the number of the current record as well as the total number of records in a table.

Correct Answer

verifed

verified

A(n)________ is a number,phrase,or expression used to select records from a table.

Correct Answer

verifed

verified

Microsoft ________ is the database management system included in Office 20013 Professional.

Correct Answer

verifed

verified

The ________ utility of Access helps reduce the size of a database.

Correct Answer

verifed

verified

Offer three examples of interactions that you may have had with databases (knowingly or unknowingly)within the last week.

Correct Answer

verifed

verified

Students answers will vary.Some examples...

View Answer

Use ________ if you have a large amount of data and may need to group,sort,and total the data based on various parameters.

Correct Answer

verifed

verified

A complete set of all fields about one person or event is called a field.

Correct Answer

verifed

verified

People use databases to store collections of data.

Correct Answer

verifed

verified

A field that is defined as a primary key in one table is defined as a(n) ________ in a related table.


A) referential integrity key
B) relational database
C) foreign key
D) primary2 key

Correct Answer

verifed

verified

The F2 key puts you in Edit mode when in Access.

Correct Answer

verifed

verified

The process of saving in Access is nearly the same as it is in other Microsoft Office applications.

Correct Answer

verifed

verified

A template is a predefined database that can be used to jumpstart the creation of a database.

Correct Answer

verifed

verified

Match the following parts of an Access window to their descriptions:

Premises
Backstage view
Ribbon
title bar
Field Properties pane
Navigation Pane
Responses
provides access to database tools such as Save,Save As,and Print
area that organizes and lists database objects
displays full path name and file name
includes five tabs
contains details of each field

Correct Answer

Backstage view
Ribbon
title bar
Field Properties pane
Navigation Pane

Both Access and Excel contain tools that can be used to extract and analyze information.

Correct Answer

verifed

verified

Which of the following best describes information?


A) Information is a converted into fields and records within a table in a database.
B) Information is converted into data that can be selected and sorted for business or personal use.
C) Information is what is entered into a database.
D) Information is the finished product that is produced by a database.

Correct Answer

verifed

verified

Which of the following is NOT a tab in Access 2013?


A) Create
B) Home
C) Format
D) File

Correct Answer

verifed

verified

A sort can only list records in a database in a specific numeric sequence.

Correct Answer

verifed

verified

You can create or modify a table's field names and data types in ________ view.


A) Report
B) Form
C) Datasheet
D) Design

Correct Answer

verifed

verified

Filter by Form uses the AND and OR logical operators.

Correct Answer

verifed

verified

Tables,queries,reports,and forms are all examples of ________.

Correct Answer

verifed

verified

Showing 41 - 60 of 100

Related Exams

Exam 1

Office Fundamentals and File Management

100 Questions

Exam 3

Word: Document Presentation: Editing and Formatting

100 Questions

Exam 4

Word: Document Productivity: Working With Tables and Mail Merge

100 Questions

Exam 5

Word: Collaboration and Research: Communicating and Producing Professional Papers

100 Questions

Exam 6

Word: Desktop Publishing and Graphic Design: Creating a Newsletter, working With Graphics, and Linking Objects

100 Questions

Exam 7

Word: Time Saving Tools: Using Templates, multiple Documents, and Themes

100 Questions

Exam 8

Word: Document Automation: Forms,macros,and Security

100 Questions

Exam 9

Word: Word and the Internet: Web Page Creation and Enhancement, and Blogs

104 Questions

Exam 10

Power: Introduction to Powerpoint: Creating a Basic Presentation

108 Questions

Exam 11

Power: Presentation Development: Planning and Preparing a Presentation

111 Questions

Exam 12

Power: Presentation Design: Illustrations and Infographics

102 Questions

Exam 13

Power: Powerpoint Rich Media Tools: Enhancing With Multimedia

100 Questions

Exam 14

Power: Infographics: Creating Text Charts, tables, and Graphs

100 Questions

Exam 15

Power: Interactivity and Advanced Animation: Engaging the Audience

100 Questions

Exam 16

Power: Customization: Customizing Powerpoint and the Slide Show

100 Questions

Exam 17

Power: Collaboration and Distribution: Collaborating, preparing, securing, and Sharing a Presentation

100 Questions

Exam 18

Excel: Introduction to Excel: What Is a Spreadsheet

100 Questions

Exam 19

Excel: Formulas and Functions: Performing Quantitative Analysis

100 Questions

Exam 20

Excel : Charts: Depicting Data Visually

100 Questions

Exam 21

Excel: Datasets and Tables: Managing Large Volumes of Data

100 Questions

Exam 22

Excel: Subtotals, Pivot-tables, and Pivot-charts

103 Questions

Exam 23

Excel : What-If Analysis

103 Questions

Exam 24

Excel: Specialized Functions

103 Questions

Exam 25

Excel: Statistical Functions

103 Questions

Exam 26

Excel : Multiple-Sheet Workbook Management

103 Questions

Exam 27

Excel: Imports, web Queries, and Xml

103 Questions

Exam 28

Excel : Collaboration and Workbook Distribution

108 Questions

Exam 29

Excel: Templates, styles, and Macros

103 Questions

Exam 31

Access: Tables and Queries in Relational Databases: Designing Databases and Extracting Data

100 Questions

Exam 32

Access: Customize,analyze,and Summarize Query Data: Creating and Using Queries to Make Decisions

100 Questions

Exam 33

Access: Creating and Using Professional Forms and Reports: Moving Beyond Tables and Queries

100 Questions

Exam 34

Access: Data Validation and Data Analysis: Reducing Errors and Extracting Better Information

100 Questions

Exam 35

Access : Action and Specialized Queries: Moving Beyond the Select Query

100 Questions

Exam 36

Access: Advanced Forms and Reports: Moving Beyond the Basics

100 Questions

Exam 37

Access: Get Connected: Exchanging Data Between Access and Other Applications

100 Questions

Exam 38

Access: Fine-Tuning the Database: Analyzing and Improving Database Performance

100 Questions

Show Answer