Database Design using Access $2010$

Queries and Reports

Write a query that:

$1-$ Gives you the late charge date, late charge movie, movie title, late charge

amount, status of late charge payment and late charge customer number.

$2-$ Gives you: Names of employees and their ID numbers.

$3-$ Gives you: Trx details no$,$ movie number, title, days rented, price, quantity and

availability.

$4-$ Provides a prompt to ask about all people with a particular first name.

$5-$ Concatenates the first and last name in one field with a space between them.

$6-$ Provides the status of each movie in the store and whether it is returned or

available.

$7-$ Calculates total price for movie quantity and price for movie.

Build a report that:

$1-$ Calculates total price for movie quantity and price for movie.

$2-$ Concatenates the first and last name in one field with a space between

them.

Remember always:

$$ To add$/$subtract$/$multiple fields or concatenate use A:$[$B$]+[$C$]$ as new fielld

$$ To put a space use $$ in the new field

$$ To create a query for a field with a prompt use like $*$ & $[$your text$]$ & $*$

or $[$your text$]$ only for unique situations.