Databases:

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

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.

Queries: • Allow users to retrieve specific data based on criteria. • Differentiates Access from other applications focused on slides or worksheets.

Forms: • Provide an interface for inputting, viewing, and editing data. • Distinguished from tables, queries, and reports.

Primary Key: • Uniquely identifies each record in a table. • Safeguards data integrity by preventing duplication.

Design View: • Used for understanding the structure of a table. • Defines fields, data types, and relationships, streamlining data management.

Relationships: • Crucial for linking tables to ensure data consistency and accuracy.

Reports: • Present data in a structured and formatted manner. • Aid in summarizing and analysing data.

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.