Shared Flashcard Set

Details

Microsoft Office Access 2003 Set 2
Vocabulary and Concepts of Access
30
Computer Science
Not Applicable
03/06/2011

Additional Computer Science Flashcards

 


 

Cards

Term
toolbar
Definition
contains buttons that allow you to perform certain tasks more quickly than using the menu bar
Term
icon
Definition
a picture depicting a function
Term
ScreenTip
Definition
a description of a button
Term
True
Definition
T or F: The type of toolbars that appear will depend on the task you are doing
Term
taskbar
Definition
bar at the bottom of the screen that displays the Start button, active window buttons, and the current time
Term
status bar
Definition
bar above the Window's taskbar that contains special information that is appropriate for the task on which you are working
Term
Database window
Definition
a special window that allows you to access easily and rapidly a variety of objects such as tables, queries, forms and reports
Term
shortcut menus
Definition
menus that display the most frequently used actions available for a particular item when you right click it
Term
Tools; Autocorrect Options
Definition
To specify AutoCorrect rules, click ____ on the menu bar and select _________.
Term
AutoCorrect
Definition
corrects common mistakes when you complete a text entry in a cell
Term
Tables; Object; Create table; Design
Definition
To use Table Wizard, click _____ on the _____ bar, and then click ______ by using wizard.  You can modify the table at any time by opening the table in _____ view.
Term
field name
Definition
the unique name for each field
Term
data type
Definition
the type of data the field will contain
Term
e
Definition
Fields can only contain:
a) text
b) numbers
c) symbols and numbers
d) all of the above
e) it depends on the field
Term
description
Definition
a field where you can provide a detail explanation of the field
Term
False
Definition
T or F: All database management systems have the same field types
Term
True
Definition
T or F: Primary keys can consist of a combination of fields rather than a single one
Term
True
Definition
T or F: You can assign how many characters can be stored in a particular field
Term
j
Definition

Field names can't have:

a) any punctuation symbols

b) digits

c) spaces

d) periods

e) exclamation points

f) accents

g) brackets

h) all of the above

i) a-c, g

j) d-g

Term
True
Definition
T or F: The same name cannot be used for two different fields in the same table
Term
text
Definition
data type that can accept any characters
Term
number
Definition
data type can only contain numbers used in arithmetic operations
Term
False
Definition
T or F: The data type numbers can only contain positive numbers
Term
text
Definition
When a field contains numbers that will not be used in arithmetic calculations, they are assigned as the data type _____.
Term
currency
Definition
data type that can only contain monetary data and values will appear with currency symbols
Term
False
Definition
T or F: Currency data type cannot be used in arithmetic calculations
Term
Memo
Definition
data type where a field can store avaliable amount of text and/or numbers where the total number of characters may exceed 255
Term
Date/Time
Definition
Data type where a field can store dates and times
Term
AutoNumber
Definition
Data type where a field can store a unique sequential number that Access assigns to the record.  Access will increment the number by 1 as each new record is added.
Term
Yes/No
Definition
Data type where the field can only store one of two values--yes/no, true/false, on/off
Supporting users have an ad free experience!