COMPUTERS NOTES

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

Controls and Data Validation:
• Controls enhance form functionality for interacting with data.
• Data validation rules ensure accurate and consistent data entry.

Normalization:
• Organizes data to eliminate redundancy and improve efficiency

Foreign Keys:
• Link tables in a relational database, maintaining relationships and data consistency

Form Wizard:
• Simplifies form creation through predefined templates.

Indexing:
• Creates a data structure for quicker data retrieval.

Blank Databases:
• Provide a foundation for users to design their own database components.

Date/Time Data Type:
• Used to store dates accurately in Microsoft Access.