Computer Applications FINAL Pt. 3 (Access)
Unlike other Office software applications, you must _________ a new Access database file before you can create any objects in the file.
Name and save
In the Microsoft Access Database Window, the _________ displays a list of the database objects that can be opened.
Navigation pane
The process of applying design rules and principles to ensure that your database performs as expected is called ______________.
Normalization
In the Microsoft Access Database Window, the __________ displays the active or open object(s), including tables, queries, forms, and/or reports.
Object window
________ are the basic parts of a database, created to store data, to work with data, and to display data.
Objects
A database is useless until the table is _____________ with data, which may be accomplished by typing the data directly into the table or by importing the data
Populated
_________ data is critical to maintaining accuracy in a database, especially when multiple people may be inputting data.
Proofreading
Each row in a database table is called a/n __________--all of the categories of data pertaining to one person, place, event, thing, or idea.
Record
The _____________ data type describes text, a combination of text and numbers, or numbers that do not represent a quantity or are not used in calculations, such as the zip code; allows entry of up to 255 characters in that field.
Short text
When appending or creating a new table from an Import, the file that is being imported is called the ____________ file
Source
When designing a new database, the first question users should ask themselves is _________
What questions should this database be able to answer?
What is the keyboard shortcut to open and close the Navigation Pane in Access?
F11
Each column in a database table is called a/n _____________--a single piece of information for every category of data.
Field
To organize data in database tables so that redundant data does not occur is the ___________ principle of good database design; reduces the likelihood of errors when inputting new data.
First
Databases that are not related or linked to any other collection of data are called __________ databases
Flat
The tables of information in a relational database are linked or joined to one another by _____________--a unique entry in each table row that stores the same data.
A common field
A more sophisticated type of database is called __________, because multiple collections of data in the database are linked to one another—for example, information about students, courses, and instructors at a college.
A relational database
When creating a new table, Access creates the first field and names it ID, in which Access assigns _________ to each new record as it is entered into the table.
A unique sequential or random number
The _____________ data type describes a unique sequential or random number assigned by Access as each record is entered.
AutoNumber
To use the Append option to add records to an existing table, the column heading in the Excel worksheet must ______________.
Be identical to the field names in the table
An Access ___________ is stored on your computer or storage device; it initially has no data and database tools—you create the data and the tools as you need them.
Blank database file
By default, a new, blank Access database table displays in __________, which arranges the data in columns and rows similar to an Excel worksheet.
Datasheet view
There are two views for tables in Access: Datasheet view and ___________view.
Design
One of the ways to view a database table is in ___________, which displays the underlying structure of the table's fields and where the structure may be created or edited.
Design view
By using the _____________ feature, users do not have to manually enter data into tables if the information already exists in a Word table or Excel spreadsheet.
Import
_________ are similar in structure to an Excel worksheet and are the foundation for all Access databases
Tables
Which of the following is NOT one of the four most common database objects?
Template
When linking two tables in a relational database, a user will use a ________ to create the link.
common field
A very important classification for each database table field is the __________, which classifies the kind of data that can be stored in each field such as number, text or date; can be only one to each field.
data type
A _______________ is an organized collection of data related to a specific topic or purpose
database