NEW
Font size
WorksheetsFinal Test
Total questions: 40
Worksheet time: 1hrs 2mins
What software do you use to make databases?
Access
Excel
PowerPoint
Word
In your database, information is stored in the ...
Table
Report
Query
Form
In a Table, a column is known as a ...
Record
Garden
Field
Stage
Records in a table can be updated any time.
True
False
Which object would you create to share the data from your database with others?
Form
Report
Query
Table
Access offers different views of objects. Which view do you use to edit a table?
Datasheet View
Design View
Table View
Print View
In a Table, a row is known as a ...
File
Field
Record
Stage
The most common way to look at a table in Access is ...
Datasheet View
Design View
Table View
Print View
These sort, filter, and summarize data.
Tables
Forms
Queries
Reports
What are the best match for below data type description?
A simple alphanumeric data type such as names, titles, etc. which is limited to a maximum of 255 characters in length, which is controlled by field size.
Short Text
Long Text
Number
Currency
What are the best match for below data type description?
A simple data to store integer or numeric data such as 1, -100, 1000 etc.
Short Text
Number
Date/Time
Currency
What are the best match for below data type description?
Large amounts of alphanumeric data: sentences and paragraphs such as memo that support up to 64,000 characters.
Short Text
Long Text
Date/Time
Currency
What are the best match for below data type description?
Data values for the years 100 through 9999.
Short Text
Long Text
Date/Time
Currency
What are the best match for below data type description?
Boolean (true/false) data; Access stores the numeric value zero (0) for false, and -1 for true.
AutoNumber
Long Text
Yes/No
Currency
A unique identifier used in creating a table that assures there will be no duplicate data.
Primary Key
Query
Data Type
If you make a mistake, what do you do?
Restart writing the document
Delete everything
Undo
I don't know
The part of the interface that shows tabs and buttons.
Title Bar
Ribbon
Status Bar
Screen Tips
To quickly undo a mistake you can hold which key down while tapping the 'Z' key?
Ctrl
Shift
Alt
Fn
What is a Margin
The edge of your computer
The edge of your paper
The edge of the words on your paper
Omar has decided to add a table in a Word doc to organize the information better.
Where will he find this option?
Insert tab, Illustrations group
Insert tab, Symbols group
Insert tab, Tables group
Design tab, Page Layout group
The electronic spreadsheet made of cells and organized by rows and columns is known as the _____.
Document
Presentaion
Publicaiton
Worksheet
Letters of the alphabet going across the top of the spreadsheet.
Title Bar
Column Labels
Row Labels
Status Bar
Numbers down the left side of the spreadsheet.
Status Bar
Formula Bar
Column Labels
Row Labels
A cell that has a dark border around it.
Jail Cell
Sleepy Cell
Active Cell
Stem Cell
The intersection of a column and a row is called a __________.
Four-way Stop
Formula Bar
Cell
Template
Every Excel formula/equation must begin with _____.
an equal sign
please and thank you
cell reference
a prayer
Special effects used to introduce slides in a presentation are called
effects
custom animations
transitions
present animations
Which one is the logo of MS PowerPoint?
What do we call one page of MS PowerPoint?
Slide
Page
Card
Display
What contains a predefined theme, sample text, and graphics on a slide or slide background to guide users as they develop content?
template
placeholder
boilerplate
form
