NEW
Font size
WorksheetsMicrosoft Access Intro
Total questions: 30
Worksheet time: 32mins
Where do you configure the field properties of a Table?
Design View
Datasheet View
Access View
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
Access can import a table of data from Excel.
True
False
A unique identifier used in creating a table that assures there will be no duplicate data.
Primary Key
Query
Data Type
Microsoft's version of a Database Management System (DBMS)
Excel
Access
Word
What is a complete row of data within a table?
Table
Field
Record
To sort from the smallest to the largest (from A to Z and 0 to 9)
Ascending
Descending
Advanced Sort/Filter
Tables are set up to contain columns and rows of information. In a database table, the columns are called __________.
Cell
Field
Column
Record
Michelle needs each club member to complete a digital information sheet. Which tool is best?
Filters
Form
Query
Nick wants Access to assign an ID number to each record. What is this called?
Data Type
auto numbering
Properties
Which datatype can store both text and numbers?
Currency
Calculated
Number
Short text
Which datatype is suitable for 5VS23G?
Date/Time
Autonumber
Memo
Text
A sports club needs to store information about each member. The individual information about each member is called a:
Field
File
Record
Table
A gym has a database with all their members they want to include email addresses in the database, what will they do?
Add a record
Add a field
Edit a record
Change a field name
A health club wants to find all the members who use the club 3 days or more a week. What will they put in the query in the 'days' query criteria?
>3
<3
>=3
<=3
The school wants to sort the data by alphabetical order in Last name. How will they sort it?
Ascending order
Descending order
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
How many records are in this table?
5
8
9
10
When working with a database application, what is the function of a wizard?
to complete a task for you
to guide you through the steps required to complete a task
to ensure all default settings are implemented
to suggest the most efficient way to complete a task
Beth needs to determine the seniors with a GPA of 4.0 or higher. Which object would allow her to create a saved search to find this information in the database?
Form
Table
Query
Report
After a query is created, which action must take place to display the results of the query?
Go
Run
Get
Retrieve
Before creating a query from multiple tables, you must first ensure that the tables have which of the following?
Unmatched records
A defined relationship
A filter applied
No related records
How many fields are in this table?
5
8
9
10
