some simple help with access database needed

[lockmac]

Hey. I go to school and do IPM and we are doing access databases at the moment and I am having some troubles with a few questions. I wonder if anyone out their would maybe be able to help me?? Most of the questions relate to a case study we are doing called "Ralphs Roofs" where we just have to create a database that can store a customers information as well as details of their quotes.
These are the questions im having trouble with:

A student wishes to sort the results of a query performed on a table of her CD collection. She wishes to do a primary sort on artist and secondary sort on CD title. Describe how she could construct the query so that the data returned in sorted in the order she requires

Provide an example that shows how either the ?is null? or the ?is not null? query criteria can be used to filter data.

Provide an example of a data structure diagram involving two tables of data that have a one-to-many relationship

Any help on any of these questions would be very greatly appreciated.

Many thanks in advance

 

[brandonbull]

1) in the query builder have the artist field first then have cd title
2)in the criteria area put is null
3)can't show you that. make 2 tables and draw a line from the PK on table1 to the FK on table 2. PK end put a '1' over the line and the FK end put an infinity symbol over the line.

 

[lockmac]

hey thanks alot for the help on that!

Just wondering if theres another questions anybody could possible answer...

1. Draw a sketch of a query design that would provide Ralph with a list of customers and their addresses where the total cost of a project was more than $6000
   With this question, obviously i dont expect anyone to draw anything, just maybe tell me how I would draw it maybe please?

Any help appreciated thanks

 

[Nocturnal]

Do your own homework.

 

[lockmac]

get f.ucked

 

[brandonbull]

Originally posted by: lockmac
hey thanks alot for the help on that!

Just wondering if theres another questions anybody could possible answer...

1. Draw a sketch of a query design that would provide Ralph with a list of customers and their addresses where the total cost of a project was more than $6000
   With this question, obviously i dont expect anyone to draw anything, just maybe tell me how I would draw it maybe please?

Any help appreciated thanks

Select customers, address
from

where project > 6000