Assignment2 - This assignment is keyed to Access. You will...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
This assignment is keyed to Access. You will be creating several tables , 1 query and 1 form in Access. You will also create a simple Access query and create reports for these queries . The database you will be creating will be for a library. Books and subjects have many to many relationships since many books can have the same subject and a single book can have many subjects. Using Access complete the following: 1. Create a new database. Select blank database (do not use the database wizard). Name your database library . For all tables start in design view and do not use the table wizard. Create the following 4 tables : a) A table named Books . This table should have fields for bookid, author, title, place of publication, publisher, and date of publication. You may add any other field that you would like. Make the bookid numeric and a key field. Do not add a subject field; we will make a separate table for that. Using 10 books of your choice enter the information about these books into your table. b) A table named Subjects. This table will have two fields: one named subjectid and another named subjects. The subjectid will be the key field. Use the subject headings you plan to assign to the books you selected in part one to enter in the subjects’ field. This table will be your
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 2

Assignment2 - This assignment is keyed to Access. You will...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online