COMPUTERS NOTES

  1. Databases:

    A structured collection of related information for organized data management. Goes beyond image collections, serving as a comprehensive data management system.

 2. Records and Tables:
    • Records are single pieces of data within a database.
    • Neatly organized within tables, consisting of different data categories known as fields.
    • Fields enable efficient data storage and retrieval.
 3. Queries:
    • Allow users to retrieve specific data based on criteria.
    • Differentiates Access from other applications focused on slides or worksheets.
 4. Forms:
    • Provide an interface for inputting, viewing, and editing data.
    • Distinguished from tables, queries, and reports.
 5. Primary Key:
    • Uniquely identifies each record in a table.
    • Safeguards data integrity by preventing duplication.
 6. Design View:
    • Used for understanding the structure of a table.
    • Defines fields, data types, and relationships, streamlining data management.
 7. Relationships:
    • Crucial for linking tables to ensure data consistency and accuracy.
 8. Reports:
    • Present data in a structured and formatted manner.
    • Aid in summarizing and analysing data.
 9. SQL (Structured Query Language):
    • Used to manage and manipulate relational databases effectively

  1. Controls and Data Validation:
        • Controls enhance form functionality for interacting with data.
        • Data validation rules ensure accurate and consistent data entry.
  2. Normalization:
        • Organizes data to eliminate redundancy and improve efficiency
  3. Foreign Keys:
        • Link tables in a relational database, maintaining relationships and data consistency
  4. Form Wizard:
        • Simplifies form creation through predefined templates.
  5. Indexing:
        • Creates a data structure for quicker data retrieval.
  6. Blank Databases:
        • Provide a foundation for users to design their own database components.
  7. Date/Time Data Type:
        • Used to store dates accurately in Microsoft Access.