Term
|
Definition
| A collection of fields that describe a person, place, object, event, or idea |
|
|
Term
|
Definition
| The specific value, or content, of a field is called the what? |
|
|
Term
|
Definition
|
|
Term
| Database, or a Relational Database |
|
Definition
| A collection of related tables |
|
|
Term
|
Definition
| You connect the records in the separate tables through a __________ _________ that appears in both tables. |
|
|
Term
|
Definition
| A field whose values uniquely identify each record in a table |
|
|
Term
|
Definition
| When you include the primary key from one table as a field in a second table to form a relationship between the two tables, it is called a ________ _________ in the second table. |
|
|
Term
| Database management system (DBMS) |
|
Definition
| A software program that lets you create databases and then manipulate data in them. |
|
|
Term
| Relational database management system |
|
Definition
| In a __________ __________ _________ _________, data is organized as a collection of tables. |
|
|
Term
|
Definition
| READ HIGHLIGHTED INFO ON PAGE (AC5) |
|
|
Term
Field
Record
Table
Database |
|
Definition
| What four things are used to organize data? And in what order do they go? |
|
|
Term
|
Definition
| A predesigned database that includes professionally designed tables, reports, and other database objects that can make it quick and easy for you to create a database. |
|
|
Term
1. Choose fields
2. Group fields into tables
3. Choose primary key |
|
Definition
| What are the steps in creating a database? |
|
|
Term
|
Definition
| The new blank table that access created is displayed in _________ ______. |
|
|
Term
|
Definition
| The area on the left side of the window that lists all the objects in the database, and it is the main control center for opening and working with database objects. |
|
|
Term
|
Definition
| Read what is highlighted on page AC 15 and AC 16 |
|
|
Term
|
Definition
|
|
Term
|
Definition
| When copying records from another access database, you must have the same _______ _______. |
|
|
Term
|
Definition
| Provide another way to move vertically through the records. |
|
|
Term
|
Definition
| A question you ask about the data stored in a database |
|
|
Term
| Available fields list box |
|
Definition
| You need to select fields from the ____________ _________ _______ ______ to include them in the query. |
|
|
Term
|
Definition
| The query results are ______ ______ in the database. |
|
|
Term
|
Definition
| The query _______ is stored as part of the database with the name you specified. |
|
|
Term
|
Definition
| An object you use to enter, edit, and view records in a database (1 at a time). |
|
|
Term
|
Definition
| This creates a form containing all the fields in the table or other database object on which you're basing the form. |
|
|
Term
|
Definition
| In _________ ________, you can make design changes to the form while it is displaying data. |
|
|
Term
|
Definition
| This places all the fields from a selected table (or query) on a report, making it the quickest way to create a report. |
|
|
Term
|
Definition
| By _________ your databases, you can ensure that they operate in the most efficient way, that the data they contain is secure, and that you can work with the data effectively. |
|
|
Term
|
Definition
| _________ a database rearranges the data and objects in a database to decrease its file size, thereby making more space available on your disk and letting you open and close the database more quickly. |
|
|
Term
1. Identify all the fields needed to produce the required info.
2. organize each piece of data into its smallest useful part
3. group related fields into tables
4. Determine each tables primary key
5. include a common field in related tables
6. avoid data redundancy
|
|
Definition
| Guidelines for Designing Databases: |
|
|
Term
|
Definition
| In the ______ data type, the field size is 0 to 255 characters: default is 255. |
|
|
Term
|
Definition
| In the ______ data type, the field size is 1 to 65,535 characters. |
|
|
Term
1.Number
2. Positive, 3. Negative |
|
Definition
| In the 1.________ data type, its field size is 1 to 15 digits and it allows 2.________ and 3.________ numbers. |
|
|
Term
|
Definition
In the ________ data type, the field size is accurate to 15 digits ont the _____ side of the decimal point and to 4 digits on the _______ side.
*Answers respectively |
|
|
Term
|
Definition
|
|
Term
|
Definition
| In the _________ data type, the field size is 9 digits. |
|
|
Term
|
Definition
| In the _______ data type, the field size is 1 character. |
|
|
Term
|
Definition
| The ________ ______ for a table uniquely identifies each record in a table. (Can't have blank field) |
|
|
Term
|
Definition
|
|
Term
|
Definition
| This 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. |
|
|
Term
|
Definition
A set of rules that Access enforces to maintain consistency between related tables when you update data in a database.
*the rules are on page AC 83 |
|
|
Term
|
Definition
| This allows you to search a table or query datasheet, or a form, to locate a specific field value or part of a field value. |
|
|
Term
| all tables you're able to open |
|
Definition
| What does the query window show? |
|
|
Term
|
Definition
Access lets you select up to _____ different sort fields.
These sort fields must be in __________ columns in the datasheet. |
|
|
Term
|
Definition
| A set of restrictions you place on the records in an open datasheet or form to temporarily isolate a subset of the records. |
|
|
Term
|
Definition
| Read what you wrote on page AC 116. |
|
|
Term
|
Definition
A field that displays the results of an expression.
*DO NOT PUT THIS ON A TABLE |
|
|
Term
|
Definition
| A placeholder you use when you know only part of a value or when you want to start or end with a specific character or match a certain pattern |
|
|
Term
1. *
2. ?
3. []
4. !
5. -
6. # |
|
Definition
List of Wildcard Characters:
*There are 6 Characters
*Test Question: Which one IS NOT a wildcard character? |
|
|
Term
|
Definition
|
|
Term
|
Definition
|
|
