Reference no: EM131197069
Database Design Continued
Use the attached database to complete the following assignment:
You will be modifying the frmMainMenu to call the caption of each button from the table MainMenu and form or the report.
1) Create a table MainMenu with at least 3 fields: ID, caption, and form or report to run
2) Your code (for the button) will dynamically read the caption from the table and assign it to the button
HINT: Variables (table name) in other areas of the code should not be "hard-coded". If for example a Table name changes in the database it should be reflected in the menu. I do not need to go into the code and look for all entries for the hard-coded name of the table. Dynamic caption means should the name of any table change - the caption on the button for that table must change as well. Test it out ...
3) Your code (for the button) will dynamically read the form/report name and will run when you press the button.
HINT: Like the hint for #2 above do the same for the reports. No names should be hard-coded. This prevents errors in the long run which often break a program, and maintenance does not become a nightmare!! This approach is a widely utilized practice amongst professional developers in support of friendly user experience enhancements! Our users want to be able to press buttons that are logical, practical, and smart.
Attachment:- Database.accdb
|
What is structured query language
: What is Structured Query Language (SQL)? First lets define SQL. Knowing the background is a good way to start. Then move on to understanding if we need SQL in Access. Let's talk about SQL's future.
|
|
Why are reliability and validity important in human resource
: Write a 3-5 page paper, with a minimum of two references, in APA format addressing the following: Why are reliability and validity important in human resource selection? Provide an example of each.
|
|
Mass anddistance under constant acceleration
: An aircraft weighing 801 N is accelerated at 13 m/s/s for 15 seconds, at which time the aircraft launches. How much work was done on the aircraft? The acceleration is constant.
|
|
Energy of the aircraft when the aircraft launches
: An aircraft with a weight of 8473 N accelerates from 0 to 94 m/s in 8.2 seconds, at which time the aircraft launches. What is the kinetic energy of the aircraft when the aircraft launches?
|
|
Create a table mainmenu with at least three fields
: Create a table MainMenu with at least 3 fields: ID, caption, and form or report to run. Your code (for the button) will dynamically read the caption from the table and assign it to the button
|
|
Are the prospective employees being told the truth
: A random sample of 40 engineers in the firm showed that, for a particular week, they averaged 44 hours of work with a standard deviation of 3 hours. Are the prospective employees being told the truth?
|
|
Catapult on an aircraft carrier
: The catapult on an aircraft carrier can take an aircraft from 0 to 209 mph in 7 seconds, at which timethe aircraft launches. Express the launch speed in SI units (meter-kilogram-second (MKS) system - not km/hr).
|
|
How would you define your group at work
: How would you define your group at work - Do you think group members in your group had influence over other members? Why or why not?
|
|
Do the scientific articles need to be presented
: Are there ways to fix this divide? Do the scientific articles need to be presented in a manner (i.e., writing) that is accessible by the general public? Do the media writers need to be more tedious in their research for an article
|