Microsoft Access can best be described as ____ software. Database Presentation S
ID: 3667016 • Letter: M
Question
Microsoft Access can best be described as ____ software.
Database
Presentation
Systems
Spreadsheet
Which is NOT true about Access?
It can be used to arrange data in a variety of ways.
Multiple users can simultaneously enter and update data within Access.
Reporting is limited to 20 saved reports.
It relates lists of information in a relational database.
Which of the following is NOT a way to open Access?
From a shortcut on the desktop
From Internet Explorer
From the Start menu
From a pinned program on the taskbar
This Access object provides an easy-to-use data entry screen.
Form
Table
Macro
Module
Which is NOT a feature of Access reports?
Footers
Headers
Calculations on groups of records
Easy-to-use data entry screen
Tables, queries, and forms are examples of Access ____.
Objects
Controls
Entities
Values
This Access object contains all of the raw data within the database.
Query
Form
Table
Module
A collection of records for a single subject, such as all of the customer records, is called a(n) ____.
Object
Table
Element
Control
Which of the following is not a data type?
Text
Number
Formula
Date/Time
Which data type is used to sequentially order each record added to a table?
Hyperlink
AutoNumber
Lookup Wizard
Web
Which data type stores only one of two values?
Attachment
Yes/No
Null
Hyperlink
Which data type links files created in other programs such as pictures, sound clips, or documents?
Attachment
Lookup
Link Wizard
Yes/No
Which data type stores Web addresses?
Hyperlink
Lookup Wizard
www address
HTML
A specific category of data such as a customer's name, city, state, or phone number is called a(n) ____.
Field
Record
Object
Table
A group of related fields, such as all the demographic information for one customer, is called a(n) ____.
Object
Database
Table
Record
A(n) ____ is a collection of tables associated with a general topic such as sales of products to customers.
Field
Record
Relational database
Object
Which two properties are required for every field?
Data Type and Format
Field Name and Data Type
Field Size and Format
Field Name and Field Size
The term ____ database comes from the fact that two or more tables are linked by a common field.
Network
Relational
Schematic
Hierarchical
In a datasheet, which mode assumes that you are trying to change the value of a particular field?
Navigation mode
Form mode
Edit mode
Update mode
In Navigation mode, press [Tab] or this keystroke to move to the next field within the same record.
[Down Arrow]
[Enter]
[End]
[Page Down]
Which shortcut key moves focus to the previous field of the current record?
[Home]
[Up Arrow]
[F5]
[Shift][Tab]
Which shortcut key moves focus to the first field of the current record?
[F5]
[End]
[Home]
[F4]
Press this keystroke combination to move focus to the last field of the last record.
[Ctrl][Up Arrow]
[Ctrl][Page Up]
[Alt][Ctrl][Up Arrow]
[Ctrl][End]
While editing a record, pressing [Esc] a second time ____.
Deletes the current field
Removes all data from the current record
Deletes the current datasheet
Removes all changes made to the record you are currently editing
Which of the following keys will help you delete unwanted data in Edit mode?
[Backspace]
[Home]
[Ctrl]
[Insert]
a.Database
b.Presentation
c.Systems
d.Spreadsheet
Explanation / Answer
1) Microsoft Access can best be described as Database Software
2) Which is NOT true about Access?
Sol: C
Reporting is limited to 20 saved reports.
3) Which of the following is NOT a way to open Access?
Sol: b
From Internet Explorer
4) This Access object provides an easy-to-use data entry screen
Sol: a
Form
5) Which is NOT a feature of Access reports?
Sol: c
Calculations on groups of records
6) Tables, queries, and forms are examples of Access
Sol: a
Objects
7) This Access object contains all of the raw data within the database
Sol: c
Table
8) A collection of records for a single subject, such as all of the customer records, is called a(n)___
Sol: b
Table
9) Which of the following is not a data type?
Sol:c
Formula
10) Which data type is used to sequentially order each record added to a table?
Sol: b
Autonumber
11) Which data type stores only one of two values?
Sol: b
Yes/No data type
12) Which data type links files created in other programs such as pictures, sound clips, or documents?
Sol: a
Attachment
13) Which data type stores Web addresses?
Sol: a
Hyperlink
14) A specific category of data such as a customer's name, city, state, or phone number is called a(n) ___
Sol: a
Field
15) A group of related fields, such as all the demographic information for one customer, is called a(n) ___
Sol: d
Record
16) A(n) ___ is a collection of tables associated with a general topic such as sales of products to customers.
Sol: c
Relational database
17) Which two properties are required for every field?
Sol: b
Field name and datatype
18) The term ____ database comes from the fact that two or more tables are linked by a common field.
Sol: b
Relational
19) In a datasheet, which mode assumes that you are trying to change the value of a particular field?
Sol: c
Edit Mode
20) In Navigation mode, press [Tab] or this keystroke to move to the next field within the same record.
Sol: b
Enter
21) Which shortcut key moves focus to the previous field of the current record?
Sol: d {shift}{tab}
22) Which shortcut key moves focus to the first field of the current record?
Sol: c
[Home]
23) Press this keystroke combination to move focus to the last field of the last record.
Sol: d
[ctrl][End]
24) While editing a record, pressing [Esc] a second time __
Sol: d
Removes all changes made to the record you are currently editing
25) Which of the following keys will help you delete unwanted data in Edit mode?
Sol: a
[BackSpace]