Combo with Microsoft Access 2010- Chapter 2 and 1 other

Created by Kenny_Sayre 

Upgrade to
remove ads

Sizing a column so the column is just wide enough to display the longest visible value in the colums, including the field name. (AC78)

Best Fit

A field property that specifies how the field name is displayed in database objects, including table and query datasheets, forms, and reports. (AC56)

Caption Property

A keyboard shortcut that lets you insert in the current field the value from the same field in the previous record. (AC 75)

Ctrl + '

A condition that occurs when you store the same data in more that one place; it wastes storage space and can cause inconsistincies. (AC 53)

Data Redundancy

An Access tool that allows you to add a group of related fields to a table at the same time, rather than adding each field individually. (AC 82)

Data Type Gallery

A type of text file in which fields of data are separated by a character such as a comma or tab. (AC 89)

Delimited

The optional property you can use to enter a description for a field to explain its purpose or usage. (AC 51)

Description Property

The Access view you use to define or modify a table structure or the properties of the fields in a table. (AC 51)

Design View

The property that defines a field's maximum storage size for Text, Number, and AutoNumber fields. (AC 55)

Field Size Property

The value that results from not entering a value for a field andis not permitted for a primary key. (AC 66)

Null Value

The type of database relationship that exists between two tables when one record in the first table matches zero, one, or many records in the second table, and when one record in the second table matches at most one record in the first table. (AC 72)

One-to-Many Relationship

The "one" table in a one-to-many relationship. (AC 73)

Primary Table

The characteristics of each field in a table. (AC 54)

Properties

The name given to the group of fields you add to a table at the same time using the Data Type gallery. (AC 82)

Quick Start Selection

A set of rules that Access enforces to maintain consistency between related tables when you update data in a database. (AC 93)

Referential Integrity

The "many" in a one-to-many relationship. (AC 73)

Related Table

What are the guidelines for designing databases? (AC 54)

1.Identify all the fields needed to produce the required information.
2. Organize each piece of data into its smallest useful part.
3. Group related fields into tables.
4. Determine each table's primary key.
5. Include a common field in related tables.
6. Avoid data redundancy
7. Determine the properties of each field

When naming a field or object it is important to ... (AC 54)

Choose a field or object name that describes the purpose or contents of the field or object so that later you can easily remember what the name represents.

What field sizes can be changed? (AC 55)

Text, Number, and AutoNumber

How many characters can a text field have? (AC 55)

255

How many digits can a number field have? (AC 55)

15

How many digits can a AutoNumber have? (AC 55)

9

What is the purpose of the Data Type property in a field? (AC 54)

The data type property determines what field values you can enter for the field and what other properties the field will have.

The _____ property specifies how a field's name is displayed in database objects, including table and query datasheets, forms, and reports. (AC 56)

Caption

A(n) _____ value, which results when you do not enter a value for a field, is not permitted for a primary key.(AC 66)

Null

What happens when you delete a field?(AC 83)

You also delete all the values for that field from the table.

The process of relating tables is often called performing a ____. You can extract data from them as if they were one larger table. (AC 91)

Join

To insert a check mark in an empty check box for a yes/no field, you press the ____. (AC 74)

Spacebar

_____ data is the process that allows you to copy the data from a source without having to open the source file. (AC 76)

Importing

The __________ gallery allows you to add a group of related fields to a table at the same time, rather than adding each field to the table individually. (AC 82)

Data Type

A(n) _____ text files is one in which fields of data are separated by a character such as a comma or a tab.(AC 89)

Delimited

The ______ is the "one" table in a one-to-many relationship, and the _____ is the "many" table in the relationship. (AC 92)

Primary; Related

___________ is a set of rules that Access enforces to maintain consistency between related tables when you update data in a database. (AC 93)

Referential Integrity

When defining a filed, the field ______ property detemrines how much physical storage space the fild requires

...

In access, A query criterion use to locate a blank field is _________.

...

The ________ data type can store text, numbers, or symbols

Text

The result of a query, which appears similar to a table, is called a ________

Record Set

The ______ data type is used to hold senteces or pargraphs of descriptive data.

Memo

A(n) ______ field is used to produce a value from an exprssion or function.

...

The ______ determines what field values are allowed and what other properties the field will have

...

Which of the following statements is true about data types and delimiters

Different data types require different delimiters

The ______ field property changes how a field will appear when displayed or printed, but does not change the values stored in the field

Format

Which of the following statements is true regarding muti-table queries?

...

The value in a field with the ____ data type will be automatically increased each time a new record is entered.

AutoNumber

Ryan needs to organize the data in a table so that it displays in a summarized format. He should use the ____ view for this purpose.

Pivot Table

The ____ group on External Data Tab has options that you can use to send a portion of a database to other application.

Export

When defining a field, the field ____ property determines how much physical storage space the field requires.

size

Which of the following statements best describes a one-to-many relationship between two tables?

A primary key in the first table matches several foreign keys in the second table.

Which field property type should be used to enter a predefined value into a field when most of the records will have the same value.

Default Value

The maximum size of the Text data type is ____ characters.

255

Referential integrity should be enforced in a database with related tables because it

helps ensure invalid data is not entered into a table

Which of the following is true about the NOT operator?

The NOT operator returns all records except those that meet the specified criteria.

Which of the following statements is true about how Access and Excel share data?

Access can import data from Excel, and export data to Excel.

Which statement accurately describes the function of a query?

...

Jen is working on a database that stores employee data. In the EmployeeData Table, there is a field that stores the number of years each employee has been with the company. She needs to design a query that shows all employees that have worked for company more than ten years. Which of the following query criteria should Jen use to locate is information and display records of employees with the company for more than ten years?

>10

Two or more tables which contain duplicate data is an example of ____.

...

Which of the following would be the best choice for a primary key?

Social Security Number

When designing a database, all of the following statements are true EXCEPT:

...

Which field property should be applied to fields that should not remain empty?

...

Steven is working on a database that stores student data. He needs to find students majoring in either one of two majors. He is looking for students majoring in Economics. He is also looking for students majoring in History. Which operator would Steven use to find this information?

...

The ____ determines what field values are allowed and what other properties the field will have.

...

A field name can begin with a(n) ____.

...

Jose is working on a database that stores stock information. He needs to design a field that will allow a user to connect to a graph created in Excel. The data type he should apply to this field is:

...

Ben is working in a database that stores student information. He wants to determine each student's age based on the student's birthday. Which of the following statements accurately describe how the fields should be designed?

The birthday should be a stored field and the age should be a calculated field.

Irene is working on a database that stores customer data and order information. The Customer Information Table holds customer information. A unique customer number serves as the primary key for this table. The Order Information Table holds order information. A unique order number serves as the primary key for this table. A customer only has one customer number but may have several order numbers. If Irene wants to establish a one-to-many relationship between the customer information table and the order information table , which of the following steps should she follow?

Irene should include the primary key in the customer information table as a foreign key in the order information table.

Please allow access to your computer’s microphone to use Voice Recording.

Having trouble? Click here for help.

We can’t access your microphone!

Click the icon above to update your browser permissions above and try again

Example:

Reload the page to try again!

Reload

Press Cmd-0 to reset your zoom

Press Ctrl-0 to reset your zoom

It looks like your browser might be zoomed in or out. Your browser needs to be zoomed to a normal size to record audio.

Please upgrade Flash or install Chrome
to use Voice Recording.

For more help, see our troubleshooting page.

Your microphone is muted

For help fixing this issue, see this FAQ.

Star this term

You can study starred terms together

NEW! Voice Recording

Create Set