READER to te readerlD rd001 rd002 firstname address bp20 po box 40 Limbe bp45 bp67 bp30 bp9 bp70 bp80 bp09 bp76 surname MATINES MALET town sex Jones Limbe Male Peters Male Female Female rd003 rd004 rd005 rd006 rd007 rd008 rd009 rd010 ТEGHEN Rose Buea NGALA ТАВА TAFAC NANFACK NKEMKANG KAHMBANG joshua ABINI Tiko Ndop Nkwen bafousam bafousam Tiko batibo Joan Malam Vincent geogia john Male |Male Female Male Male Female beatrice LOAN readerID datetaken datedue rd001 rd005 rd001 rd002 rd004 rd004 rd010 bookID lib001 lib003 lib004 lib002 lib006 lib005 lib008 5/9/2013 10/9/2013 8/6/2012 1/3/2013 5/9/2013 9/9/2013 8/8/2013 9/10/2013 7/7/2012 10/8/2013 2/5/2013 8/6/2013 9/10/2013 10/15/2013

Np Ms Office 365/Excel 2016 I Ntermed
1st Edition
ISBN:9781337508841
Author:Carey
Publisher:Carey
Chapter7: Developing An Excel Application
Section: Chapter Questions
Problem 3RA
icon
Related questions
Question

Create a query for each of the following, save and print a copy:

  • Books on a loan, using only BookID, title, author, and date taken.
  • List of female readers who have at least loaned a book using only ReaderID, surname, first name, town, sex, book, title, and date taken. 
  • List of books that have been taken at least once and whose date of publication is before January 2013.
READER
to te
readerlD
rd001
rd002
firstname address
bp20
po box 40 Limbe
bp45
bp67
bp30
bp9
bp70
bp80
bp09
bp76
surname
MATINES
MALET
town
sex
Jones
Limbe
Male
Peters
Male
Female
Female
rd003
rd004
rd005
rd006
rd007
rd008
rd009
rd010
ТEGHEN
Rose
Buea
NGALA
ТАВА
TAFAC
NANFACK
NKEMKANG
KAHMBANG joshua
ABINI
Tiko
Ndop
Nkwen
bafousam
bafousam
Tiko
batibo
Joan
Malam
Vincent
geogia
john
Male
|Male
Female
Male
Male
Female
beatrice
LOAN
readerID datetaken datedue
rd001
rd005
rd001
rd002
rd004
rd004
rd010
bookID
lib001
lib003
lib004
lib002
lib006
lib005
lib008
5/9/2013 10/9/2013
8/6/2012 1/3/2013
5/9/2013 9/9/2013
8/8/2013 9/10/2013
7/7/2012 10/8/2013
2/5/2013 8/6/2013
9/10/2013 10/15/2013
Transcribed Image Text:READER to te readerlD rd001 rd002 firstname address bp20 po box 40 Limbe bp45 bp67 bp30 bp9 bp70 bp80 bp09 bp76 surname MATINES MALET town sex Jones Limbe Male Peters Male Female Female rd003 rd004 rd005 rd006 rd007 rd008 rd009 rd010 ТEGHEN Rose Buea NGALA ТАВА TAFAC NANFACK NKEMKANG KAHMBANG joshua ABINI Tiko Ndop Nkwen bafousam bafousam Tiko batibo Joan Malam Vincent geogia john Male |Male Female Male Male Female beatrice LOAN readerID datetaken datedue rd001 rd005 rd001 rd002 rd004 rd004 rd010 bookID lib001 lib003 lib004 lib002 lib006 lib005 lib008 5/9/2013 10/9/2013 8/6/2012 1/3/2013 5/9/2013 9/9/2013 8/8/2013 9/10/2013 7/7/2012 10/8/2013 2/5/2013 8/6/2013 9/10/2013 10/15/2013
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Single Table
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Np Ms Office 365/Excel 2016 I Ntermed
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage