ICT YEAR 8 SECOND TERM FIRST TEST

What is Microsoft Access primarily used for?

• Creating presentations

• Database management

• Graphic design

• Web development

Which tab do you click to create a new database in Access?

• Home

• Create

• View

• File

What is the first step in creating a new table?

• Add fields

• Click the Create tab

• Select a template

• Import data

What type of data can be stored in a field?

• Only dates

• Various types depending on the data type

• Only numbers

• Only text

What is the purpose of a primary key in a table?

• To store images

• To uniquely identify each record

• To create reports

• To link to other tables

Which option allows you to import data from an Excel file?

• From Online Services

• From File

• From Other Sources

• From Database

What is a query used for in Access?

• To generate reports

• To design forms

• To retrieve and filter data

• To create tables

What does the 'Enforce Referential Integrity' option do?

• It creates new tables

• It imports data

• It deletes records

• It keeps data consistent across tables

What is the purpose of a report in Access?

• To store data

• To analyze and display data

• To create forms

• To import data

What is the first step to create a select query?

• Click the Create tab and select Query Wizard

• Open the Query Design tool

• Add fields to the query

• Run the query