OIS 302 - Final Exam Text

OIS 302 - Final Exam Text - Question 1 To require a letter...

Info iconThis preview shows pages 1–5. Sign up to view the full content.

View Full Document Right Arrow Icon
Question 1 To require a letter or digit to be entered into a field, which Input Mask Character would you enter in the Input Mask property box? A & ? L Question 2 Which option in the Import Spreadsheet Wizard enables you to add data to a specific table that appears in a database? In a new table In the current table To a specific table In an existing table Question 3 The AND condition tells Access that each and every criteria set must be met before the data is returned True False Question 4 In VBA, a logic error is syntactically correct but produces the wrong results. True False Question 5 What can Crosstab queries be based on? Tables Queries A combination of tables and queries All of the above Question 6 VBA is an acronym that stands for:
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Visual Basic Access Visual Base Applications Visual Basic for Applications Visual Basic Authorization Question 7 When you are recording a macro, what appears in the Status Bar? Macro On Macro Record Recording Record Now Question 8 In VBA, Two quotation marks ("") can be used to test for the presence of: independent strings empty strings error tapping labels Question 9 How do you separate a formula in a Word table? Save the file Click the formula and press F4 Click the formula and press F9 Click Table/Formula Question 10 You can use the Input Mask Wizard to build a field format for certain fields in a database. True False Question 11 Passwords are generally used to protect: Database reports Database forms Database tables The database
Background image of page 2
Question 12 The Excel feature that lets you store and review different worksheet values is track changes. True False Question 13 Use the size alignment tool to fit a control to the longest entry or along a grid True False Question 14 When you click the Trace Error button, Excel isolates the error by displaying a blue arrow, called a code debugger that uses dots to identify cells used in a formula. True False Question 15 Sentence structure in VBA is called: syntax statement remarks object Question 16 VBA is a subset of: Visual Basic Microsoft Office Microsoft Windows Microsoft Access Question 17 Which of the following is NOT a method by which Word can sort paragraphs? Alphabetically
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
By date Random paragraphs Numerically Question 18 All of the following are types of Action queries, except: Add Delete Append Update Question 19 Input masks are properties that control the appearance and format of data entered into a database. True False Question 20 An action performed in VBA is referred to as a(n): method. property. window. editor. Question 21 Why would you type a password into the Protect Document dialog box? To prevent users from changing the form. To verify all the data entered. To allow the user to press Tab to move from field to field.
Background image of page 4
Image of page 5
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 11/10/2009 for the course OIS 302 taught by Professor Butcher-powell during the Spring '05 term at Bloomsburg.

Page1 / 19

OIS 302 - Final Exam Text - Question 1 To require a letter...

This preview shows document pages 1 - 5. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online