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,
0%
Database Applications (Part 1)
Compartir
Compartir
Compartir
per en/la
Atennyson556
CCEA GCSE Digital Tech Software
Editar continguts
Imprimir
Incrustar
Més
Assignacions
Tauler de classificació
Mostrar-ne més
Mostrar-ne menys
Aquesta taula de classificació és privada actualment. Fés clic a
Compartir
per fer-la públic.
El propietari del recurs ha inhabilitat aquesta taula de classificació.
Aquesta taula de classificació està inhabilitada perquè que les teves opcions són diferents a les del propietari del recurs.
Reverteix les opcions
Emparellar
és una plantilla de final obert. No genera puntuacions per a una taula de classificació.
Cal iniciar la sessió
Estil visual
Tipus de lletra
Subscripció obligatòria
Opcions
Canvia de fonament
Mostrar-ho tot
Apareixeran més formats a mesura que jugueu a l'activitat.
Resultats oberts
Copiar enllaç
Codi QR
Suprimir
Restaurar desada automàtica:
?
