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

S3 Administration - Microsoft Access

More Quizzes