Exam 2: Creating a Database

Identify the letter of the choice that best matches the phrase or definition.

Stores Yes/No, True/False, or On/Off values.

Memo

Stores dates, times, or a combination of both.

Yes/No

Accepts field values containing letters, numbers, spaces, and certain symbols.

Currency

Correct Answer:

Verified

Stores Yes/No, True/False, or On/Off values.

Stores dates, times, or a combination of both.

Accepts field values containing letters, numbers, spaces, and certain symbols.

Stores long passages of text.

Accepts monetary values and displays them with a dollar sign and decimal point.

(Matching)

4.9/5

(37)

Question 41

A Text field can store up to 155 characters and is used to store data such as names and addresses.

(True/False)

4.9/5

(29)

Question 42

You can also use a Quick Start selection to add commonly used fields to an existing table. In the Add & Delete group on the ____ tab, click the More Fields button, scroll down to the Quick Start section, and then click a Quick Start selection to add fields to the table.

(Multiple Choice)

4.8/5

(38)

Question 43

To insert a new field between two existing rows in a table, click the row selector for the row above where you want the new field to appear.

(True/False)

4.9/5

(38)

Question 44

When you need to change the data type for a selected field, you can do so by clicking the Data Type arrow in the ____ group on the Fields tab.

(Multiple Choice)

4.9/5

(43)

Question 45

The ____________________ database template creates a database with an empty table in it.

(Short Answer)

4.7/5

(37)

Question 46

Showing 41 - 46 of 46

Exam 2: Creating a Database

A Text field can store up to 155 characters and is used to store data such as names and addresses.

You can also use a Quick Start selection to add commonly used fields to an existing table. In the Add & Delete group on the ____ tab, click the More Fields button, scroll down to the Quick Start section, and then click a Quick Start selection to add fields to the table.

To insert a new field between two existing rows in a table, click the row selector for the row above where you want the new field to appear.

When you need to change the data type for a selected field, you can do so by clicking the Data Type arrow in the ____ group on the Fields tab.

The ____________________ database template creates a database with an empty table in it.

Microsoft Access Basics

Creating Queries

Creating and Modifying Forms

Creating and Modifying Reports

Integrating Access

Enhancing Table Design

Using Advanced Queries

Using Advanced Form Features

Adding Advanced Features to Reports

Creating and Running Macros

Automating Database Processes

Programming in Access

Creating Database Security and Documentation

Microsoft Excel Basics

Using Advanced Chart Features

Improving Data Accuracy

Creating Pivottables and Pivotcharts

Using Powerful Excel Functions

Creating and Using Macros

Working With Auditing and Analysis Tools

Protecting, Tracking, and Sharing Workbooks

Importing and Exporting Data

Changing the Appearance of a Worksheet

Organizing the Worksheet

Entering Worksheet Formulas

Using Functions

Enhancing a Worksheet

Working With Multiple Worksheets and Workbooks

Working With Charts

Applying Advanced Formats to Worksheets

Microsoft Office 2010 and the Internet

Microsoft Powerpoint Basics

Sharing and Delivering Presentations

Creating Enhancing Powerpoint Presentations

Working With Visual Elements

Expanding on Powerpoint Basics

Editing and Formatting Slide Content

Working With Tables and Charts

Working With Visual and Sound Objects

Customizing Slides

Importing and Exporting Information

Microsoft Word Basics

Working With Templates and Styles

Customizing Tables and Creating Charts

Creating Mail Merge Documents

Sharing Documents

Working With Long Documents

Creating Indexes and Tables of Contents, Figures, and Authorities

Working With Long Documents

Creating Indexes and Tables of Contents, Figures, and Authorities

Basic Editing

Helpful Word Features

Formatting Text

Formatting Paragraphs and Documents

Working With Graphics

Working With Documents

Increasing Efficiency Using Word

Enhancing Documents

Filters