Database
Tables or Records
Fields
Views
Anything Goes!
100
What is a relational database?
What is a database that contains multiple tables that are linked together.
100
How many primary keys can a table have?
What is ONE!
100
What do the columns of a table correspond to?
What is Fields!
100
Which is NOT displayed in DESIGN view of a Form or Table?
What is the "personal content/information" of each record (e.g. customer) in the table.
100
Give an example of a "field name" that would be suitable to include an "input mask" on under field properties in design view of a table?
What is either a phone number, social security number, ISBN number, or zip code? eg) (716) 825-1234 or 123-66-1617 or 14205-1221
200
Name at least four objects in an access database. HINT: TFQR
What are Tables, Forms, Queries, and Reports
200
Which button would you click on to list all the records in your table alphabetically by the last name field?
What is SORT button.
200
What is a set of fields called?
What is a RECORD!
200
Field properities are shown in which view of a table? e.g.) datasheet view or design view
What is design view!
200
What type of Control is associated with a Yes/No field on a form? Text box OR drop down list box OR check box OR Option group
What is Check Box!
300
What is the symbol used to indicate that you are "entering a record" in an Access database table?
What is a PENCIL!
300
What is a set of records called?
What is a TABLE!
300
Social Security Number should be designated as what type of data type in field properties of a table?
What is a "text" data type, because it is not used in any mathmatical computation! eg) Quality Points and Credits earned would be designated as "Number" data types instead of text data type.
300
When building a table, what can be accomplished using DESIGN view?
What is Add more field names to the table, and change their data type from the default of text to other data types. eg) Financial Aid Yes/No Quality Points Number Credits Number
300
The Sort Ascending button will do what to all records in your database?
What is order all records in alphabetical order.
400
If you were creating a database for a bookstore, what could be used as a primary key field name for each book?
What is ISBN number!
400
What happens when you have entered the last field for a record and press the ENTER key?
What is the record is SAVED!
400
Every field in a table has these two things that you can see while you are in Design View of a table? HINT: FN and DT
What is Field Name and Data Type
400
Which of the following views are used to create and modify a form? Datasheet view or Form view or Design view?
What is DESIGN VIEW! NOTE: If you said, Datasheet view as your answer, you are incorrect as datasheet view is of a TABLE that looks like an EXCEL spreadsheet!
400
When would you want to conduct an "ascending" sort?
What is when you want the records sorted alphabetically by NAME.
500
What kind of software is ACCESS called?
What is Database software!
500
The rows of a table correspond to what? Reports or Fields or Records or Files
What is RECORDS
500
Which of these four choices should be defined as a "Numeric" Data Type instead of "Text" Data type (default)? ZipCode or SSN or Telephone# or Credits and QualityPoints
What is Credits and QualityPoints
500
How can a student's record be added to an Access Student Table? Using what? HINT: There are 2 ways!
What is either enter the record in Datasheet View of a table, or enter it in a user-friendly FORM.
500
How many fieldnames (1, 2, or 3) is the best way to store an individual's first, middle and lastname in a table? e.g.) 1 - FullName 2 - FirstName LastNameandMiddle 3 - FirstName LastName MiddleName
What is as three separate fields called: FirstName LastName Middle Then, if you have two people with the same last name, and different middle initials, you can sort based on the middle name as well.
M
e
n
u