بغيت فزعتكم

[عاشق مدينة ابوظبي]

1. Start Access 2007, open the file LC4Project.accdb.
2. Open the table tblStock and insert the following four records:



Staff

Company

Item

Unit

Sales

Delivery

Date

RT

Dygitell
Biro - Red (box 20)


2.4

2

Y

1/19/2009

RT

Dygitell
Biro - Red (box 20)


2.4

4

N

1/19/2009

RT

Dygitell
Biro - Red (box 20)


2.4

1

Y

1/20/2009

RT

Dygitell
Biro - Red (box 20)


2.4

2

Y

1/20/2009


3. Produce a query which shows only the records where the Company is TryIT or Dygitell and the Item field is not blank and Sales is 10 or more. Save the query as “qTryITDygitellStock”.
4. Produce a query which:
o Shows only the records which are delivered, the words Biro and Blue appear as part of the Item field and are between 10th January 2009 and 20th January 2009 inclusive. Hint (use this criteria for the item field Like "*biro*blue*).
o Sorts the data into ascending order of Staff (with IS at the top) and then descending order of Company.
o Save the query as “qBlueBirosDelivered”.
5. Produce a report which:
o Has a page orientation of portrait.
o Use the query “qBlueBirosDelivered” as data source for your report.
o Insert the Staff, Company, Item, Unit, Sales and date fields to your report.
o Group your report by the staff field.
o Include the heading “Blue Biros Delivered”at the top of the page.
o Has your name, page number in the footer section.


الارقام ابغيها بالانكليزي وبليز الله يخليكم فزعتكم