Databases make data, easy to store, organise and search, A database is a, collection of data organised, You can think of a database like an, electronic filing system, A database will exist even when, the power is off or the system has a failure, Data is organised into a, table structure, A table consists of, a number of records, A table is sometimes referred to as, a flat file, A record is represented as, a row in a table, A field is part of, a record, A field stores, a single data item, represented by a column, A key field uniquely, identifies one record, A query, searches and filters data in a database, A query is used to find, an answer to a question, A database allows you to, interact, extract and present information that is required, The key field is also known as, the primary key, An example of a key field would be, a customer ID, To create a query, criteria are added to one or more fields in the table, A form is used to, enter a new record, modify an existing record and view records already stored in the table, A form is a user-friendly interface that, hides complexity from the end user, A form is a common way to, collect data from people, When data is added to a form, it is automatically added to the specified table, Forms can be customised to include, a logo and colour, A report allows tables and results from queries, to be presented in a user-friendly way, A macro is, a small program written to perform a repetitive task automatically, Macros add, functionality to forms and reports, Using a macro means, the user can click on one button, instead of entering multiple instructions, You can link two tables together in a database, by using a relationship, To create a database relationship, there must be, a common field, Relationships can be classified as, ONE to ONE, ONE to MANY or MANY to MANY, A non-key field is known as, a foreign key.

Database Applications (Part 1)

by
Print
Embed

Leaderboard

Visual style

Options

Switch template

Continue editing: ?