ISAN Access
To create a new blank file, click the File tab to open Backstage view, click New, and then click the __________ document thumbnail to create the new blank file.
Blank
To rename a field in Datasheet view, one method is to click the __________ button in the Table Fields tab.
Name & Caption
When you close a file, the application __________.
Stays open
Check for new updates to Office.
-> file -> Account -> Update Options -> Update Now
Access opens to _______ where you can select an existing database to open or begin a new one.
Backstage view
When you are opening a file but don't know where it is located, click the __________ button to help locate it.
Browse
To add a new field to a table in Datasheet view, click the arrow in the __________ column to expand the list of available field types.
Click to add
Shortcut key for find and replace *(not a question but important)
Ctrl + F
One method to save a file is to press __________ on the keyboard.
Ctrl + S
__________ applications allow you to organize and manipulate large amounts of data.
Database
The __________ property allows you to add a preset value to a field.
Default Value
The __________ is a full-featured version of the Office applications that you can download and install on your computer.
Desktop app
By default, the Navigation Pane displays objects organized by the Object Type.
False
The Currency format displays a $ symbol before the number in a field and four digits to the right of the decimal place.
False
To change the look of Office, click the Home tab to open Backstage view.
False
Which of the following is not one of the categories you can group by in the Navigation Pane?
File Location
Keeping repeated data in separate tables where they are stored only once keeps the database __________, allowing the database to operate more efficiently.
File size down
You can define specific __________ options to control the appearance of data in a field.
Formatting
One method to enable editing is from the __________ page in Backstage view.
Info
__________ are keys or combinations of keys that you press to execute a command.
Keyboard shortcuts
Files that are opened in Protected View display a warning in the __________ at the top of the window, below the Ribbon.
Message bar
Free Office apps available for your tablet device that are designed to run on the iOS and Android operating systems.
Mobile app
Although you create and work with a single Access database file, inside the file, there are multiple _______.
Options
You can use the __________ dialog to enable and disable some of the user interface features.
Options
_______ extract data from a table or related tables and can include actions such as updating data values or deleting data.
Queries
The __________ allows you to add commands that you use often, providing one-click access to these commands. In Office 365, it is hidden by default, but you can display it via the Ribbon Display Options.
Quick Access Toolbar
The __________ allows you to add commands that you use often, providing one-click access to these commands. In Office 365, it is hidden by default, but you can display it via the Ribbon Display Options.
Quick Access toolbar
__________ databases allow you to relate tables and databases to one another.
Relational
If you confirm that you want to delete a table, Access will automatically delete the _______, and then delete the table.
Relationships
Objects in Access are related to one another through _______ defined by common fields between tables.
Relationships
One method you can use to insert a new field is to __________ any field name and select __________.
Right-click; Insert Field
Lookup fields are useful to use for fields that reference a __________.
Specific list of items
When you launch Office applications you are first taken to the ___________ page which gives you quick access to recently opened files and templates.
Start
The database ________ store all the data.
Tables
Duplicates of the values in a primary key field are not allowed.
True
T/F: Deleting a customer from a table may also delete all related appointments linked to that customer name.
True
T/F: Specifying the appropriate data type for a field is crucial to designing an efficient database.
True
T/F: The Microsoft Search box feature offers a quick way to access commands that you do not know how to find in the Office interface or that take several clicks to get to.
True
T/F: To display the Quick Access Toolbar, click the Ribbon Display Options button and select Show Quick Access Toolbar.
True
T/F: When a lookup field in one table references values in a field in another table, Access will automatically create a one-to-many relationship between the tables.
True
T/F: When you create a new, blank table in Datasheet view, Access names the fields Field1, Field2, and so forth by default.
True
T/F: When you save files to your OneDrive, they are stored locally on your computer and then "synched" with your OneDrive account and stored in the "cloud" where they can be accessed from another computer or device that has OneDrive capability.
True
The Live Preview feature allows you to see formatting changes in your file before actually committing to them.
True
The longer your database is in use, the more unnecessary temporary objects there are.
True
The options in the Quick Start section of the Field Types gallery will insert a related group of fields when clicked.
True
When you create a lookup field that references data in another table, Access automatically creates a(n) __________ relationship.
one-to-many
A(n) __________ field is automatically assigned its value by Access. Database users cannot edit or enter data in this field.
Autonumber
A(n) __________ field can include images, Word documents, or almost any other type of data file.
Attachmenthment
