BTEC L3 IT U2 tricky topics

How do you add a "parameter" to a query which will show a message to the user and use the input for the query?

• [Parameter Text]

• {Parameter Text}

• (Parameter text)

• Access does not support parameters

My database has a form called "frmInput". How do I access the value in the combobox "cmbSelection" on this form from a query?

• frmInput.cmbSelection.value

• [Forms].[frmInput].[cmbSelect]

• This cannot be done

• [Forms]![frmInput]![cmbSelect]

What does a "domain aggregate" function do?

• Runs a query automatically

• Improves the layout of a form

• Gets values from a range of data

• Validates data

Match the domain aggregate functions to the correct description

• Total of all matching values in a domain

• DLookup

• Minumum value within a domain

• DSum

• Count of values in a domain

• DAvg

• Average of values returned from a domain

• DCount

• Gets a specific value from a domain

• DMin

Which command is used in a macro to get a control to get new data from it's data source?

• Requery

• Refresh

• SaveRecord

• FindRecord

What is a foreign key?

• Uniquely identifies the records in a table

• An attribute that is a primary key in another table

• A record that meets 3rd normal form

• A primary key made up from two or more attributes

What is the result of this query

• A field called "The Value" containing 5% of the total cost for all rows

• A field called "The Value" containing 5% of the total cost for each row

• A field called "sum([Cost])" containing 5% of the total cost for all rows

• An error

Here is some data. What is the best way to normalise it?

• Have a table for lenders and a table for books

• Put everything into a single table

• Have a table for Lenders and a table for Books, then add a table Lender/Book with a primary key made from primary keys in the other tables

• Put every attribute into its own table