#2. There was a Powerpoint question - you were setting up a kiosk for a foreign airport. You want to allow users to select their language and destination and view a slideshow based on this information. How do you implement the user interface?
#3. There were many design scenarios that asked: Here are the goals, here is what you do, which of the goals have you accomplished? One that I recall well was:
You are writing an Excel 2000 app that includes text boxes and drop-down lists. You want to add user assistance to the application.
Proposed solution:
- Install HTML help - Create Tool Tips - Create a Status Bar
Which of the following goals does the proposed solution produce? (choose all that apply)
#4. Generally speaking, the view window/watch window/debugging questions are softballs for anyone who has taken VB desktop/distributed. One specific one I can recall:
You have written a warehouse management app using Access 2000. Warehouse personnel interact with this application using remote control radio devices. The radio devices communicate with a receiver connected to the serial port of the computer running the Access 2000 application. You want to view the data that is sent from the serial port to your Access 2000 app, but do not want to interrupt the data transfer.
Which of the following debugging tools should you use?
#5. There was a design scenario where, basically, you had 10 telemarketers who were doing a boatload of transactions. If the project is successful, they might expand to 100 telemarketers. Which database should you use? (choose two)
#6. You've created a design for a consulting company that allows users to track project time. Each client gets a unique ID, each project a unique project id. The client data comes from a proprietary ODBC database that is read-only. You will create a separate MSDE database to store project time data. Some users will use Excel 2000 to enter data. Consultants in the field must enter data using their browser. There will be about 20 users making a relatively small number of entries daily.
Your solution:
- Setup an MSDE database and create views and stored procs for data entry - create a COM add-in that uses ADO to access both the MSDE database and the ODBC database - implement permissions in MSDE on the views and stored procs - create an Excel UserForm to allow data entry - Copy the Com add-in DLL and Excel macro to a network share for installation - Write ASP script to use ADO to access both databases
Which of the following goals does this accomplish? (choose all that apply)
#8. You are developing a process to install MSDE on each computer in your office. The MSDE database will be used with Access 2000. You do:
- use the PDW to create a package with the .mdf file and a .dep - use PDW to run the MSDE install batch file after initial installation is complete - modify Setup1.vbp so that MSDE is started automatically using SQL-DMO - modify Setup1.vbp so that the AttachDB method is used to load the .mdf file into MSDE - compile Setup1.vbp and place all of the relevant files on the compact disc
Which of the following goals does this accomplish? (choose all that apply)