1 / 15

Queries

Queries. More Practice. Query: TotalProfit. Create a query that uses a calculated field to determine the total profits for each movie. Name the calculated field Profit. Use the following formula for to determine the profit:. Query: Post2004OrHighBudget.

tana
Download Presentation

Queries

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Queries More Practice

  2. Query: TotalProfit Create a query that uses a calculated field to determine the total profits for each movie. Name the calculated field Profit. Use the following formula for to determine the profit:

  3. Query: Post2004OrHighBudget Create a query that will list the Title, ReleaseDate, Budget, Runtime, and Genre of all movies that were filmed after 2004 or had a budget of at least $50,000,000.00 (>=50000000).

  4. Query: GenreAverages Create a query that for each genre calculates the average budget allocated as well as the average gross income.

  5. Query: GenreMovieCount Create a query that for each genre will list the total number of movies in the database.

  6. Query: ActorPlaceOfBirthCount1 & 2 Create a query that for each movie will list the total number of actors from either the USA or the UK.

  7. On-Campus Participation Save your file as: “firstName_lastNameAQ.accdb” Submit through course tools.

  8. Forms A First Look

  9. Forms • Forms provide an easy way to input data • Forms can be relative to one or many tables • When multiple tables are used, we have a form with a subform • Forms can have a variety of different layout styles and layers of grouping

  10. Forms • There are 3 views associated with forms • Form View • Layout View • Design View • In most cases, forms created with the form wizard will need some adjusting

  11. Forms: Example Using the Form Wizard, create a form with a subform. The main form should include only the movie title while the subform should include all of the actor information from the Actors table. Make sure to view the data by MovieTitle and that the subform uses the datasheet layout. Name the main form “Movies” and the subform “ActorsInfo”

  12. Reports A First Look

  13. Reports • Reports make data easy to read • Data for reports can come from both tables and queries • Like forms, reports can have layers of grouping • Reports can also be sorted by several fields • Fields in a report can be summarized (averaged, summed, min, max)

  14. Reports • Have a variety of layout options • Like forms, reports also have several views • Report View • Print Preview • Layout View • Design View • Most reports will require some modifications after creation

  15. Reports: Example • Using the Report Wizard, create a report that will present all of the information for each movie. Make sure to group by the Title and sort in ascending order. Also ensure that a tabular layout is used and that the orientation is landscape.

More Related