Create an account
The purpose of a database is to store data so that information can be obtained easily by asking questions.
When data in a table becomes redundant,
it is usually an indication that you need a new table to contain information about the topic.
A select query creates subsets of data to answer specific questions, then displays them in the query's datasheet.
Raw, collected data--to which no structure has been added--is all that is needed for a database.
The Multiple Items form enables display or entry of multiple records, but with simplified layout.
To conserve space when planning a database, information should be organized by the largest useful parts possible.
The process of creating a query involves
choosing the table(s) and selecting the fields you want to include in the query result.
When records have no unique value, the AutoNumber data type is a useful way to automatically create a unique number for each record.
One purpose of a report is to
display the fields and records from a table in an easy-to-read format.
When importing data from an Excel workbook, you may NOT
append a copy of the records to an open, active table.
The advantage of using a template when starting a new database is that
database objects are already created.
When you create a table using the Blank Database command, by default Access designates the first field as the primary key field.
Which of the following is a good candidate for a primary key?
A student ID in a college registration database.
Which of the following is NOT a characteristic of the Currency data type?
Data must be displayed with two decimal places.
Which of the following does NOT happen when you close an Access database?
The Access window will automatically close.
Good database design does NOT include
accessible coding so that users can alter the structure of the database.
The Unique check box is the indicator on the Ribbon in Datasheet view that a field is the primary key.
Which of the following is NOT a benefit of avoiding redundancy in a database?
Prevents unauthorized manipulation of data
Please allow access to your computer’s microphone to use Voice Recording.
Having trouble? Click here for help.
We can’t access your microphone!
Click the icon above to update your browser permissions and try again
Reload the page to try again!Reload
Press Cmd-0 to reset your zoom
Press Ctrl-0 to reset your zoom
It looks like your browser might be zoomed in or out. Your browser needs to be zoomed to a normal size to record audio.
Please upgrade Flash or install Chrome
to use Voice Recording.
For more help, see our troubleshooting page.
Your microphone is muted
For help fixing this issue, see this FAQ.
Star this term
You can study starred terms together