Access | Computer Science homework help


V475/I519 Ordinance 10  
(30 points)

Conditional Macros, DLOOKUP, & Binding Values:

Download MoviesDB_with_Awards.accdb from Canvas. This is the Movies Database we keep been using qualified to understand Award and Movie_Award considerations. 

You accomplish fashion three sub-menu makes in this ordinance that accomplish be accessed from a Main Menu.  Section 2 contains an non-interference for premium points. 


1. Fashion a make that rates a Star’s productivity

2. Allow user to chosen a Ruler and product a catalogue of Stars who keep been directed by that ruler

3. Let’s see what you can do--Using the Awards postulates granted, you accomplish fashion your own make wless the user chosens celebrity and displays a conclusion. 

Methods Involved:

· Conditional Macros and “Set Value” action

· DLOOKUP function

· Manage pathname (e.g. forms!specific_form_name!control_name_on_form)

· Combo-Box (drop-down catalogue on a Form) and “binding” a appraise 

· Autoexec macro that notoriouss the Main Menu when Access starts

Create a unadorned Main Menu that notoriouss when Access starts and concatenates to all sub-menus. 

1. Fashion a make named Star_Productivity_frm. In this make, you accomplish chosen a Movie Star and particularize whether that Star had a fertile race or not.
Your make capacity appear love this:


Permake the subjoined steps:

Create a inquiry that COUNTs the estimate of movies the Stars keep starred in. The conclusions of this may be two columns: Starnum and MovieCount. Name the inquiry “movstar_count_qry.”

Start delay a bleak make, add a Combo-Box . Secure its commencement to the Star consideration (semblance Starname, but secure the combo-box to Starnum).

Add a textbox manage direct to the make; flatter it “Productivity”.

Program a macro named Productivity_Rating. When the user picks a Starname from the combo-box , the macro accomplish accomplished (chosen After Update adventure). The Macro accomplish keep two actions:
(1) (using DLOOKUP delay IF declaration) use the movstar_count_qry inquiry that has the COUNT of the estimate of movies the chosen Star has starred in.
(2) set the appraise of the “Productivity” manage as follows (close than 3= “Not Very Productive”, BETWEEN 3 and 6= “Moderately Productive”, and greater than 6=”Very fertile”)

Close the movstar_count inquiry window. Name the make “Star_Productivity_frm”  and be trusting to proof.  

2. Fashion a make named Director_Star_frm. In this application, you accomplish chosen a Ruler and product a catalogue of Stars who keep been directed by this Director.

On a bleak make, add a Combo-Box.  Bind its commencement to the Ruler consideration (semblance DIRNAME, but secure the combo-box to DIRNUM).

Create a inquiry named “Director_Star_qry” using manage pathname in the inquiry criteria that points to the combo-box you fashiond overhead. This inquiry accomplish keep two columns: Dirnum and Starname. Note: Use DISTINCT behind the SELECT declaration to transport facsimile conclusions. {ie., SELECT DISTINCT …}

Place a Click-Button direct to the Combo-box. When the trifle is clicked, a inquiry is to run that accomplish product a catalogue of all STARNAMES that the chosened ruler has directed. Use a macro to notorious the inquiry conclusions in postulatessheet judgment. Name the make “Director_Star_frm.”

Your make capacity appear love:


3. Let’s see what you can do…Using the Awards postulates granted in this perfect, fashion a make that displays Awards in any makeat and process of your choosing.  You should use some of the processs you keep versed in the A & Ps and delay this ordinance to accomplished this business to accept liberal belief. Be fanciful in ways you capacity semblance awards notification. 

BONUS POINTS Option: For Premium Points, instead of using a trifle, add a sub-make to this make that displays the Stars who were directed by that Director. Your output could appear love this:

Don’t disquiet encircling auto freshen less. I keep not been efficient to get this to fruit in Access. Instead, you can fashion a trifle that does the Refresh, but the user must compel that. You accomplish deficiency to add the engagement “Refresh” to a VBA script:
Ask me if you are not trusting.


Be trusting all of your trifles fruit from the Main Menu that concatenate to the three sub-menus that you fashiond. Add trifles on all your sub-menus that concatenate tail to the Main Menu. Your Main Menu should notorious when Access starts. (Reminder: fashion an autoexec macro)

Submit the accomplishedd ACCESS postulatesbase on Canvas delay this Assignment. 

Order a unique copy of this paper
(550 words)

Approximate price: $22

Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
The price is based on these factors:
Academic level
Number of pages