Chapter 12 Lecture Notes

Access – The Relational Database

Mrs. Miñoso

• What is a Database?
• Records vs Entries
• Primary Key
• Design View
• Field Name
• Field Type
• Field Size
• Field Formats
• Datasheet View
• Changing Column Width
• Record Selector
• Deleting a Record
• Forms
• Using the Wizard
• Record Controls
• Query
• Filter by Form
• Criteria
• Saving a Filter
• Using And & OR
• Reports