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, 22.06.2019 12:00

The following function returns a string of length n whose characters are all 'x'. give the order of growth (as a function of n) of the running time. recall that concatenating two strings in java takes time proportional to the sum of their lengths. public static string f(int n) { if (n == 0) return ""; if (n == 1) return "x"; return f(n/2) + f(n - n/2); } options: a) constant b) logarithmic c) linear d) linearithmic e)quadratic f)cubic g) exponential

Answers: 2

Answer

Computers and Technology, 22.06.2019 20:00

Need asap write a short paper describing the history and differences between six sigma, waterfall, agile, and scrum models. understanding these models can give you a good idea of how diverse and interesting it development projects can be. describe what the rationale for them is and describe their key features. describe the history behind their development. at least 400 words

Answers: 1

Answer

Computers and Technology, 23.06.2019 12:00

If you're using an existing powerpoint presentation that will receive new slides based on a word outline, select the a. slide that will appear after the new slides. b. first slide in the presentation. c. slide that will appear before the new slides. d. last slide in the presentation.

Answers: 2

Answer

Computers and Technology, 24.06.2019 07:30

John recently worked on a project about various programming languages. he learned that though procedural language programs are useful, they have disadvantages too. what is a disadvantage of programs written in procedural languages? a. programs do not represent data complexity. b. programs take more time to execute. c. programs are prone to security threats. d. programs do not interface with multiple platforms.

Answers: 3

Answer

You know the right answer?

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

Questions