MIS Access Exam 1

Data integrity

...

collapse and expand buttons

...

completeness

...

consistency

...

fields represented in columns

...

maximum

...

minimum

...

range check

...

records represented as rows

...

validation

...

zip file

...

guidelines for creating databases

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

extension

A filename ________ identifies the file's type and indicates the application that created the file

condition

A(n) _______ is a criterion, or rule, that determines which records are selected for a query datasheet.

query

A(n) _______ is a question you ask about the data stored in a database.

filter

A(n) _______ is a set of restrictions you place on the records in an open datasheet or form to isolate a subset of records temporarily.

delimited

A(n) _________ text file is one in which fields of data are separated by a character such as a comma or a tab.

Zip button in send group under share tab on ribbon

Describe how to compress a file or folder.

the field list contains the table name and the top of the list and the tables fields listed in the order in which they appear in the table. the design grid displays columns that contain specifications about a field you'll use in query

Describe the field list and the design grid in the Query window in Design view.

oldest to most recent

For a Date/Time field, how do the records appear when sorted in ascending order?

file maintenance

For example, adding/deleting employees and customers, making address changes and changing product prices.

they look the same appearing in datasheet view and can be used to update data in a database. table datasheet shows the permanent data in the table and a query datasheet is temporary

How are a table datasheet and a query datasheet similar? How are they different?

in Navigation mode, the entire field value is selected, and anything you type replaces the field value. in editing mode, you can insert/delete characters in a field value based on the location of the insertion point

In Datasheet view, what is the difference between navigation mode and editing mode?

icon

In the Navigation Pane, each database object has a unique ________ to its left that identifies the objects type.

and-separate fields in the same criteria row or- in different criteria rows

In the design grid, where do you place the conditions for two different fields when you use the And logical operator, and where do you place them when you use the Or logical operator?

Move and Copy Files

Moving a file removes it from its current location and places it in a new location you specify Copying places the file in both locations

clipboard

One way to move files and folders is to use the _____, a temporary storage area for files and information that you copied or moved from one place and plan to use somewhere else.

data type

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.

primary table, related

The _____ is the "one" table in a one-to-many relationship, and the ________ is the "many" table in the relationship.

group by

The ______ operator divides selected records into groups based on the values in a field.

navigation pane

The _______ is the area of the Access window that lists all the objects in a database, and it is the main control center for opening and working with database objects.

primary key, foreign key

The ________, whose values uniquely identify each record in a table, is called a(n) ___________ when it is placed in a second table to form a relationship between the two tables.

data warehousing

The electronic storage of a large amount of information by a business

form tool

The quickest way to create a form is to use the _________.

one to many relationship

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

structure

To copy the records from a table in one database to another table in a different database, the two tables must have the same _______.

expression

To perform a calculation in a query, you define a(n) ______ containing a combination of database fields, constants, and operators.

you can more quickly transfer them to another location

What are the benefits of compressing files and folders?

...

What command can you use in Datasheet view to remove the display of one or more fields from the datasheet?

record being edited, next row available for new edit

What does a pencil symbol at the beginning of a record represent? What does a star symbol represent?

it selects all files in between

What happens if you click the first file in a folder window, press the Shift key, click the last file, and then release the Shift key?

a type of database object that shows information in Datasheet view (Datasheet view: A view that displays data from a table, form, query, view, or stored procedure in a row-and-column format. In Datasheet view, you can edit fields, add and delete data, and search for data.).

What is a select query?

object type

What is the default category for the display of objects in the Navigation Pane?

you delete all the values for the field from the table

What is the effect of deleting a field from a table structure?

CTRL

What is the keyboard shortcut for inserting the value from the same field in the previous record into the current record?

ID field

What is the name of the field that Access creates, by default, as the primary key field for a new table in Datasheet view?

to navigate to a different folder

What is the purpose of the Address bar in File Explorer?

...

When you define multiple sort fields in Design view, describe how the sort fields must be positioned in the design grid.

Recycle Bin

When you delete a file from a hard disk, Windows removes the file from the folder but stores the file contents in the ______.

expression builder

Which Access tool do you use to create an expression for a calculated field in a query?

add and delete

Which group on the FIELDS tab contains the options you use to add new fields to a table?

print preview

Which view enables you to see the total number of pages in a report and navigate through the report page?

common field

You connect the records in two separate tables through a(n) that appears in both tables.

folders

You organize files by storing them in______?

importing

______ data is a process that allows you to copy the data from a source without having to open the source file.

backing up

_______ a database is the process of making a copy of the database file to protect the database against loss or damage.

referential integrity

________ is a set of rules that Access enforces to maintain consistency between related tables when you update data in a database.

compacting

__________ a database rearranges the data and objects in a database to decrease its file size and enhance the speed and performance of the database.

tables

a collection of fields that describes a person, place, object, event, or idea

DataBases

a collection of related tables stored in the same file

form

a database object you can create and customize to maintain, view, and print records in a database in different and useful ways

primary key

a field, or a collection of fields, whose values uniquely identify each record in a database table

report

a formatted printout (or screen display) of the contents of one or more tables or queries in a database

data types

a particular kind of data item, as defined by the values it can take, the programming language used, or the operations that can be performed on it.

foreign key

a primary key field from one table that you include as a field in a second table to form a relationship between the two tables

query

a question you ask about the data stored in a database. In response, Access displays the specific records and fields that answer your question.

one to one relationship

a relationship between two tables in which each record in the first table matches at most one record in the second table, and each record in the second table matches at most one record in the first table

DBMS

a software program that lets you create databases and then manipulate data in them

field

a(n) ______ is a single characteristic of a person, place, object, event, or idea

recycle bin

an area on your hard disk that holds deleted files until you remove them permanently Only files deleted from the C drive will be put in there

Data dictionary

contains data about each file in the database and each field in those files

enforce referential integrity

enforcing a set of rules that Access enforces to maintain consistency between related tables when you update data in a database

GIGO

garbage in, garbage out

characters

one byte ie. numbers

moving

removes a file from its current location

data mining

the practice of examining large databases in order to generate new information.

restore buttons

the window to the size it was prior to using the Maximize button.