What is the main purpose of a database?, To store and manage large amounts of data, To create documents, To send emails, To analyse images, What is a table used for in a database?, To store data in rows and columns, To search for data, To print information, To link databases, What is a record?, All the information about one item, A single field, A table name, A data type, What is a field?, A category of data, A complete record, A database object, A validation rule, Why is a primary key used?, To uniquely identify each record, To sort data alphabetically, To link queries, To format tables, Which field would be best as a primary key?, A unique ID number, A surname, A postcode, A phone number, Which data type is most suitable for a phone number?, Text, Number, Currency, Yes/No, Why should a phone number not be stored as a number?, It may start with 0 or include spaces, It cannot be validated, It takes up more space, It cannot be printed, Which data type should be used for a postcode?, Text, Number, Currency, Date/Time, Which data type would be best for a price?, Currency, Text, Number, Date/Time, Why are forms used in databases?, To make data entry easier, To store data permanently, To search records, To calculate totals, Which database object is used to search for specific information?, Query, Table, Form, Report, What does a query allow the user to do?, Retrieve selected records only, Add new fields, Change data types, Format tables, Which object is best used for printing database information?, Report, Table, Query, Form, Why are reports used instead of tables for printing?, They present data clearly and professionally, They store data, They allow editing, They create relationships, Which view allows you to change the structure of a table?, Design View, Form View, Datasheet View, Print Preview, Which view allows you to enter and view data in a form?, Form View, Design View, Layout View, Print Preview, What is a relational database?, A database with linked tables, A database with one table, A printed database, A database without keys, Why are relational databases used?, To reduce duplication of data, To increase storage size, To speed up printing, To simplify layouts, What is used to link two tables together?, A relationship, A form, A report, A validation rule, Which fields are usually linked in a relationship?, Primary key to foreign key, Two text fields, Two calculated fields, Two reports, Why are relationships important in databases?, They improve accuracy and consistency, They improve spelling, They increase font size, They reduce file size, Why would you print a selected record?, To print one record only, To print all records, To edit the record, To delete data, Which print option should be chosen to print only one form record?, Selected record, All records, Pages, Print preview, What is the purpose of a form header?, To display titles or logos, To enter data, To store records, To validate fields, What is the purpose of a form footer?, To add names, dates or totals, To store data, To search records, To add fields, Why is a page footer added to a form or report?, To include name and SCN on every page printed out., To enter data, To create relationships, To validate fields.

N5 Admin & IT Access Databases

per en/la
Imprimir
Incrustar

Tauler de classificació

Estil visual

Opcions

Canvia de fonament

Restaurar desada automàtica: ?