Microsoft Access – G701 Database
Documents - G701-04 Database Vocabulary
G701b-Demonstrate Basic Database Concepts and Functions
Homework - G701-08 Plan, Create, Save – Retrieve, Edit, Resave, Email
Homework Online - Database Basics Review Quiz (based on G701-11)
Handout G701-04
Database Vocabulary
Alternative input methods — Approaches to inputting data rather than using the traditional keyboard/mouse utilizing programs such as speech or handwriting recognition or features of PDAs.
Arithmetic operators — Symbols used in mathematical expressions in queries to retrieve information from a database. (Ex. +, - , *, /)
Arrange — Process of placing data in a particular order.
Ascending - Process of arranging data in an A-Z or smallest to largest number order.
Calculated column/field — A column or field containing data created by using a formula.
Calculation — The process of computing data using formulas.
Character or text data — Entries in a database or spreadsheet that represent text—such as, phone numbers, names, color, size.
Column width — The amount of space given a field or column.
Columns — Vertical section of the database table; corresponds to a field.
Comparison operators — Used in math expressions in queries to compare pairs of values (ex. <, >, <=).
Criteria expression- Used in a query to identify the information to retrieve from the database.
Currency — A numeric type of data which adds a $ sign to the number. Also allows the user to determine the number of decimals to be displayed.
Data — Information keyed into a database; also known as an entry.
Database — An efficient means of storing and retrieving data and printing reports from the stored data.
Database Management System — A package of computer programs and documentation that lets one establish and use a database. It allows one to store and retrieve data according to his/her own criteria. An example is Access software.
Datasheet View — A method of viewing or inputting data that contains information about more than one record at a time; table with rows (records) and columns (fields); also known as list view.
Date data — Entries in a database or spreadsheet that are formatted for a date in a particular style. (Ex. 01/01/00 or January 1, xxxx)
Default — The preset conditions of the software which may be modified.
Descending — Process of arranging data in a Z-A or largest number to smallest number order.
Design — Process of determining each of the fields, field properties, and data types in a database.
Edit — To change or modify the original entry.
Entry — The data and formulas that are typed in a field.
Field — One item of information in a record and is represented by a column.
Field name — The title you assign each field.
Field properties — Additional design information about a database—such as field size, decimal places, and format.
File — a saved database.
Font — A group of characters (letters, numbers, and symbols) that have a similar appearance.
Footer — Repetitive text automatically printed at the bottom of a document, such as a page number.
Form — A customized manner of inputting data into a database or presenting data on a screen.
Form view — A customized manner of inputting data into a database or presenting data on a screen.
Format — The procedure of defining how information appears on a page. This may include bold, underlining, italics, arranging text on a page, number of decimal places, the style of print, color, etc.
Header — Repetitive information that is automatically printed at the top of each page of a document.
Key — Identifier for each record; data entry cannot be duplicated (ex. Catalog or Identification Number); also known as primary key.
Landscape — Page orientation (layout) that is wider than tall; horizontal or wide layout.
List View — A method of viewing or inputting data that contains information about more than one record at a time; table with rows (records) and columns (fields); also known as Datasheet View.
Numeric data — Entries in a database or spreadsheet that are formatted for numbers that can be used in calculations.
Percent - A numeric type of data which adds a % symbol to a number.
Primary sort — A method of sorting a column of data in a particular order by selecting the field to consider first when sorting.
Query — A request of information from a database based on certain criteria.
Record — A group of related fields of information. Everything on one row is a record.
Report — Specifications for output of data in a particular format.
Retrieve — The process of loading information that has been stored.
Right justified — Alignment that allows a document to have an even right margin.
Row — Horizontal section of a database table; corresponds to a record in a database.
Save — The process of storing a file on a disk or other storage medium for future use.
Search — The ability to locate a string of characters or particular data in a document.
Secondary sort — When sorting a column of data, the second column to consider when arranging the data.
Sort - Process of arranging data in a particular order.
Table wizard — A feature that provides sample of tables, each with its own appropriate fields, which may be formatted in the document.
Update — Add or change data in a document.
Activity G701-08
Plan, Create, Save – Retrieve, Edit, Resave, Email
Step 1: Open a new database and save it as B&BStudent. You are creating a database for the Bed and Breakfast Association. Remember to add your name to the filename for identification purposes!
Step 2: Determine appropriate field names, field types, and sizes from the categories below. Use Yes/No field type for all situations where appropriate. Save the table as ReservationsStudent.
Name of the Historic Inn / Number of Rooms Available for Rental? / Are Children under 10 allowed? / Located in the CITY? / Small Town or Mountain Community? / Full Breakfasts Available? /WhiteGate Inn and Cottage (1889) / 6 / Yes / Yes / No / Yes
Inn on Montford (1900) / 5 / No / Yes / No / Yes
Secret Garden (1904) / 3 / No / No / Yes / Yes
Abbington Green / 8 / Yes / Yes / No / Yes
Albemarle Inn / 11 / No / Yes / No / Yes
A Bed of Roses / 5 / No / Yes / No / Yes
Biltmore Village Inn / 6 / No / Yes / No / Yes
Blake House Inn / 6 / Yes / Yes / No / Yes
Carolina Bed & Breakfast / 7 / Yes / Yes / No / Yes
Cedar Crest Victorian Inn / 12 / No / Yes / No / Yes
Chestnut Street Inn / 8 / Yes / Yes / No / Yes
Colby House / 5 / Yes / Yes / No / Yes
Dry Ridge Inn / 8 / Yes / Yes / No / Yes
The Hawk & Ivy / 4 / Yes / No / Yes / Yes
Inn on Main Street / 7 / No / No / Yes / Yes
The Lion and The Rose / 5 / Yes / Yes / No / Yes
North Lodge on Oakland / 6 / Yes / Yes / No / Yes
Owl's Nest Inn at Engadine / 7 / No / No / Yes / Yes
Step 3: Key the field entries for the inn’s name and number of rooms into the database. Enter the Yes/No entries into the remaining fields. Save the results and email to instructor.
Step 4: Open B&BStudent and add a new field so guests will know if Pets are allowed. Inns allowing pets include the following: Abbington Green, Biltmore Village Inn, Blake House Inn, Carolina Bed & Breakfast, and Owl’s Nest Inn at Engadine. Resave the database as B&BStudent-Rev and email to instructor.
Activity G701-11
Objective 7.01 Database Basics Review (Online Quiz)
Directions: Place the correct letter of the term beside the description.
Description / Term1. A group of records treated as a unit / a. backspace
2. The action of removing a records from a database file / b. database
3. Adding new records, deleting irrelevant entries, and replacing incorrect entries / c. deleting
4. A single item of information in a database / d. descending
5. Action that should be taken after establishing a database / e. editing
6. Action taken when user wishes to get a file to update / f. entry
7. Data keyed in fields of a database / g. field
8. Key used to delete data to the immediate left of the cursor / h. file
9. A field type used for numbers that are not used in calculations / i. filter
10. Arranging data/records into a particular order / j. form view
11. The ability to retrieve records/data from the database by matching a selected condition / k. landscape
12. A group of related fields / l. primary key
13. A method of viewing or inputting data which contains fields for one record at a time / m. query
14. A set of conditions and sorting instructions that provides for retrieval of certain records / n. record
15. Sorting data/records in a database from highest to lowest number / o. resave
16. Field whose data is different for each record; used to identify a record / p. retrieve
17. The action that should be taken following changes, additions, or deletions to an existing database table / q. save
18. A collection of data organized so its contents can be accessed, managed, and updated / r. sorting
19. An example of an alternative input method / s. speech recognition
20. Printing a table in a page layout orientation that is wider than it is tall / t.. text