Upgrade to remove ads
Only $35.99/year

Access Overall Test

Terms in this set (60)

Compacting a database has the same result as backing up the database. T/F
false
When using the Report Wizard, you can click the Back button to review previous dialog boxes. T/F
true
Which of the following are Access data types?
Currency
Date/Time
Number
You enter and edit data in a query datasheet in the same way you do in a table datasheet. T/F
true
Besides reducing file size, what other benefit does compacting an Access database provide?
Repairing the database
When you finish creating a report with the Report Wizard, you can choose to preview the report or...
modify the report's design
Which of the following are Access objects?
Forms
Queries
Reports
Which of the following techniques can you use to navigate to the next record in a datasheet?
DOWN ARROW key
Next record button
TAB key
Which of the following are properties you can set for a field?
Field Size
Field Name
Default Value
TO back up a database, you use the ____ command
Back Up Database
Use the New (blank) record button to move the focus to the first record in a table. T/F
false
Which of the following can you define in Table Datasheet view?
Data types
field properties
field names
Which of the following are advantages of using Microsoft Access to manage data?
Access provides data-entry forms
Access allows more than one user to enter data at the same time
Access minimizes duplicate data
WHat data type should you assign to a field that stores postal codes?
Short Text
Microsoft Access 2016 can best be described as ___ software.
database
Use the ____ to exit Access
Close button
What can you use to find info about Access commands and features and instructions about how to use them?
Tell Me box
Tables, queries, and forms are examples of Access ____
objects
To navigate to a record in a table, switch to Table Design view. T/F
false
Suppose you rename a field in Table Design view. What must you do before you can view the data in the table?
Save the table
Which of the following are good candidates for a primary field for a Customer table?
IdentificationNumber
CustomerID
CustomerName
YOu can import Access tabel data from which of the following Office apps?
Outlook
Access
Excel
Which field is always on the "one" side of a one-to-many relationship between two tables?
primary key field
To move a field in Query Design view, you drag the field by its field selector. T/F
true
Which of the following are possible entries for the Field Size property of a Number field?
Single
Byte
Long Integer
What property do you use to set the Graduated text box in a form to display "Yes" in each new record?
Default Value
If a City field displays the value "Chicago" for a new record, that means the Default Value property for the City field has been set. T/F
true
You cannot modify the Field Size property of a Short Text field. T/F
false
What happens if you delete a field from a table that contains data?
You delete all the data in the field
When a record from one table is related to several other records in another table, the tables have a one-to-many relationship. T/F
true
To rename a table, you must use the Navigation Pane. T/F
true
A relational database can best be described as a collection of related ___ designed to minimize redundant data.
tables
You typically increase the decimal places from 1 to 2 for a ___ field.
Currency
The ____ property controls how many characters can be entered into the field.
Field Size
Characteristics, such as Field Name and Data Type, are ___ that define a field.
properties
To import data from Excel to Access, you would begin by clicking the...
External Data tab
Which process is most like copying and pasting?
Importing
How do you rename a table?
Right-click the table in the Navigation Pane, and then click Rename.
YOu can set the Field Size property for a field with a Short Text data type. T/F
True
YOu cannot set the Field Size property for Short Text fields in Table Datasheet view. T/F
false
YOu use the Field List to ass fields to a form in Form Design view. T/F
true
YOu can add fields to a form in Design view or,,,
Layout view
What happens if you hide the Bonus column in the Employees table in Table Datasheet view?
The Bonus column no longer appears in the datasheet, but is still part of the Employees table
YOu can add a Total row to a query datasheet to calculate stats such as Sum, Average, or COunt. T/F
true
The easiest way to filter the records for an exact match is to use the ___ feature.
Filter By Selection
A ___ is a saved object within the database, whereas a ___ is temporary
query, filter
Which of the following are examples of correct criteria syntax?
<"Anderson"
<=33.50
>=#1/1/2021#
A subdatasheet shows the records on the "one" side of a one-to-many relationship. T/F
false
Before you close a query datasheet, you must save your changes to the data. T/F
false
Use >500 as the criterion for a Number field in a query to select records with a value less than 500 in that field. T/F
false
Which of the following criteria uses the correct syntax for a Date/Time field in a query?
#5/7/2021#
In Table Datasheet view a ____ shows the records on the "many" side of a one-to-many relationship
subdatasheet
To add a field list to the upper pane in Query Design view, drag a table from the Navigation Pane. T/F
true
Add a Number field to a table to store values that represent money. T/F
false
YOu use Query Design view to add ___ to limit the number of records shown in the resulting datasheet.
criteria
Using "CA" as the criterion in a Short Text field is the same as using "ca" or "Ca" as the criterion. T/F
true
Which of the following options are available as you filter a datasheet?
Filter By Selection
Filter By Form
Clear All Filters
In Query Design view, the query grid shows the names of fields and tables involved in the query. T/F
true
Which of the following are ways to run a query?
Click the Run button in Query Design view
Double-click the query in the Navigation Pane
Click the View button in Query Design view
When you delete a column from a Table Datasheet view, you delete the field and all of its data. T/F
true
Students also viewed