Access Chapters 1-3

Lakukan tugas rumah & ujian kamu dengan baik sekarang menggunakan Quizwiz!

Which of the following is an INCORRECT wildcard placement? a) *housing market b) *housing market* c) housing*market d) **housing market**

**housing market**

When saving a new database in Access 2007-2016 databases, the file extension should be ________. a) .dbx b) .adbx c) .accdb d) .db

.accdb

All of the following are comparison operators EXCEPT ________. a) < b) > c) / d) =

/

If users want to return a subset where a field is greater than or equal to 500, they should enter the criteria as ________. a) >= 500 b) => 500 c) <= 500 d) =< 500

>= 500

When multiple criteria must ALL be matched in the query results, a user should use the ________ condition. a) AND b) OR c) IF d) IS NOT NULL

AND

When a user saves a new database with the default .accdb extension, any user can open the file EXCEPT user who has ________. a) Access 2002 b) Access 2007 c) Access 2013 d) Access 2016

Access 2002

________ are the conditions that users can set in a query to identify the specific records they want to return. a) Selection b) Search c) Criteria d) Sort

Criteria

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

When creating relationships, the 1 and ∞ symbol indicate that ________. a) Cascade Update Related Fields is unchecked b) Cascade Update Related Fields is checked c) Enforce Referential Integrity is unchecked d) Enforce Referential Integrity is checked

Enforce Referential Integrity is checked

To establish table relationships, a user needs to click on Relationships from the Relationship Group on the ________ tab. a) Home b) Create c) External Data d) Database Tools

External Data

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. a) True b) False

False

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

Query criteria is case sensitive and must match exactly to return the desired results. 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

Users can perform mathematical calculations on number even if they are stored as short text data type. a) True b) False

False

Users can rename a query as long as it is active and open. a) True b) False

False

Users must create a queries from scratch. a) True b) False

False

When a user is creating a relationship between two fields within two tables, both fields must have the same name. a) True b) False

False

When a user is entering input for a parameter query, the text they input is case sensitive. a) True b) False

False

When a user saves a new query, the results of the query are saved in the database for future reference. a) True b) False

False

When creating a calculated field, all values in the expression must come from an existing table 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

Wildcards can be applied to all data types in the query criteria. 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 add ________ to the criteria for a field in the Query Design Grid to return results where there is nothing in that field. a) Is Empty b) Is Not Empty c) Is Null d) Is Not Null

Is Null

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

When creating a table sort on two or more fields, the first level of sorting is referred to as the ________ sort field. a) Parent b) Child c) Outermost d) Innermost

Outermost

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: ________

To get the results of a Select Query, the user needs to click ________ from the Results Group in the Design Tab. a) Start b) Run c) Execute d) Search

Run

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

________ is the process of arranging data in a specific order based on the value in a field. a) Sorting b) Filtering c) Cascading d) Grouping

Sorting

A user can change the sort order of a query from the Datasheet View. a) True b) False

True

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 can sort on more than field within a table. 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

Aggregate functions should be added to the Total row in the Query Design Grid. 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

It is common that a database may have several tables where a user will need to establish relationships. a) True b) False

True

None of the features added to Access since that earlier version will be available in a database saved with backward compatibility. a) True b) False

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. a) True b) False

True

To create a many-to-many relationship, a user must create a third table that contains the primary keys of both tables. 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

Typically, tables are not stored with the data sorted, but instead use queries to sort the data used within forms and reports. a) True b) False

True

User can export an Access Table to a Word Document. a) True b) False

True

Users can Save queries and their associated criteria to be run on-demand in the future. a) True b) False

True

Users can add additional tables to databases created from templates. a) True b) False

True

Users can apply the OR condition to a single field. a) True b) False

True

Users can combine Grouped By and Aggregate functions in the same query. a) True b) False

True

Users can print and save the relationship report to reference outside of the application. a) True b) False

True

Users can set the sort order from within the Query Design Grid. a) True b) False

True

Users have the ability to move the order of columns within a query. 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 a user is creating a relationship between two fields within two tables, one of the fields is typically the primary key for that table. 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 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. a) True b) False

True

When users enter currency values as criteria, they do NOT need to type the dollar sign. a) True b) False

True

When using the Between comparison operator for dates, both of the dates are included in the query results. 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

When using a wildcard in a query criteria, a user should substitute a(n) ________ for the missing unknown character(s). a) quotation marks (") b) asterisks (*) c) pound signs (#) d) ampersands (&)

asterisks (*)

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 ________. a) quotation marks (") b) asterisks (*) c) brackets ([]) d) pound signs (#)

brackets ([])

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

To establish table relationships, a user will link the primary key of one table to the ________ key of the connected table. a) linked b) source c) destination d) foreign

foreign

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

To edit an existing relationship, a user will need to right-click on the ________ line. a) link b) connection join destination

join

The most common type of relationship in Access is ________. a) one-to-one b) many-to-many c) one-to-many d) many-to-one

one-to-many

When using the Between comparison operator, Access will add ________ around the date fields to search correctly. a)quotation marks (") b) asterisks (*) c) pound signs (#) d) ampersands (&)

pound signs (#)

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. a) query b) search c) find d) grouping

query

The Query window is broken into two parts, the table area and the ________. a) field list area b) properties grid c) query list area d) query design grid

query design grid

To quickly rename a table, a user can ________ on the table name from the Navigation Pane and select Rename. a) single-click b) double-click c) triple-click d) right-click

right-click

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

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. a) show b) hide c) display d) criteria

show

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


Set pelajaran terkait

Chapter 1 Statistics and how they are used

View Set

Astronomy Mid-term Part 4 (Chapter 1)

View Set

Business Management Final Exam Study Guide

View Set

OPMA 3306 Chapter 1-4/6-8 w/ quizzes

View Set

Chapter 12: Gender, Sex, and Sexuality

View Set

Chapter 11 Auditing the Purchasing Process

View Set

Chapter 6 Video: The Value of Careful Revision and Evaluating Your First Drafts

View Set