1. What properties must be set and what must they be set to so that the request form isn't displayed for a particular table in a report? ans
2. List the steps to set up a lookup so that it shows filtered items based on a selection in another field? ans
3. What key combination brings up the C/AL Symbol Menu when you are in the C/AL Editor?ans
4. What key combination will "Post and Print?ans
5. What key combination goes to the next window?ans
6. What key combination closes the window?ans
7. What are the table field properties that are set to format amounts into different currencies?ans
8. What table field property can be used on integer fields so that a new number is automatically placed in the field every time?ans
9. What table field setting prevents a field from being displayed even through the show column dialog?ans
10. True or False. If the TableRelation field is set for a field to tableA and the record in tableA is renamed, the renaming will be reflected in the field that has the TableRelation property set.ans
11. What is the output of this message statement?ans
MESSAGE('%1',TRUE);
12. What happens when you type in the statement myText :='This is too much'
where myText is a Text variable of length 4?ans
13. Can you assign -10 to an option variable?ans
14. How many dimensions can Array variables have?ans
15. What property can you set on a form to get it to automatically enter parts of the key?ans
16. Are all forms bound?ans
17. Which property must you set on a Command button for the RunObject property to work?ans
18. What control lets you show more than one record at a time?ans
19. What are the two inital triggers in a codeunit?ans
20. Can the with statement be used with codeunits?ans
21. What are the date expressions for days and weeks? Also how are weekdays numbered?ans
22. What are the date expressions that are associated with the financial calendar and the ordinary calendar that you didn't specify in 21?ans
23. What are the results of the following?ans
MESSAGE('%1',CALCDATE('+M2',033106D));
MESSAGE('%1',CALCDATE('+2M',033106D));
MESSAGE('%1',CALCDATE('+1M',033106D));
24. What is the result of the following?ans
MESSAGE('%1',ROUND(2.05,1));
25. Table Types! What are the table types for the following?ans
1) Customer, Vendor
2) Sales Header/Sales Line
3) Item Vendor
4) Item Ledger Entry
26. More Table Types! What are the table types for the following?ans
1) Purchase Journal
2) Sales Invoice Header/Sales Invoice Line
3) G/L Register
4) Currency
5) G/L Setup
27. What are the complex Data Types?ans
28. What form property links the form to it's table?ans
29. How do you make a function parameter so that it is passed by reference?ans
30. You have slow code in your report that produces the pictured dialog. What line can you add as the first statement to make to code run much faster so that the dialog does not appear?ans
Slow Code:
ItemLedgerEntry3.SETRANGE("Item No.", TopNo[Number]);
ItemLedgerEntry3.SETRANGE("Entry Type", ItemLedgerEntry3."Entry Type"::Sale);
Usage04 := 0.0;
ItemLedgerEntry3.SETFILTER("Posting Date",
FORMAT(CALCDATE('-2Y',FromDate)) + '..' + FORMAT(CALCDATE('-2Y',ToDate)));
IF ItemLedgerEntry3.FIND('-') THEN REPEAT
Usage04 := Usage04 - ItemLedgerEntry3.Quantity
UNTIL ItemLedgerEntry3.NEXT = 0;
The Dialog: 
31. What key combination gets you list view?ans
32. What key combination gets you card view?ans
33. What key combination Ledger Entries?ans
34. What key combination gets you dimensions?ans
35. What key combination gets you statistics?ans
36. There is a codeunit variable blah that has a function yada. How do I run yada without putting the "blah." in front of it?ans
37. I have record variables RecItem1 and RecItem2 that are both of subtype "Item". Can I check whether they are on the same record with the following code?ans
if RecItem1 = RecItem2 then
Message('They are the same');
38. I have the following variables that are not complex types: blah, a, b, c. I have the following functions that take no parameters: yada, bonus, whodo. How do I write a case statement so that if blah is a or b I run yada, if blah is c I run bonus and if it doesn't match any of them it runs whodo?ans
39. What does this give you MESSAGE('Pos: %1',STRPOS('Z','buzz'));?ans
40. I have Record variables rec1 and rec2 of subtype "Item". What does this do?ans
rec1 := rec2;
rec1.GET('80100');
rec2.GET('80027');
MESSAGE('=>%1',rec1."No.");
41. I have Record variables rec1 and rec2 of subtype "Item". What does this do?ans
rec1.GET('80100');
rec2.GET('80027');
rec1 := rec2;
MESSAGE('=>%1',rec1."No.");
42. I have Codeunit variables cu1 and cu2 of subtype "testin" with SingleInstance set to "No". What does this do?ans
cu1 := cu2;
cu1.setBonus(1);
cu2.setBonus(20);
MESSAGE('Bonus: %1',cu1.getBonus);
43. What effect does a non-key field have in the GroupTotalFields property of a report?ans
44. What does
message('=' + format(4,5) + '='); return?ans
45. What does message('=' + format('4',5) + '='); return?ans
46. What is the calcfields TagName property supposed to be used for in XMLPorts?ans
47. How can the data item tab be removed from the request form for a dataport when the FileName variable is unset?ans
48. Which tab of the ODBC Administrator should you add a DSN to so that it can be used by all users of the machine?ans
49. What are the cases when the NODBC driver will work without client software installed?ans
50. Where does C/FRONT look for license files?ans
51. What files does C/FRONT need from the Navision client directory?ans
52. Is any of the code in the validation triggers going to be run when you use NODBC or C/FRONT?ans
53. Can visual OCX controls be used in Navision?ans
54. Where can you check whether your OCX is installed?ans
55. Are there any COM datatypes for which Navision has no corresponding type?ans
56. What property do you set on your Automation type variable so that you receive events?ans
57. Do XMLPorts have triggers?ans
58. Question?ans
59. Question?ans
60. Question?ans
61. Question?ans
62. Question?ans
63. Question?ans
64. Question?ans
65. Question?ans
66. Question?ans
67. Question?ans
68. Question?ans
69. Question?ans
70. Question?ans
71. Question?ans
72. Question?ans
73. Question?ans
74. Question?ans
75. Question?ans
76. Question?ans
77. Question?ans
78. Question?ans
79. Question?ans
Brought to you by Joe Bradshaw ask me about Microsoft Dynamics NAV.
