Access Exam

what are the five primary functions of a database management system (DBMS)?

1. allows you to create database structures containing fields, tables, and table relationships. 2. lets you easily add new records, change field values in existing records, and delete records 3.it contains a built-in query language, which lets you obtain immediate answers to the questions (or queries) you ask about your data 4.it contains built-in report generator, which lets you produce professional-looking, formatted reports from your data 5.it protects databases through security, control, and recovery facilities

The default Field Size for the Short Text data type is ____________________ characters.

255

The default character length for the Short Text data type is ____ characters.

255

how many characters may a field name in access contain including numbers, letter, spaces, and special characters?

64

Field value maximum storage size is defined by the Field Size property for the data types including Short Text, Number, and ____________________ only.

AutoNumber

____ is the default name for a new table in an Access database.

Table1

a database or a relational database is a collection of related tables

True

each row in an access table datasheet displays which of the following?

a record

files created with access 2016 may be used with which previous version of access?

access 2010

which access database object asks a question about the data stored in a database and displays specific fields and records that answer the question?

access help

which access feature provides information about access commands and features and instructions about how to use them?

access help

The data type that allows both sequential and random numbering is the ____ data type.

autonumber

Which data type allows the designer to define the Field Size property?

autonumber

which of the following attributes of a table are saved only when the table object is saved?

characteristics of the fields

when copying and pasting records from one table to another, the records must first be copied to the _______?

clipboard

clicking on the close option from the backstage view in access 2016 performs which of the following tasks?

closes the current database

A field used to connect one table logically with another table is called a ____ field

common

records in separate tables may be connected through a(n) _____________ that appears in both tables

common field

which term identifies a field that appears in two separate tables and may be used to connect records in the separate tables?

common field

the ____________ option is available to compact and repair a database file automatically every time the database is closed

compact on close

the process of decreasing the file size of a database and enhancing the performance of the database is called ___________ the database

compacting

The ____________________ data type is not subject to round-off error when calculated, unlike the Number data type with decimal values.

currency

Which data type would be the best logical data type for a field named PaidDate?

date/time

A value set in the Field Properties pane that appears in a field automatically is the ____ for the field.

default value

It is important that data being imported from a text file into Access are separated by a character, such as a comma, which defines the text file as a(n) ____ text file.

delimited

When choosing field names, it is best to choose names that ____.

describe the content or purpose of the field

____________________ view allows the database designer to enter both the field names and define the field properties.

design

To begin importing data from an Excel spreadsheet, click on the ____ tab on the ribbon.

external data

(quiz 2) All fields in a database should be contained in one table.

false

A primary key that consists of two or more fields is called a(n) redundant key.

false

Access automatically assigns the Number data type to all new fields.

false

Field names in a table may only be changed in Design view.

false

Hiding a field in Datasheet view removes the field from the current table. ____________________

false

In the Database Design grid, press the Enter key to move from one property to the next property.

false

It is more efficient to use the Query Wizard for common, informational queries than to design your own query. ____________________

false

It is not possible to create a query from more than one table. ____________________

false

Relationship integrity is a set of rules used by Access to maintain consistency between related tables when data in either table is updated.

false

Results of a query are narrowed by using the Or logical operator. ____________________

false

The default query type for Access is the Crosstab query. ____________________

false

a query is used to enter, edit, and view records in a database

false

a single characteristic or attribute of a person, place, object, event or idea is a table

false

access report printing options may be changed using the navigation dialog box

false

each record in a table is uniquely identified by a foreign key

false

the only option available for creating tables in Access is to use the datasheet view

false

the query results are stored in the database in which the query has been created

false

each column in an access table datasheet represents a

field

A database system determines how to store, display, and process field values based on which of the following?

field properties

The way field values are stored, displayed, and processed in an Access database is determined by the ____________________.

field properties

in a relational DBMS, a user may create a database structure that contains which of the following?

fields, table, and table relationships

A primary key field from one table that is also a field in another table and is used to create a relationship between the two tables is a(n) ____________________ in the second table.

foreign key

a field in a second table that is the primary key in the first table is used to form a relationship between the two tables; the field in the second table is called a(n) ___________

foreign key

which access database object(s) might be used to enter, edit, and view records in a database?

forms

The "many" side of a one-to-many relationship is represented by the ____________________ at the end of the join line.

infinity symbol ampersand infinity

The common field between two tables in the Relationship window is indicated by a(n) ____.

join line

which view is used to make design changes to a form while the form is displaying data?

layout view

Which of the following is the most logical data type to use if a field will contain long comments or explanations?

long text

A field in an Access database table that has no value is determined by Access to have a ____ value.

null

explain the difference between a primary key and a foreign key

primary- field or collection of fields whose values uniquely identify each record in a table foreign- primary key is a field in a second table to form a relationship

data organized as a collection of tables created this type of data system

relational database management system

what function does compacting an access database perform other than reducing the file size?

repairing the database

which data type allows field values to contain letters, digits, and other characters?

short text

The ____________________ Field Size property of a Number field stores positive and negative numbers to precisely seven decimal places in four bytes.

single

A key or combination of keys that complete an action more efficiently than using the mouse is called a(n) keyboard shortcut

true

Access does not require a field description for every field included in a table.

true

Access does not require a table to have a(n) primary key

true

Changes made to a field in a query datasheet updates the same field in the table on which the query is based. ____________________

true

Data redundancy should be avoided because it wastes storage space and might cause inconsistencies within the database.

true

Fields included in a query may be modified after the query is saved. ____________________

true

In order to define table relationships, each table being joined must contain a common field.

true

Logical operators must be used in order to combine two or more conditions in a query. ____________________

true

The Currency data type is accurate up to 4 digits on the right side of the decimal point.

true

The Data Type Gallery, which allows the entry of groups of fields using the Quick Start selection, is only available in Datasheet view.

true

The field name displayed in database objects, including forms and reports, is determined by the Caption property

true

To toggle between navigation mode and editing mode press the F2 keyboard shortcut. ____________________

true

When a question is asked of a database using a select query, the answer is returned as a data sheet. ____________________

true

When text is used as the Default Value for a field property, it is recommended that the text be enclosed within quotation marks to avoid an "invalid syntax" error message

true

a software program that lets the user create databases and then manipulate the data in the database is called a database management system (DBMS)

true

compacting a database rearranges the data and objects in a database to decrease its file size

true

each access database may be as large as two gigabytes in size and may have up to 255 people using the database at the same time

true

field values that may be entered into a field are determined by the data type of the field

true

the default primary key for an access database is the ID field

true

the default sort order for records in an Access table is based on the values in the primary key field

true

Formatting Date/Time fields changes only the way data is displayed, not the field ____.

values

The ____ data type only allows a field length of 1 character and is used to indicate the presence or absence of a condition.

yes/no