User:Sam.michaels79

Access

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

Communicate into at meetings Communicate into to outsiders To group and summerize records

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