COMPUTERS NOTES

Databases

Databases

A structured collection of related information for organised data management.

Records and Table

• Records are single pieces of data within a database. \n • Neatly organized within tables, consisting of different data categories known as fields. \n • Fields enable efficient data storage and retrieval.

Records

• Records are single pieces of data within a database.

Fields

enables efficient data storage and retrieval.

Quires

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 analyzing 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.

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.

Structure of a database (3)

Field; Record; Table

Short Text

Letters only - EG: Names, etc ( max: 255 characters)

Long text

Comments/Explanations ( >255 characters)

OLE Object

Files created by another object ( EG: Music)

Hyperlink

Web address linked to another doc/ web page

Attachment

Similar to OLE - (difference) accepts more type of data types compared to OLE

Sections (forms)(3)

Form header; Detail; Form footer

Basic elements (4)

Label; Textbox; Line; Image

Ways to create (2)

Form command and Formwizard