Computers and Technology, 06.12.2020 03:50 katiepotter

Design and create a form named frmQueries that has the following components and characteristics: a. Set the form's Caption property to Instruction Queries.

b. Add a list box control (approximately 1 inch from the top of the form and 1 inch from the left border of the form) with a Name property value of lstQueryList that displays all the query names contained in the Instruction database, excluding those that start with a "~" character. To place the query names in the list box control, use a SQL SELECT statement to retrieve the query names from the MSysObjects table, and display the queries in reverse alphabetical order (descending order). (Hint: Use the same SQL select query that you used in the module.) Widen the list box control to approximately 2.25 inches.

c. In the attached label control, change the caption to Available Queries, formatted with a 12-point, bold, italic Calibri font, position the label above the list box control, and increase the width of the label control to fit the text.

d. Add two command buttons below the list box control. The left command button should display the Preview icon below the word Preview, and the right command button should display the MS Access Query icon below the word Display.

e. Create a macro for the form that moves the focus to the first query name in the list box control when the form loads.

f. Create a macro that causes the query datasheet to display the selected query, and then configure the form so the macro runs when a user double-clicks a query name in the list box.

g. Create a macro that causes the query datasheet to display the selected query, and then configure the form so the macro runs when a user selects a query name in the list box and clicks the right command button (the Display button).

h. Create a macro for the left command button (Preview button) that opens the selected query in Print Preview.

i. Set the background color of the Detail section to Light Blue 3 in the Standard Colors section. Set the background color of the list box and the two command buttons to Light Blue 2.

j. Disable the form's shortcut menu, record selectors, and navigation buttons, but do not disable the Close button.

k. Test the form.

Answers: 3

Show answers

Another question on Computers and Technology

Computers and Technology, 21.06.2019 19:30

Can you make money in why are you guys so

Answers: 1

Answer

Computers and Technology, 22.06.2019 14:10

Dean wants a quick way to look up staff members by their staff id. in cell q3, nest the existing vlookup function in an iferror function. if the vlookup function returns an error result, the text “invalid staff id” should be displayed by the formula. (hint: you can test that this formula is working by changing the value in cell q2 to 0, but remember to set the value of cell q2 back to 1036 when the testing is complete.)

Answers: 3

Answer

Computers and Technology, 22.06.2019 20:30

In this lab, you complete a prewritten c program that calculates an employee’s productivity bonus and prints the employee’s name and bonus. bonuses are calculated based on an employee’s productivity score as shown below. a productivity score is calculated by first dividing an employee’s transactions dollar value by the number of transactions and then dividing the result by the number of shifts worked.

Answers: 3

Answer

Computers and Technology, 23.06.2019 01:40

You have a linux system that has a 1000gb hard disk drive, which has a 90gb partition containing an ext4 filesystem mounted to the / directory and a 4gb swap partition. currently, this linux system is only used by a few users for storing small files; however, the department manager wants to upgrade this system and use it to run a database application that will be used by 100 users. the database application and the associated data will take up over 200gb of hard disk space. in addition, these 100 users will store their personal files on the hard disk of the system. each user must have a maximum of 5gb of storage space. the department manager has made it very clear that this system must not exhibit any downtime as a result of hard disk errors. how much hard disk space will you require, and what partitions would you need to ensure that the system will perform as needed? where would these partitions be mounted? what quotas would you implement? what commands would you need to run and what entries to /etc/fstab would you need to create? justify your answers.

Answers: 3

Answer

You know the right answer?

Design and create a form named frmQueries that has the following components and characteristics: a....

Questions