Access Vocabulary

5. – a way to structure your data for printing with format enhancements
6. view – the view of a table that shows you the data in each record. Like a spreadsheet, the datasheet shows rows (records) and columns (fields).
7. – a collection of database fields designed to be used together
8. pane – the listing of all the objects in the database.
10. Includes all of the characteristics of and which properties which define the filed including field name, data type and formatting properties
13. property – Characteristics of a field that determine how long an entry can be, how the entry will be formatted, whether there should be a default entry, and what can be entered (for example, numbers only or valid dates only).
14. – to display records based on whether or not they match specified criteria.
15. key – a field that uniquely identifies each record in a table

1. – a table, query, report, form or other item used to store or manage data in a database
2. – a defined set of operations to be performed on a table (or on the results from another query).
3. A collection of information that is associated with a specific subject; makes organizing, storing and updating information very easy by letting you place information into categories which are intertwined allowing you to update information in more than one location
4. type – the type of data that a particular field is designed to hold (for example: Number, Text, Date, Memo)
6. view – an object view that allows you to design and change tables, queries, forms, reports and other objects
9. To transfer data from one location to another
11. To convert data from one computer program into another
12. – a collection of variable data about one person or thing.
13. – an alternative view of a table or query, displaying the fields in and easy to enter arrangement, usually one record at a time.