S3 Administration - Microsoft Access

What is the 'table' used for in MS Access?
Storing all of the records/information
Searching the database
Presenting the data in a user-friendly way
Sorting the database
What data type shoud a telephone number be stored as?
Number
Short Text
Yes/No
Date/time
If you were entering data for a Field called 'Surname', which data type would you expect this field to be?
Date/time
Number
Currency
Short text
What is a Form?
A report
A tool which allows you to enter information into a table
A database table function
A printing function
What is the best way to create a Form in MS Access?
Using the form wizard
Designing myself in 'design view'
No need to create, they are already saved for me/us to use
Going to the 'create' ribbon and hitting the 'form' button
Which 'view' do you need to access in order to enter a header or footer to your Form or Report?
Page layout
Design view
Print layout
Datasheet view
'Lookup Wizard' is a useful datatype because...
It allows you to set multiple choice answers so helps standardise the responses for a particular field
It can search the database for the information you need
It creates a report in MS Access
It identifies the correct data type for the field automatically
If you are required to print only one record from a form, which option should you select within the print options?
Landscape
Selected records
All
Pages
Which 'view' should you use to amend the field names or data types?
Print view
Layout view
Datasheet view
Design view
The best way to print a database table is to...
Export it to word so that you can add your name in the footer and make sure all the rows and fields are visible on the printout
Go to file, and then print
Create a report and print that
Ask your IT teacher to do it for you
{"name":"S3 Administration - Microsoft Access", "url":"https://www.quiz-maker.com/QPREVIEW","txt":"What is the 'table' used for in MS Access?, What data type shoud a telephone number be stored as?, If you were entering data for a Field called 'Surname', which data type would you expect this field to be?","img":"https://www.quiz-maker.com/3012/images/ogquiz.png"}
Powered by: Quiz Maker