PDF4PRO ⚡AMP

Modern search engine that looking for books and documents around the web

Example: confidence

Microsoft Access Practice Exam 2 - CS 12 Lab

1 Microsoft Access Practice Exam 2 Instructions to download and unzip the file needed to perform this Practice exam. Go to the Practice Exam Files Download web page: on the CSCI 012 Lab Website to follow the instructions to obtain the Practice exam files. Open the file PracticeAccess2. 1. Create a Table: A. Create a table called Publisher having the following structure: Field Name Data Type PubID Short Text PubName Short Text URL Hyperlink Set the field PubID as the primary key. Set the Field Size field property of the field PubID to 5. Set the Field Size field property of the field PubName to 50. Set the caption property of the PubID field to Publisher ID. Set the caption property of the PubName field to Publisher s Name. B. Enter the following data for the Publisher table: PubID PubName URL MH McGraw-Hill PH Prentice Hall WI Wiley EL Elsevier AW Addison Wesley MP MIT Press CL Cengage Learning 2 2.

3 5. Create Queries: Query 1: List all of the books that are published by Prentice Hall using the LastName field of the Author table, the Title field of the Book table, and the PubName field of the Publisher table.Sort the query in ascending order according to the Title field.Save this query as Prentice Hall Books. Query 2: List all of the books where the publish date is greater than …

Fullscreen Download
Loading..

Tags:

  Practices, Exams, Access, Microsoft, Microsoft access practice exam 2

Information

Domain:

Source:

Link to this page:

Please notify us if you found a problem with this document:

Spam in document Broken preview Other abuse

Transcription of Microsoft Access Practice Exam 2 - CS 12 Lab

Related documents

MS Access - Tutorialspoint

www.tutorialspoint.com

MS Access 3 Microsoft Access has the look and feel of other Microsoft Office products as far as its layout and navigational aspects are concerned, but MS Access is a database and, more specifically, a relational database. Before MS Access 2007, the file extension was *.mdb, but in MS Access 2007 the

  Access, Microsoft, Tutorialspoint, Microsoft access

Microsoft Password Guidance

www.microsoft.com

Create a unique password for your Microsoft account email address to verify your identity. If someone gains access to your email, The security of your Microsoft account is important for several reasons. Personal, sensitive information may be associated to your account such as your emails, contacts, and photos.

  Guidance, Access, Microsoft, Password, Microsoft password guidance

Related search queries

Access, Tutorialspoint, Microsoft Access, Microsoft, Microsoft Password Guidance