DataConsulting’s Coffee Corner – ACL Quiz

2012-06-01

DataConsulting’s Coffee Corner

ACL Quiz

Welcome to June’s edition of DataConsulting’s Coffee Corner. The answer we were looking for in last month’s edition was “DUPLICATES”. Well done to everybody that got the right answer by tracking Robin’s movements around LA!

In this month’s edition we have an ACL quiz. How well do you know your ACL?

Question 1
In which Canadian city is ACL HQ based?

A. QuebecB. VancouverC. SaguenayD. Toronto

Question 2
If you were to play ‘ACL’ in scrabble how many points would you score?

A. 3B. 4C. 5D. 7

Question 3
Which two ACL commands also exist as functions?

A. Duplicates and VerifyB. Total and DuplicatesC. Age and TotalD. Verify and Age

Question 4
Which ACL function returns the name of the day of the week for a specified date?

A. CDOW()B. CTOD()C. CUMIPMT()D. DATE()

Question 5
Which of these items does not appear in the status bar?

A. Global FilterB. Estimated Time of CompletionC. Number of RecordsD. Table Name

Question 6
Up to how many project shortcuts can you have in the welcome screen?

A. 6B. 7C. 8D. As many as you want – the number can be changed in the user settings

Question 7
Which of these project items cannot be copied between projects?

A. ScriptsB. Table LayoutsC. VariablesD. Views

Question 8
Is the Between() function inclusive or exclusive for the supplied parameter values?

A. InclusiveB. Exclusive

Question 9
Name the function being described: ‘Removes leading and trailing blanks from character strings. Does not affect blanks inside the string’

A. TRIM()B. ALLTRIM()C. CLEAN()D. REMOVE()

Question 10
ACL Acerno is an add-on for which application?

A. MS AccessB. MS ExcelC. ACL DesktopD. MS Word

Submit