Exam 1: Access: Introduction to Access

arrow
  • Select Tags
search iconSearch Question
flashcardsStudy Flashcards
  • Select Tags

If you sorted a table which had 53 records by two fields, one ascending and the other descending, how many records would display?

Free
(Multiple Choice)
4.8/5
(25)
Correct Answer:
Verified

B

Reports can draw data from tables or queries.

Free
(True/False)
4.8/5
(33)
Correct Answer:
Verified

True

Match each of the slide layouts terms to their meanings:
Title Slide
Contains no placeholders
Two Content
Contains placeholders for a title and content
Blank
Contains placeholders for a title and subtitle
Correct Answer:
Verified
Premises:
Responses:
Title Slide
Contains no placeholders
Two Content
Contains placeholders for a title and content
Blank
Contains placeholders for a title and subtitle
Picture with Caption
Contains placeholders for an image and text
Title and Content
Often used to put text on one side of a slide and graphic content on the other side
Free
(Matching)
4.8/5
(35)
Correct Answer:
Verified

When you enter items into a database, you are entering ________.

(Short Answer)
5.0/5
(37)
Match the following terms with their meanings:
Easy Connect
Someone providing assistance who is using an earlier version of Windows can use this.
Invitation File
Software that directs computer activities
Help and Support
An app that provides user assistance on topics or procedures
Correct Answer:
Verified
Premises:
Responses:
Easy Connect
Someone providing assistance who is using an earlier version of Windows can use this.
Invitation File
Software that directs computer activities
Help and Support
An app that provides user assistance on topics or procedures
Password
Someone connecting your computer that is also using Windows 10
Operating System
The first time you use Easy Connect you will need this.
(Matching)
4.9/5
(33)

A good practice is to make backups of your databases on different storage devices.

(True/False)
4.8/5
(35)

A ________ allows you to select only the records you want.

(Short Answer)
4.9/5
(32)

A module uses what programming language?

(Multiple Choice)
4.8/5
(27)

What is SharePoint?

(Multiple Choice)
4.8/5
(39)

Which method of creating a database demands the least amount of expertise in Access?

(Multiple Choice)
4.9/5
(38)
Match the following terms with their description:
AutoComplete
The letter in the cell reference "F4"
Auto Fill
Helps complete a logical sequence
Column heading
The number in the cell reference "F4"
Correct Answer:
Verified
Premises:
Responses:
AutoComplete
The letter in the cell reference "F4"
Auto Fill
Helps complete a logical sequence
Column heading
The number in the cell reference "F4"
Row heading
Looks like a check mark next to the formula bar
Enter icon
Matches the letters you type to another value in the column if the letters match
(Matching)
4.7/5
(35)
Match each of the following items to their shortcut selections:
One word
Press and hold Ctrl and click in the item to select it
One line of text
Press Ctrl+A
One sentence
Double-click the item
Correct Answer:
Verified
Premises:
Responses:
One word
Press and hold Ctrl and click in the item to select it
One line of text
Press Ctrl+A
One sentence
Double-click the item
One paragraph
Triple-click in the item
Entire document
Place the pointer at the left of the item in the margin area and click
(Matching)
4.8/5
(38)

As long as your data is accurate there is no real need to print preview your reports.

(True/False)
4.7/5
(33)

Creating a database from a template can help you get started more quickly.

(True/False)
4.8/5
(41)
Match the following terms with their meanings:
Sleep mode
Displays and image, the date and time
Start Menu
The main work area
Lock screen
Provides the main access to your programs
Correct Answer:
Verified
Premises:
Responses:
Sleep mode
Displays and image, the date and time
Start Menu
The main work area
Lock screen
Provides the main access to your programs
Desktop
Block icons
Tiles
Power-saving state
(Matching)
4.8/5
(40)

How would you sort or filter records in a field that begins with both numbers and letters so that the records which begin with numbers appear before the records that begin with letters?

(Multiple Choice)
4.8/5
(45)

When first designing a database it is not important what data type you assign each field because you can easily change it later.

(True/False)
4.9/5
(26)
Match the following terms with their description:
Zoom control
Makes the text on the screen smaller or larger
Workbook
Contain labels, values and formulas
Worksheet
The intersection of a column and a row
Correct Answer:
Verified
Premises:
Responses:
Zoom control
Makes the text on the screen smaller or larger
Workbook
Contain labels, values and formulas
Worksheet
The intersection of a column and a row
Sheet tab
Shows the name of the worksheet
Cell
The same as a spreadsheet
(Matching)
4.9/5
(27)
Match each of the following terms to their meanings:
Header
One or more lines at the top of each page
Footer
Various ways a file can appear on the screen
Picture
Digital photo, defined as a graphic element retrieved from storage media
Correct Answer:
Verified
Premises:
Responses:
Header
One or more lines at the top of each page
Footer
Various ways a file can appear on the screen
Picture
Digital photo, defined as a graphic element retrieved from storage media
Tab
Designed to appear much like a top extension on a file folder
View
One or more lines at the bottom of each page
(Matching)
4.8/5
(25)
Match the following terms with their description:
Navigation Pane
A component which makes the database function
Object
A complete collection of all fields about one entity
Primary key
A connection between tables using a common field
Correct Answer:
Verified
Premises:
Responses:
Navigation Pane
A component which makes the database function
Object
A complete collection of all fields about one entity
Primary key
A connection between tables using a common field
Record
That which uniquely identifies records in a table
Relationship
An interface that lists Access objects
(Matching)
4.9/5
(26)
Showing 1 - 20 of 138
close modal

Filters

  • Essay(0)
  • Multiple Choice(0)
  • Short Answer(0)
  • True False(0)
  • Matching(0)