MIS 1305 Access Ch. 2 || All Solved.
Entity correct answers a person, place, item, or event for which item is to be tracked
Attribute correct answers information about an entity
Ex. participants name or address are considered attributes
Each attribute becomes a field in the table
Relationship correct answers an association b/w tables based on common fields
Data type correct answers the kind of data that can be entered into a field, such as numbers, text,
or dates
data type tells Access how to store and display data
2 most common data types? correct answers Number and Short text
Number data type correct answers data can only contain numeric characters
Short Text data type correct answers allows any text and numeric characters to be stored
Named range correct answers a group of cells that have been given a name
Delimiter correct answers a character such as a tab or comma that separates the fields
Primary key correct answers a field that uniquely identifies the record; it can be any data type,
but it should be a field that will not change.
Ex: not a good primary key: a person's name
, First, it's not unique--others could have the same name. 2nd, the name could change.
Data type- Short Text correct answers Used to store textual or character info.
Any character or number can be entered into this type of field. You should store any data that
will never be used in calculations, such as a social security number, as text, not a number. There
is an upper limit of 255 characters in one field.
Ex: Names, addresses
Data type- Long Text correct answers Used to capture large amounts of text. Can store up to 1
gigabyte of characters, of which you can display 65,535 characters in a control on a form or
report. This is a good data type to use if you need more than 255 characters in one field.
Ex: Comments
Data type- Number correct answers Used for numeric data.
Ex: Quantity
Data type- Date/Time correct answers Used to store a date and or time
Ex: Start time
Data type- Currency correct answers a numeric value that is used for units of currency
it follows the regional settings preset in Windows to determine what the default currency should
be. In the United States, the data is displayed with a dollar sign and two decimal places.
Ex: Salary
Entity correct answers a person, place, item, or event for which item is to be tracked
Attribute correct answers information about an entity
Ex. participants name or address are considered attributes
Each attribute becomes a field in the table
Relationship correct answers an association b/w tables based on common fields
Data type correct answers the kind of data that can be entered into a field, such as numbers, text,
or dates
data type tells Access how to store and display data
2 most common data types? correct answers Number and Short text
Number data type correct answers data can only contain numeric characters
Short Text data type correct answers allows any text and numeric characters to be stored
Named range correct answers a group of cells that have been given a name
Delimiter correct answers a character such as a tab or comma that separates the fields
Primary key correct answers a field that uniquely identifies the record; it can be any data type,
but it should be a field that will not change.
Ex: not a good primary key: a person's name
, First, it's not unique--others could have the same name. 2nd, the name could change.
Data type- Short Text correct answers Used to store textual or character info.
Any character or number can be entered into this type of field. You should store any data that
will never be used in calculations, such as a social security number, as text, not a number. There
is an upper limit of 255 characters in one field.
Ex: Names, addresses
Data type- Long Text correct answers Used to capture large amounts of text. Can store up to 1
gigabyte of characters, of which you can display 65,535 characters in a control on a form or
report. This is a good data type to use if you need more than 255 characters in one field.
Ex: Comments
Data type- Number correct answers Used for numeric data.
Ex: Quantity
Data type- Date/Time correct answers Used to store a date and or time
Ex: Start time
Data type- Currency correct answers a numeric value that is used for units of currency
it follows the regional settings preset in Windows to determine what the default currency should
be. In the United States, the data is displayed with a dollar sign and two decimal places.
Ex: Salary
