IS Access Lab In Class Notes

• Microsoft Access 
• Level of Data Base
• Personal Data Base
• Database File Extension for Access 2013
• .accdb
• How to Make A Table
• Switch to Design View
• Name Table
• Label Each Row and Set Each Row Data Type As Short Text
• If a row is specifically a number
• Then set the data type as "number"
• How Do You Make Multiple Rows Primary Keys?
• Hold control and click each row
• Click the primary key button
• Why in the Example are Columns Underlined?
• They are primary keys
• How Do You Make Something Uniquely Identified
• Highlight a row
• Click the Primary Key Button
• How Do You Create a Form For A Table
• Highlight Table
• Click "Form" Under the Create Tab
• How Do You Create Relationships
• Close all tables
• Click Relationships Under Create Tab
• Hold Control and Click all Tables That You Want to Relate
• Click Add
• Close Window
• How To Create a Relationship Between Table Rows
• Drag Rows of the same name into each other
• A window will pop up, that is labeled Edit Relationships
• Check mark 'Enforce Referential Integrity'
• Click Create
• How To Create A Query
• Close all Tables
• Goto Create Tab
• Click Query Design
• Hold Control and Select All Necessary Tables
• Click Add
• Close Window
• Set Each Appropriate Field
• Type the Appropriate Criteria under the Appropriate Field, To Grab Info only on that Criteria
• Microsoft SQLServer 
• Level of Database
• Mid Range Database
• Oracle, IBM DB 2 
• Level of Database
• Enterprise Strength Database System