Top-Rated Free Essay
Preview

A CH01 EXPV1 H1 Instructions

Satisfactory Essays
452 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
A CH01 EXPV1 H1 Instructions
Bookstore Inventory

Project Description:
In the following project, you will open a database containing the inventory of a bookstore, create a new table in which to store publisher information, add records, and then sort the table. You add a record using a form and print a report. You apply a filter by selection to a query and a filter by form to a table and save the results for both filters.

Instructions:
For the purpose of grading the project you are required to perform the following tasks:
Step
Instructions
Points Possible
1
Start Access. Open the downloaded Access file named exploring_a01_grader_h1.
0
2
Create a new table in Design view. Add the following field names to the table: PubID, PubName, PubAddress, PubCity, PubState, and PubZIP (in that order). Accept Short Text as the data type for all fields.
12
3
Set the PubID field as the primary key of the new table. Save the table using the name Publishers and then view the table in Datasheet view.
8
4
Add the following records to the Publishers table:
PubID PubName PubAddress PubCity PubState PubZIP
KN Knopf 299 Park Avenue New York NY 10171
BB Bantam Books 1540 Broadway New York NY 10036
PH Pearson/Prentice Hall 1 Lake Street Upper Saddle NJ 07458
SS Simon & Schuster 100 Front Street Riverside NJ 08075 Close the table.
12
5
Open the Books table and create a new record:
AuthorCode: 15
Title: The Innocence Game
ISBN: 0-307-96125-7
PubID: KN
PublDate: 2013
Price: 24.95
StockAmt: 250

12
6
Sort the records in the Books table by the PublDate field in descending order. Save and close the table.
4
7
Open the Maintain Authors form. In record 2 (for Keith Mulbery, AuthorID 12), add a new title to the subform:
Title: Computer Wisdom III
ISBN: 0-684-80417-5
PubID: PH
PubDate: 2014
Price: 32
StockAmt: 42
12
8
Use the Navigation bar to search for AuthorID 16, and then edit the subform so that the StockAmt is 6 instead of 496 for the book Follow the Stars Home.
8
9
Open the Publishers, Books, and Authors report and check that the report shows three books listing Keith Mulbery as author. View the layout of the report in Print Preview and then print the report. Open the Publishers, Books, and Authors query. Sort the query by the publisher’s name in ascending order.
6
10
Use filter by selection to show only the books by the author whose first name is Steven.
8
11
Sort the query by Title in ascending order. Save and close the query.
6
12
Open the Books table. Use Filter by Form to create a filter that will identify all books published after 2010 with fewer than 100 items in stock. Apply the filter and preview the filtered table. Close the table and save the changes.
12
13
Close all database objects. Close the database and then exit Access. Submit the database as directed.
0

Total Points
100

You May Also Find These Documents Helpful

  • Satisfactory Essays

    Part 1 1. Write a script which will Create the needed tables as follows: a. Table name : DEPT i. Column datatype Mandatory? PK? FK?…

    • 1169 Words
    • 5 Pages
    Satisfactory Essays
  • Satisfactory Essays

    For the purpose of grading the project you are required to perform the following tasks:…

    • 639 Words
    • 3 Pages
    Satisfactory Essays
  • Good Essays

    ops335 lab 2 firewall

    • 695 Words
    • 4 Pages

    5. Calculate the harmonized tax rate (HST) of 12% (list price X .12 = tax payable) – data type constant…

    • 695 Words
    • 4 Pages
    Good Essays
  • Satisfactory Essays

    For the purpose of grading of the project you are required to perform the following tasks:…

    • 402 Words
    • 3 Pages
    Satisfactory Essays
  • Powerful Essays

    This section is to be handed in complete on the day your assessment task is due.…

    • 845 Words
    • 4 Pages
    Powerful Essays
  • Satisfactory Essays

    Chid Abuse

    • 829 Words
    • 4 Pages

    For the purpose of grading the project you are required to perform the following tasks:…

    • 829 Words
    • 4 Pages
    Satisfactory Essays
  • Satisfactory Essays

    CTS 2437 Final Exam

    • 630 Words
    • 4 Pages

    4. Create a table called Customers that contains a person’s first name, last name, and social security number. Your table definition should…

    • 630 Words
    • 4 Pages
    Satisfactory Essays
  • Satisfactory Essays

    · Use the following lists to complete the assignment (and read the assignment deliverables below this chart):…

    • 513 Words
    • 5 Pages
    Satisfactory Essays
  • Better Essays

    The Terri Schiavo Case

    • 1626 Words
    • 7 Pages

    Bibliography: Author (if available). "Title of article." Publication Title Volume number. (if a journal include issue number) Date of publication (in parentheses if a journal): Pages. Supplier or Vendor. Database Name. AN (Accession number, if available). Access date.…

    • 1626 Words
    • 7 Pages
    Better Essays
  • Satisfactory Essays

    Chapter 1 Level 1

    • 689 Words
    • 3 Pages

    If you continue with the challenge and create additional tables for the database, your fields may appear as follows:…

    • 689 Words
    • 3 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Lyric Music Description

    • 309 Words
    • 1 Page

    Each title is classified according to its genre. The Genre table is a simple look­up table that lists…

    • 309 Words
    • 1 Page
    Satisfactory Essays
  • Powerful Essays

    The project will be about a Gift Shop database system. Because transaction records on papers can be lost or tampered, a simple yet effective and functional shop database system can be of use. This can also reduce the overall cost for managing the records that is paper based. This type of database system can be more secured and easy to manage.…

    • 2344 Words
    • 10 Pages
    Powerful Essays
  • Good Essays

    Interaction Design

    • 514 Words
    • 3 Pages

    Carry out an Hierarchical Task Analysis for the task of buying books from a High Street bookseller. Your analysis should take account of the range of user needs – e.g., some users will want to find a specific title while others want to browse potential titles before making a selection. Your HTA should be presented using the standard graphical notion and detailed plans should be written.…

    • 514 Words
    • 3 Pages
    Good Essays
  • Better Essays

    Hfkj

    • 1118 Words
    • 5 Pages

    The manager of a small book shop has asked you to design and implement a database that centralizes information so that it is easier and more efficient to man-age inventory and track orders and sales. The shop handles rare and out-of-print books and tends to carry only a few thousand titles at any one time. Currently, the manager tracks all of the sales and inventory on paper. For each book, the manager records the title, author, publisher, publication date, edition, cost, suggested retail price, and a rating that indicates the condition of the book. Each book is assigned one of the following ratings: superb, excellent, good, fair, poor, or damaged. The manager would like to be able to add a description to each rating (just a couple of sentences), but the description should not be required. The information about each book must include the title, author, cost, suggested retail price, and rating. The publisher, publication date, and edition are not always available. If the year a book was published is available, the year will never be before 1600. And for purposes of the new database system, the publication date will never fall after the year 2099. Because these books are rare, each title must be tracked individually—even if they are the same book (identical title, author, publisher, publication date, and edition). Currently, the manager assigns a unique ID to each book so that identical titles can be differentiated. This ID must be included with the book information. The book ID assigned by the manager is an eight-character ID made up of numbers and letters.…

    • 1118 Words
    • 5 Pages
    Better Essays
  • Powerful Essays

    Wordpress-Setup

    • 582 Words
    • 3 Pages

    - To create a new database, click “Databases” in the tab pane (first tab), and then enter a…

    • 582 Words
    • 3 Pages
    Powerful Essays