Access Vocab words

123456789101112131415
Across
  1. 2. type – the type of data that a particular field is designed to hold (for example: Number, Text, Date, Memo)
  2. 4. a defined set of operations to be performed on a table (or on the results from another query).
  3. 7. view – an object view that allows you to design and change tables, queries, forms, reports and other objects
  4. 8. – a table, query, report, form or other item used to store or manage data in a database
  5. 10. pane – the listing of all the objects in the database.
  6. 11. Includes all of the characteristics of and which properties which define the filed including field name, data type and formatting properties
  7. 14. – an alternative view of a table or query, displaying the fields in and easy to enter arrangement, usually one record at a time. Import- To transfer data from one location to another
  8. 15. To convert data from one computer program into another
Down
  1. 1. a collection of database fields designed to be used together
  2. 3. – to display records based on whether or not they match specified criteria.
  3. 5. a collection of variable data about one person or thing.
  4. 6. 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).
  5. 7. 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
  6. 9. 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. 12. key – a field that uniquely identifies each record in a table
  8. 13. a way to structure your data for printing with format enhancements