Database	Collection of related data used for a specific purpose - (compare to Excel). Example: Mailing list, Christmas card list, employee data, student database
Table	A set of records - the actual data. Every Database must have at least 1 table.
Record	A set of fields, such as all the information on a particular customer in a table.
Field	Part of a record, a basic fact - the smallest unit of the database table
DBMS	Database Management System - Software for managing a database
Record Description	List of Fields in a record, with descriptive information (Example: Employee Record Description)
DataSheet View	Grid showing all the records
Key	for unique access to records; eliminates duplicate records
Objects	Left column on database window(tables,queries,forms,reports,pages,macros,modules)
Record Selector	Pencil, Asterisk to left of record

• Database window - displays the various objects in the access database
• Tables - store data, one record at a time. Sort in different ways.
• Query(/ find/ filter) - can locate specific records
• Forms - attractive screens that let you enter (input) data
• Reports - create reports for output of data in different formats and sorted by different fields
• Relational Database - Can have more than one table, and relationships between tables
• Views - Design view lets you design a table(field names); Datasheet view lets you enter records.

• Datasheet view lets you see the records, which are divide into fields
• Design View lets you decide what data you'll store in the records
• The Record is defined by listing fields and field types, such as Name and address (text fields)
• Field Types: Text, Memo, Number, Date/Time, Currency, AutoNumber, Yes/No, OLE Object, Hyperlink, Lookup, or Wizard)

• Open MS Access - then Office Button - Open - C:\EXPLORING ACCESS \ BOOKSTORE - Notice Shutter Bar (Navigation Pane) on left.
• Maximize the Window. Click on TABLES. Double click on the BOOKS table.
• Click on any record to move to that record. Move around using the TAB key or the arrow keys.
• Note the record number indicated at the bottom of the Window.
• Note the asterisk (*) at the bottom of the data; the pencil if you edit a record.

• Make sure the appropriate table is displayed. Scroll to the bottom.
• Enter 1 record: 0-13011-190-0, Exploring MS Office 2000, Grauer/Barber, 1999, $45, Prentice Hall
• Enter a 2nd record: 0-07054-058-9, Ace the Tech. Interview, Rothstein, 1998, 24.95, McGraw Hill

• Edit Record 2, price should be $16.25. Delete Record 18, "A Guide to SQL". Sort records.
• Finding records with certain content, such as "Parker". Or Find and Replace
• Using Filters (Filter by Selection, Apply/Remove Filter, Advanced Filter.
• Data Validation means anticipating and preventing errors (Prentice Hall and Prentice-Hall); GIGO