level 3 Unit 2 revision

"RegNo" is a ​ (a)   in table "tblCarSales"

• foreign Key
• superkey
• non-key attribute
• primary key

The relationship between "tblCars" and "tblCarSales" is:

• one-to-many

• one-to-one.

• exclusive.

• symmetrical.

"RegNo" is a ​ (a)   in table "tblCars"

• primary Key
• superkey
• non-key attribute
• foreign key

Which type of validation is this an example of?

• Length Check

• Presence Check

• Value Lookup

• Table Lookup

Which type of validation is this an example of?

• Length Check

• Presence Check

• Value Lookup

• Table Lookup

What will this query return?

• Average days since car received

• Average days to sell a car

• Maximum days to sell a car

• Days since last sale was made

Complete the query.

SalesPerson =​ ​ (a)  

Commission = ​ (b)  

• SalesForename & " " & SalesSurname
• ([Value of cars sold]/100)
• SalesForename + SalesSurname
• SalesForename & SalesSurname
• Value of cars sold
• [value of cars sold]

A query needs to work out how many years a member of staff has been in post. Complete the query:​ (a)  

• (Date()-[StartDate])/365.25
• Date() - [StartDate]
• Date - StartDate
• Date()/365.25

Fill in the blanks:

Command under RunMenuCommand = ​ (a)  

Option under GoToRecord = ​ (b)  

• SaveRecord
• New
• Next
• Fresh
• Edit
• DoSave
• SaveForm
• MoveNext

The form shown works out cars sold and commission. The combo box on the form is called "cmbSalesPerson".

The missing part of the query is ​ ​ (a)  

• [Forms]![frmCommission]![cmbSalesPerson]
• cmbSalesPerson
• Forms![SalesID]
• SalesID
• SalesPerson
• [Forms].[frmCommission].[cmbSalesPerson]