Download the database file appropriate for the database program you'll be using.

Access: Library.accdb

Base: Library.odb

Add at least 2 new authors and 5 new books to the database. See Using the Pet Hospital Database for help with this. Make sure each book has an author, by ID.

Modify the query BooksBefore2000, so that the records are listed in ascending sorted order by book title.

Add at least 3 new queries. The best way is to use the 'Edit Query by Design' feature. You might want to view and run the existing queries to see how they work. You may choose queries from the list below or create your own. Possible New Queries you can add:

books written by Naomi Novik - display title and year of publication

all books in a series

books in a series by a specific author

books in the specific series

books published in the 60s (or other decade)

the number of books by a specific author

all authors from a specific country

total number of books in a series by a specific author

the first year a specific author was published

When you create the title for each new query, include your name. For example: BarbBookSeries