User:Sam.michaels79

Access Communicate into at meetings Communicate into to outsiders To group and summerize records
 * Microsoft Office Access-ralational database software that runs on the windows operating system
 * Several users can share and edit info simultaneously
 * Access stores any # of records up to 2GB
 * Access allows links between lists of into the reduce data redundancy
 * Tables-The fundamental building blocks of a relational database bc they store all of the data
 * Field names are listed at top of each column
 * Field-smallest unit of data organization;consists of a specific category
 * Record-a group of related fields that decribe a person, place, thing
 * Table-collection of records for a single subject
 * Database- collection of tables associated with a general topic
 * Relational database-an access database with multiple tables that are linker together by a common field
 * objects-ex. Tables, queries, forms, reports, macros, module
 * Tab and enter key move the focas to the next field
 * In navigation mode, press tab or enter to move to the next field within the same record
 * In edit mode, access assumes that you are trying to make changes to the current field value.
 * [Home] moves to the first field of the current record
 * You can resize the width of a field in a datasheet by dragging the column separator, the thin line.
 * F2 switches btw edit and navigation mode
 * [ESC] undoes the change to the current field
 * [ESC] [ESC] undoes all changes to the current field
 * To move a column, click the field name to select then drag
 * Table-contains all of the raw data within the database in a spreadsheet-likeview
 * report-provides a professional printout of data that can contain enhancements ex. Headers, footers, graphics, and calculations on groups of records
 * Formula in not a data type
 * Autonumber-Integers assigned by access to sequentially order each record added to a table(can not edit #)
 * OLE object-office and window files that can be linked or embedded (OLE) such as pix, sounds documents, and spreadsheets
 * primary key- an indentifier
 * Query-allows you to select a subset of fields and records from 1 or more tables and then present the selected datat as a single datasheet
 * Query design view-add, delete, or move the fields in an existing query, to specify sort orders, or to add criteria to limit the # of records shown in the resulting datasheet
 * If the fields of 2 or more related tables are used in the query, the relationship btw 2 tables is displayed with a Join Line
 * Join Line-indentifying which fields are used to establish the relationship
 * Field selector-Thin grey bar above each field in the query grid.
 * A query can be used to create calculated fields.
 * By default, records in a table datasheet are sorted on the primary key field
 * Sort orders always work left to right
 * Find/sort button-ascending-sorts records based on the selected field in ascending order (0-9) or (a-z)
 * descending-sorts records based on the selected fields (z-a)
 * recall that criteria are limiting conditions you set
 * To search for a pattern, you can use a wildcard, character to represent any character in the criteria entry. Us a ? to search for any # of charchers
 * Commonly used as the source of data for a form or report. Filters-NO Queries-Yes
 * Access assist you with criteria syntax- rules by which criteria need to be entered. Refer to as criteria syntax or syntax
 * Comparison operators - > greater than < = less than or equal to
 * You can use access report for
 * page header-at the top of every page
 * Group header-Before every group of record
 * Page footer-at the bottom of every page
 * Access reports can be based on either a table or query object
 * Click back for view previous dialog boxes within wizard