N5 AIT Pre-Question Paper Revision

What is a task you may be asked to do when creating a Database Form?

• A) Altering date format

• B) Adding text to header/footer of a form

• C) Creating labels

• D) Sorting data in a table

What is a method for creating labels?

• Using Labels Wizard

• Using data from 2 tables

• Adding graphics to a form

• Altering currency format

What is one of the criteria used in a query search?

• Adding text to header/footer

• = (equals)

• Creating a report

• Using data from 1 table.

With Database Forms, you could be asked to use fields from 1 table or from 2 tables, but must ensure you do not ______ fields.

• repeat

• insert

• duplicate

• single

Fill in the blank: Reports can be created based on the results of a ______.

• query

• survey

• experiment

• interview

Database label tasks may ask you to add a header or ______ on labels.

• footer

• title

• caption

• note

Fill in the blank: In a query, the criteria >= means Greater Than or ______ To.

• Equals

• Less

• More

• Subtract

To ensure consistency when adding new field names in a database, you should:

• Be consistent with existing field names

• Add fields randomly

• Ignore existing field names

• Use different naming conventions for each field

When adding titles to forms and reports, what should you always use to avoid losing marks for incorrect capitalization?

• Use all capital letters

• Lowercase letters

• Uppercase letters

• No capitalization

The purpose of using borders and shading in a spreadsheet is to:

• Enhance the visual appeal of data and make it stand out

• Increase the computational speed of the spreadsheet

• Reduce the file size of the spreadsheet

• Enable automatic data sorting