Test&Track

Don't have an account? Sign up

Google

Sorry, this content is only available to premium members

Sign up

Please tick the below box to proceed

I agree (or if I am under 13 my parent or guardian agrees on my behalf) to the terms and conditions of use and that:
- My test statistics may be published on the site leaderboard against my username
- My teacher(s) can review my test scores
- I can receive feedback on my tests from my teacher(s)

Please tick this box to proceed

Already have an account? Sign in

1. A form is a database object that you can use to ________________________________________________.

enter, edit or display data from a table or query

create tables with in a report-type manner

query or create reports with

save and store records without going through or via a database table at all

2. Which of the following are benefits of using forms when creating a database?

1. Makes a database more user-friendly for ordinary (non technical) users. 

2. A good form can be visually appealing and make working with the database
more pleasant as well as more efficient

3. Data can be entered directly into a table, but the larger the database and table,
the harder it would be to ensure the right data is entered into the right field and record.
An effective form lays things out in just the right manner so that information is both
easy to find and data entry is also helped into being more accurate.

2 and 3 only

1 Only

1, 2 and 3 (all options)

2 Only

3. Sections of a form can be resized. Refer to the image shown and fill in the blanks.

script

footer

header

body

4. Referring to the image below, what do you do with the fields on the right?

Delete all the fields so that the form is empty on start-up

Drag the desired fields into the icon (at the top) which says 'Form'. The field list can then be deleted.

Drag the desired fields from the Field List onto the form on the left

Drag the desired fields into the right order on the right and then left cilck and 'delete'

5. ________ are an important part of forms - they are the objects that display data, perform actions, and let you work with information.

_______ provide tools and functionality that make forms user-friendly and easy to use.

bolt-ons

cells

controls

buttons

6. The highlighted icon allows the user to add a label (for a title or header) onto the form.

7. The Access Form ______is a useful, rapid form development tool, speeding you through the process, providing you with presets for columns, rows, table sizes, styles and themes.

wizard

tester

form-scripter

macro

8. The ______________ is a useful sidebar, found in the Form Layout Tools tab: It contains useful information about your Form and you can use it to quickly edit, modify and toggle numerous options.

form toolbuilder

properties sheet

form wizard

data inbox

9. A well designed form can aide efficiency and improve data entry accuracy,

10. Access allows you to hide individual field entries. Select the field you want to hide. When you select the field, the properties sheet should update and you’ll be able to _____________ through a drop-down box.

Preview

05 - Working with Forms