ITE ACCESS EXAM
Database
A ________ is an organized collection of data.
parameter
A ________ query prompts a user for criteria before running the query.
true
A user can change column widths of multiple fields at the same time
true
A user can change the sort order of a query from the Datasheet View.
trust center
A user can set the security and privacy settings on what is displayed in the Message Bar from the ________ within the options menu.
false
A user will need to double-click on the field from field list one and then double-click on the field from field list two to establish a relationship between the two tables.
quotation marks
Access will place ________ around a text string within a query criteria that will limit the results to their exact specifications.
true
Aggregate functions should be added to the Total row in the Query Design Grid.
fields that are listed as primary keys
Fields in the Query Design Grid include all of the following EXCEPT ________.
true
If users delete a Field from the Design view by accident, they can click Undo to correct the error.
>=500
If users want to return a subset where a field is greater than or equal to 500, they should enter the criteria as ________.
true
It is common that a database may have several tables where a user will need to establish relationships.
query
It is not common for a user to need to see all data in all tables which is why creating a ________ allowing a user to get a subset of data is so beneficial.
true
None of the features added to Access since that earlier version will be available in a database saved with backward compatibility.
false
Once users create a table sort, they can only modify the existing sort or create a new higher priority sort. They cannot delete the sort.
false
Query criteria is case sensitive and must match exactly to return the desired results.
true
The Save As technique should only be used when a user needs to keep a copy of the original database file.
one to many
The most common type of relationship in Access is ________.
show
There are times that users need to use a field as part of their select, but do not want to display it on their query results. They can accomplish this by unchecking the ________ box on the Query Design Grid for that field.
relationships
To connect two or more tables that have common fields, a user will need to establish and define the table ________.
True
To create a crosstab query using fields from more than one table, the user must create a select query with the fields from both tables and then use the query as the data source for the crosstab query.
true
To create a multiple table query, there must be a relationship established between the tables.
JOIN
To edit an existing relationship, a user will need to right-click on the ________ line.
external data
To establish table relationships, a user needs to click on Relationships from the Relationship Group on the ________ tab.
RUN
To get the results of a Select Query, the user needs to click ________ from the Results Group in the Design Tab.
description
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.
right click
To quickly rename a table, a user can ________ on the table name from the Navigation Pane and select Rename.
true
Typically, tables are not stored with the data sorted, but instead use queries to sort the data used within forms and reports.
True
Users can Save queries and their associated criteria to be run on-demand in the future.
True
Users can add additional tables to databases created from templates.
true
Users can combine Grouped By and Aggregate functions in the same query.
false
Users can perform mathematical calculations on number even if they are stored as short text data type.
true
Users can print and save the relationship report to reference outside of the application.
false
Users can rename a query as long as it is active and open.
true
Users have the ability to move the order of columns within a query.
false
Users must create a queries from scratch.
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.
false
When a user is creating a relationship between two fields within two tables, both fields must have the same name.
true
When a user is creating a relationship between two fields within two tables, one of the fields is typically the primary key for that table.
false
When a user is entering input for a parameter query, the text they input is case sensitive.
access 2002
When a user saves a new database with the default .accdb extension, any user can open the file EXCEPT user who has ________.
False
When a user saves a new query, the results of the query are saved in the database for future reference.
false
When creating a calculated field, all values in the expression must come from an existing table field.
brackets []
When creating a calculated field, the new field name must be followed by a colon and each field name that will be used in the expression must be enclosed within in its own pair of ________.
outtermost
When creating a table sort on two or more fields, the first level of sorting is referred to as the ________ sort field.
Enforce Referential Integrity is checked
When creating relationships, the 1 and ∞ symbol indicate that ________.
and
When multiple criteria must ALL be matched in the query results, a user should use the ________ condition.
TRUE
When users are importing data from an Excel spreadsheet into a new table, they have the option to set their own primary key if there is a field in the source file that is unique for each record.
true
When users enter currency values as criteria, they do NOT need to type the dollar sign.
asterisks (*)
When using a wildcard in a query criteria, a user should substitute a(n) ________ for the missing unknown character(s).
true
When using the Between comparison operator for dates, both of the dates are included in the query results.
pound signs (#)
When using the Between comparison operator, Access will add ________ around the date fields to search correctly.
Database Wizard
Which of the following is NOT a way method to create a new database?
**housing market**
Which of the following is an INCORRECT wildcard placement?
False
Wildcards can be applied to all data types in the query criteria.
criteria
________ are the conditions that users can set in a query to identify the specific records they want to return.
sorting
________ is the process of arranging data in a specific order based on the value in a field.
file
a user can close the existing database and leave access open to continue working on another database by clicking close from the ________ tab
True
a user can create a PDF electronic image of a table instead of printing a paper copy from the print preview screen
False
a user can only select one table or query to perform a simple select query on
true
a user can populate a table with records by typing the data directly into the table
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
Print View
a user can use _______ to view how a table will print before committing
true
a user must have internet access to search online templates
true
access automatically saves each record when you move to the next row, you do not need to click save
True
after users enter critical info and click create, they will be directed immediately to Table 1 after creating a new database from Blank desktop database.
false
all data entered in a table must be visible within the column. anything that is not visible will be cutof
true
all templates provided by microsoft are safe and users can enable content if any warning message is displayed
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
caption
database designers typically do not add spaces in field names (LName), but can add details in the ________ field of the filed properties to provide additional context to the field that is not displayed (Last Name)
flat
databases that are not related or linked to other data are called ____________ databases
True
each table should have a field that contains a unique value for each record in the table
true
entering data on a single-record form will automatically update the data in the record without having to click save
Short Text
fields that contain numbers that are not used in calculators should be set to
false
in the datasheet view, a user will see the underlying structure of the table
false
increasing the column width will also increase the number of characters a user can enter in each field
false
once users select a data type for a field and enter data, they cannot change the data type
false
one of the major advantages of using a database template is that it will populate the tables with data
a single record form
pressing enter three times at the end of multiple-items form will open _________
false
primary keys must be in numbers
layout
the ______ view of a form allows users to view the data while making changes to the elements of the form
primary
the _______ key refers to the unique field that identifies each record
false
the primary key must be the first field in each record
false
the short text data type will allow a user to store up to 512 characters in that field
design
there are two views for tables in Access; datasheet view and _______ view
Field Size
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
globe
to publish a new database that you want to share with others, you should select a template that has an image of a ______.
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
true
users can export an access table to a word document
true
users should not store redundant data within a database and should create a new table to contain that data
source
when appending or creating a new table from an import, the file that is being imported is called the ______ file
four
when considering to use the currency data type, a user should understand that they can store data with one to ______ decimal places
ID
when creating a new table, Access creates the first field and names it ________ which access assigns a unique sequential number
what questions should this database be able to answer?
when designing a new database, the first question users should ask themselves is ______
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 retype them
false
when importing a new table from an existing excel worksheet, the user must import all columns from excel into the new access table
common field
when linking two tables in a relational database, a user will use a _______ to create the link
.accdb
when saving a new database in access 2007-2016 databases, the file extension should be ________
records from: __________ to: __________
which of the following is not an option for printing range of a table?
False
within an access table, each row is a field and each column is called a field