Access Test

Introduction to Computers – CIT100

 

1.                  Create a new database in Access; name the database AccessTest First Name Last Name;

2.                  Beginning in the first new field, add the following records; for the field with the word “Student” please add your name

ID	Field1	Field2	Field3	Field4	Field5
1	101	Walters	Gale	Accounting	$30,000
2	107	Sawyer	Michael	Sales	$45,000
3	187	Young	Allen	Sales	$39,000
4	224	Young	Cindy	Computer	$28,000
5	228	King	Cathy	Accounting	$33,000
6	100	Student	Student	Computer	$40,000

 

3.                  Rename each field as follows:

Field1              Employee ID
Field2              Last Name
Field3              First Name
Field4              Department
Field5              Salary

 

4.                  Click View to open the table in Design View.  Name the table Employees First Name Last Name (Remember:  replace first name last name with your name)

5.                  In Design View set Employee ID as the Primary Key

6.                  Delete the ID field

7.                  Return to the Datasheet view saving any changes and begin entering the additional records to the Employees First Name Last Name table

Employee ID	Last Name	First Name	Department	Salary
201	O’Hara	Daniel	Accounting	$45,000
308	Simpson	Robert	Marketing	$49,000
256	Singer	Judy	Sales	$33,000
310	Forrest	Matthew	Computer	$36,000

8.                  Apply Best Fit to all the columns to accommodate their data and column headings.

9.                  Using Print Preview, change the orientation to Landscape

10.              Print a copy for your records

11.              Save and Close the Employees First Name Last Name table

12.              Create a Query using the Employees First Name Last Nametable in design view;

a.                   Use all of the field names;

b.                  Sort by Last Name then by Department in ascending order

c.                   Run the Query

d.                  Save the Query as Sort List Last Name; (Remember to replace Last Name with your last name)

e.                   Close the query

13.       Create a Query using the Employees First Name Last Name table in design view;

            a.         Use on the Employee ID, Last Name, Salary

b.         Indicate criteria for all employees who have a salary greater than $35,000

            c.         Sort by the Last Name

            d.         Run the Query

            e.         Save the Query as Highly Paid Last Name

f.          Print a copy for your records

            g.         Close the query

14.       Create a form using the Form Wizard

a.       Use the Employees First Name Last Name table

b.      Use all the fields

c.       No special instructions for setup or sorting

d.      You pick a background style

e.       Save the form as Employee Input Form Last Name

EmployeeID	LastName	FirstName	Department	Salary
400	Anderson	Alex	Computer	$35,000

f.       Create a new record using the form you just created and enter the following information

g.      Save and close the form

 

 

15.              Create a Report using the Report Wizard

a.                   Use the Employees table

b.                  Use all the fields except the Employee ID in the report

c.                   No special grouping

d.                  Sort by Department in Ascending order

e.                   Use Tabular Layout with Landscape Orientation

f.                   You pick a style

g.                  Name the report Department List Your Last Name

h.                  Click on Finish

i.                    Adjust the information using Layout View so that all the information shows and the report looks appropriate for distribution

j.                    Print a copy for your records

k.                  Save and close the file

 

16.       Submit the completed test file to the Digital Drop Box.