Reference no: EM13168626
PROJECT 1
To identify the number of employees at the New Book Sales Corporation, you view the records in the Sales Department table. You decide to
add a parameter query where you can enter a title for a group of employees and have all employees in that group displayed in the query results.
1. Open the New Book Sales file from the drive and folder where your Data Files are stored. Save the database as New Book Sales
Database, followed by your initials.
2. Create a parameter query for the Sales Department table. In the Design window, add the Employee ID, Last Name, First Name, and Title
fields to the query grid. Since each field in the table will be included in the query, think of a quick way to put each field in the query grid.
3. Enter a prompt in the Title field that will prompt the user to enter a title for a group of employees.
4. Sort the query in ascending order by the Last Name field, and then add another sort in ascending order to the First Name field.
5. Save the query as Qry-Employees by Title.
6. Run the parameter query using Sales Rep as the criterion. Adjust the column widths if necessary. Print the query results.
7. Run the query using the Sales Assistant and the Sales Manager parameters. Print the results of each query.
8. Close the query and the database file.
|
Type of leadership style
: Which type of leadership style takes charge of making decisions and makes sure people do what they are told?
|
|
Write a method called alldigitsodds that returns
: Write a method called AllDigitsOdds that returns whether every digit of a positive integer is odd. Return true if the numbers consist entirely of odd digits (1,3,5,7,9)
|
|
Create a data set with 100 integer values.
: Create a data set with 100 integer values. Create a program that uses the division method of hashing to store the data values into hash tables with table sizes of 7,,51 and 151. Use the linear probing method of collision resolution. Print out the ..
|
|
Sociological term coined
: What is the sociological term coined by Irving Janis for a limited understand ing of some issue resulting from group conformity?
|
|
Number of employees at the new book sales corporation
: To identify the number of employees at the New Book Sales Corporation, you view the records in the Sales Department table.
|
|
Why are polychlorinated biphenyls importance
: Why are polychlorinated biphenyls (PCB's) importance to an EH&S or FS professional who encounters them when come to an incident where they are present?
|
|
Compute the wavelength of light that is absorbed
: Caculate the wavelength of light( in nanometers) that is absorbed when the electron in a He+ ion goes from the n=2
|
|
Consider a cpu that implements four parallel
: Consider a CPU that implements four parallel fetch-execute pipelines for superscalar processing. Show the performance improvement over scalar pipeline processing and no-pipeline processing, assuming an instruction cycle similar to figure 4.1 in th..
|
|
Explain one mole of an ideal gas is heated
: One mole of an ideal gas is heated from 100 C to 322.4 C at constant VOLUME. Report the heat added (in kJ and three significant digits) to this gas to achieve this heating
|