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