NEW
Font size
WorksheetsPlay with MS Access - 1
Total questions: 25
Worksheet time: 27mins
The software that we would use to create a database is
Microsoft Publisher
Microsoft Excel
Microsoft Word
Microsoft Access
In a database, data is stored in
Tables
Forms
Reports
Queries
Which of the following would be used to uniquely identify a record?
Validation
Data type
Primary key
Field size
A ‘required field’ is a form of
Validation
Verification
Data Entry
Data Output
The best data type to choose for date of birth would be
Number
Text
Date/Time
Currency
The best data type to choose for a phone number would be
Number
Text
Date/Time
Currency
To find a particular set of data in a database you would use a
Table
Form
Query
Report
Besides entering data directly into the table, you could use a
Field
Form
Query
Report
To display the data from a query in a professional format you could use a
Table
Form
Query
Report
Nick wants Access to assign an ID number to each record. What is this called?
Data Type
auto numbering
Properties
Text
What function enables you to ask questions about the data stored in a database and returns the answers based on your criteria?
Query
Form
Report
Table
What is a complete row of data within a table?
Table
Field
Record
Query
To sort from the smallest to the largest (from A to Z and 0 to 9)
Ascending
Descending
Advanced Sort/Filter
A Primary Key is a code that uniquely identifies a _____________ in a Database.
Record
Field
Text
Number
This field can contain any characters with maximum of 255 letters
Memo
Short Text
Database
Texting
This field can only contain monetary data.
Short Text
Long Text
Currency
Yes/No
Where do you configure the field properties of a Table?
Design View
Datasheet View
Access View
File extension for MS Access is ______________.
.accdb
.acdb
.accd
.access
What are the 4 main objects in a database?
Tables, Forms, Reports, Keys
Spell Check, Grammar, Ruler, Tools
Tables, Queries, Forms, Reports
Cells, Columns, Rows, Sheet
Where are the previous, first, next and last record buttons are located?
Title bar
Menu Bar
Navigation Bar
Which button allows us to select an attractive layout from many readymade available layouts?
Design
Auto Format
Navigation
You can specify a criteria for a report.
True
False
Once a Report has been generated, it cannot be customized.
True
False
