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
   10. Controls and Data Validation:     • Controls enhance form functionality for interacting with data.     • Data validation rules ensure accurate and consistent data entry.
   11. Normalization:     • Organizes data to eliminate redundancy and improve efficiency
   12. Foreign Keys:     • Link tables in a relational database, maintaining relationships and data consistency
   13. Form Wizard:     • Simplifies form creation through predefined templates.
   14. Indexing:     • Creates a data structure for quicker data retrieval.
   15. Blank Databases:     • Provide a foundation for users to design their own database components.
   16. Date/Time Data Type:     • Used to store dates accurately in Microsoft Access.