Access Chapter 1
When saving a new database in Access 2007-2016 databases, the file extension should be ________. a) .dbx b) .adbx c) .accdb d) .db
.accdb
Which of the following is NOT a way method to create a new database? a) Database template b) Blank desktop database c) Custom web app d) Database wizard
Database wizard
To improve accuracy during user input, a designer can add context to the ________ from the properties screen which will be displayed in the status bar to provide additional information to users who are entering data. a) Details b) Description c) Info d) Data Type
Description
There are two views for tables in Access: Datasheet view and ________ view. a) Source b) Structure c) Back Office d) Design
Design
All data entered in a table must be visible within the column. Anything that is not visible in the column will be cutoff. a) True b) False
False
If users delete a Field from the Design view by accident, they can click Undo to correct the error. a) True b) False
False
In the Datasheet view, a user will see the underlying structure of the table. a) True b) False
False
Increasing the column width will also increase the number of characters a user can enter in each field. a) True b) False
False
Once users select a data type for a field and enter data, they cannot change the data type. a) True b) False
False
One of the major advantages of using a database template is that it will populate the tables with data. a) True b) False
False
Primary keys must be numbers. a) True b) False
False
The Primary key must be the first field in each record. a) True b) False
False
The Short Text data type will allow a user to store up to 512 characters in that field. a) True b) False
False
When importing a new table from an existing Excel worksheet, the user must import all columns from Excel into the new Access table. a) True b) False
False
Within an Access table, each row is a field and each column is called a record. a) True b) False
False
To improve accuracy during user input, a designer can limit the number of characters a user can enter by adjusting the ________ from the properties screen. a) Length b) Details c) Field Size d) Data Type
Field Size
A user can close the existing database and leave Access open to continue working on anther database by clicking close from the ________ tab. a) File b) Home c) Database Tools d) Design
File
When creating a new table, Access creates the first field and names it ________ which Access assigns a unique sequential number. a) ID b) OBJECT c) ITEM d) VALUE
ID
A user can select two different Page Layouts; Portrait that has a vertical orientation and ________ that has a horizontal orientation. a) Flat b) Wide c) Landscape d) Extended
Landscape
The ________ view of a form allows a user to view the data while making changes to the elements of the form. a)Form b) Design c) Layout d) Print
Layout
The ________ key refers to the unique field that identifies each record. a) Foreign b) Home c) Link d) Primary
Primary
A user can use ________ to view how a table will print before committing. a) Print Preview b) Zoom c) Page Layout d) Design
Print Preview
Which of the following is NOT an option for print range of a table? a) All b) Selected Records c) Pages From: ________ To: ________ d) Records From: ________ To: ________
Records From: ________ To: ________
A user can delete multiple columns from Layout view of a Form by holding down the ________ key and clicking on the range of columns to delete. a) SHIFT b) ALT c) FN d) Windows
SHIFT
A user can populate a table with records by typing the data directly into the table. a) True b) False
True
A user can quickly create a new form for data within a table by making the table active and selecting Form from the create tab. a) True b) False
True
A user must have Internet Access to search online templates. a) True b) False
True
Access automatically saves each record when you move to the next row; you do not need to click Save. a) True b) False
True
After users enter critical information and click Create, they will be directed immediately to Table 1 after creating a new database from Blank desktop database. a) True b) False
True
All templates provided by Microsoft are safe and users can enable content if any warning message is displayed. a) True b) False
True
By default, when a user opens a table and selects Report from the Create tab, all fields and all records are included in the report. a) True b) False
True
Each table should have a field that contains a unique value for each record in the table. a) True b) False
True
Entering data on a single-record form will automatically update the data in the record without having to click save. a) True b) False
True
To use the Append option to add records to an existing table, the column headings in the Excel worksheet must be identical to the field names in the table. a) True b) False
True
User can export an Access Table to a Word Document. a) True b) False
True
Users can add additional tables to databases created from templates. a) True b) False
True
Users should not store redundant data within a database and should create a new table to contain that data. a) True b) False
True
When a designer shortens the field length of an existing field, all data for existing records will be truncated to match the new field length. a) True b) False
True
When importing a new table from an existing Excel worksheet, the user can use the existing headings from the Excel spreadsheet so that they do not have to re-type them. a) True b) False
True
When designing a new database, the first question users should ask themselves is ________. a) Who is going to use this database? b) How much information is going to be stored in this database? c) What questions should this database be able to answer? d) Where should this database be stored?
What questions should this database be able to answer?
Pressing Enter three times at the end of a multiple-items form will open ________. a) a table of underlying data b) a query of underlying data c) form editor d) a single-record form
a single-record form
Database designers typically do not add spaces in field names (LName), but can add details in the ________ field of the field properties to provide additional context to the field that is not displayed (Last Name). a) caption b) details c) format d) index
caption
When linking two tables in a relational database, a user will use a ________ to create the link. a) hyperlink b) common field c) tag d) bookmark
common field
A ________ is an organized collection of data. a) database b) catalog c) server d) warehouse
database
Databases that not related or linked to other data are called ________ databases. a) single-stacked b) cloud c) flat d) DBMS
flat
When considering to use the Currency data type, a user should understand that they can store data with one to ________ decimal places. a) two b) four c) six d) ten
four
To publish a new database that you want to share with others, you should select a template that has an image of a ________. a) computer b) user c) house d) globe
globe
After a user creates a new query or edits an existing query they must ________ the query to display the corresponding results. a) execute b) start c) run d) retrieve
run
Fields that contain numbers that are not used in calculations should be set to ________. a) short text b) long text c) number d) auto-number
short text
When appending or creating a new table from an Import, the file that is being imported is called the ________ file. a) host b) source c) initial d) destination
source