CSC 166 - Database Software

• Please check the grades link below.



• Syllabus - link to syllabus
• Final Grades



Some random questions from the final exam, and the correct answers:

“Fields of a composite primary key must be adjacent to each other.” Answer: False

“The default comparison operator in a selection criteria, if not specified, is the Like operator.” Answer: False. The default comparison operator is “=” (equals).

“Handles on a control in design mode, allow the designer to change the font size of the control.” Answer: False. The handles change the text box size, but not the font size of the data inside.

“A Click event occurs when a user tabs from one field on a form to another field on a form.” Answer: False. A Click event is when a user uses a mouse to click in the field or on the control. A tab would cause a Got Focus event to occur, or an Enter event to occur.

“An 'On Exit' event for a field occurs when the form is closed.” Answer: False. The Exit event occurs just before a control loses the focus to another control on the same form. The Close event occurs when the form is closed.

“An If Statement in Visual Basic executes upon the triggering of an event procedure.” Answer: False. It is true that an event procedure can execute Visual Basic code, which you the programmer put into the VB code screen. It is true that If Statements can be one of the statements you might build as Visual Basic code. However, an If Statement is a conditional VB statement, meaning, it will only execute if the condition tests as True, or the Else side of the If Statement will execute if the condition tests as False. But it doesn't trigger because it is an event, it only executes as a result of a conditional test. Additionally, if an If Statement is placed into a Function, it isn't triggered as an event procedure, but is part of VB code within the Function which could be called from various places in the whole application.

“If you disable Menus and the Database Window in the Access Startup features, you can bypass the startup options when opening the database by going to View, Toolbars, Database.” Answer: False. In class, we reviewed a method to bypass the startup options. That method is on page AC 619… pressing and holding down the Shift key.

“A database saved as a MDE file can be converted back to a full version displaying all Visual Basic code. Answer: False. It can not be converted back.