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)

Skriv ut
Innebygd

Ledertavle

Visuell stil

Alternativer

Bytt mal

Gjenopprett automatisk lagring: ?