Database

*to open a specific table*

*double click the title of it*

*Know the symbol to switch the design view in Excel*

*its the one in the bottom right*

select the advantages of using a database instead of a traditional filing system

- a database can provide improved data integrity - a database can hold larger amounts of data

What's true about database fields

- a group of related characters in a database table - represents a characteristic of someone or something

database

- allows greater data sharing - allows unlimited storage

What element of a database field specifies the data in a field such as text, numeric, or data/time?

Data type

To view any relationships between the Drivers table and the ticket table below, where would you click first? AKA how do you see relationships between two different tables?

Database tools

Because Microsoft access includes not only the software needed to create a database, but also the software needed to create forms, reports, data dictionaries and other capabilities, it is often referred to as a database ___ system

Management (DBMS)

A collection of related records in a database is referred to as a ___

Table

On the ribbon, where do you click to change from data sheet view to design view?

View button which under the Home tab

This is the data sheet view of a table in a database. Where would you click to switch to the design view?

View button which under the Home tab

Besides the Database Tools tab, where else could you click to view any relationships between the Drivers table and the Tickets table (below) while in design view?

While viewing a table in design view, you can see relationships using either the database tools tab or the design tab

Individual database

a combined set of data files. intended for use by one person

lage database, often called data banks, that cover particular subjects are referred to as ___ databases

commercial

distributed database

data is stored in different physical locations - accessed through a client/server network

Amazon.com allows you to search for thousands and thousands of items using images and information that are organized logically. This much storage and management requires a complex ___

database

Because it can store virtually unlimited amounts of data that can be shared across networks, and because the data can be kept far more accurately, a ___ has many advantages over a traditional filing system

database

The national gallery of art in Washington, D.C. has nearly 100,000 pieces in its collection. To organize its collection it uses a relational ___ so that curators can locate specific pieces

database

To organize the different table of data, you should probably use a relational ____

database

To organize the different tables of data, the local police force probably uses a relational ____

database

A database that stores data in different physical locations and that users access through client/server networks is called a ___ database

distributed

In a relational database, a common field that links two tables in a relationship but not a primary key is called a ___ key

foreign

Reports provide a means of artfully extracting information from a database; ___ provide a means of accurately entering data into a database

forms

To control how information is entered into a database, programmers and database administrators create ___ to help ensure data integrity

forms

The order in which data is organized in a database (characters, fields, records, tables, files, databases) is referred to the database ___

hierarchy

The database use common fields to create links between tables. this is called a ___ database

relational

A link between tables in a relational database that defines how the data is related is called a ___.

relationship

To display or distribute a summary of data and archive snapshots of the data, data administrators or programmers create:

reports

To display or distribute information from a database, programmers or database administrators create ___.

reports

traditional filing systems

requires no training to use

A DBMS maximizes the benefits a database can provide. DBMS stands for Database Management ____

system

company database

users access the organization database through a lan

your college has a datable with a student table. which of the following could be primary key in the table?

- student number - social security number *must be unique field*

commercial database

often referred to as a data bank

Kate was a senior in college when she married her high school sweetheart. she changed her last name, and because the college used a centralized database, each of her instructors had her new name in their grade books. This is an example of how centralization can improve data ___

integrity

The reliability and the accuracy of the information in a database is referred to as data

integrity

In a relational database, an important field that contains a unique value that identifies each record as individual is the ___ key

primary

A database provides the capability of conducting searches or asking questions. A question or search for information in a database is called a ___

query

Forms structure data input ensure data ___, meaning the information entered is accurate, timely, and useful

integrity

you need to purchase concert tickets for your friends. you go to stubhb.com to find them. in stubhub.com you can search between hundreds of seats in thousands of venues and thousands of events. to organize this information in a searchable manner, stub hub uses a complex

database

because he wanted to be able to sort gifts according to continent and time zones, in 1984 Santa switched from using long lists to using ___.

databases

when programmers design a database, they start by determining what data or characters will be entered. Next, they decide what fields would best organized this data. With this, records and tables can be created, eventually building an entire database. This organization is called the database ___.

hierarchy

Adam was in the fifth grade when he was adopted by the smith's. because his school uses a centralized database, all of his teachers had his correct name on their grade reports. This is an example of how centralized database can help improve data ___

integrity

In the database view of a relational database (such as Microsoft access) a row of information is called a ___

record