HAYA_CT1212_ACCESS

Microsoft Access: Create a Database – Forms, Reports, and Queries

In this exercise, you will create a database that includes a table, form, report, and queries

Assignment Instructions:

1. Create a New blank database

2. Name the Access file as your First+Last name in all lowercase letters. (For example, Sara Mohammed would save her file as “saramohammed.accdb”) (Be sure to name the database before hitting the “Create” button)

3. In Design View, create a table using the structure shown below:

a. Name the table: Student List

b. Set the “Student #” field as the Primary Key

4. In Datasheet View, add the data below to the “Student List” table: Note: For “First Term Attended” the last two characters are numbers, not letters. For example, ‘SP01’ is an abbreviation of “Spring 2001.” Thus the ‘01’ should both be numbers – not the letter “O” and number “1.”

5. Modify the column widths as necessary

6. Create a form using the Form Wizard based on the “Student List” table

a. Use All Fields

b. Layout: Columnar

c. Form Name: Student Form

7. In Design View, change the Theme to “Gallery”

8. Add the following records using the Form:

(Your field data will not wrap around in the field as shown below)

10. Using the Report Wizard, create a report based on the “Student List” table, according to the following specifications:

a. Use All Fields

b. Group by: First Term Attended

c. Layout: Stepped

d. Orientation: Landscape

e. Title the report: Student Report

f. Adjust column widths in Design View as necessary

11. Create Queries :

a. Query 1: Create a query from the “Student List” table using the Simple Query Wizard. The basis of the query is as follows:

i. Your supervisor wants to see a report with the names and student numbers of the students who first attended in the Fall of 2000

ii. Select the appropriate fields and the appropriate criteria. Run this query.

b. Query 2: Create a query from the “Student List” table using the Simple Query Wizard. The basis of the query is as follows:

i. You need to mail billing statements to students who owe more than $20

ii. Select the appropriate fields and the appropriate criteria. Run this query.

12. Save your completed Access file as your first and last name in all lowercase letters. Attach your completed file to LMS.

CT1212 – ASSIGNMENT#2
DUE DATE: 2023-11-25 @ 11:59 PM
Microsoft Access: Create a Database – Forms, Reports, and Queries
In this exercise, you will create a database that includes a table, form, report, and queries
Assignment Instructions:
1. Create a New blank database
2. Name the Access file as your First+Last name in all lowercase letters. (For example, Sara Mohammed would save her file as
“saramohammed.accdb”) (Be sure to name the database before hitting the “Create” button)
3. In Design View, create a table using the structure shown below:
a. Name the table: Student List
b. Set the “Student #” field as the Primary Key
4. In Datasheet View, add the data below to the “Student List” table: Note: For “First Term Attended” the last two characters are numbers,
not letters. For example, ‘SP01’ is an abbreviation of “Spring 2001.” Thus the ‘01’ should both be numbers – not the letter “O” and number
“1.”
5. Modify the column widths as necessary
6. Create a form using the Form Wizard based on the “Student List” table
a. Use All Fields
b. Layout: Columnar
c. Form Name: Student Form
7. In Design View, change the Theme to “Gallery”
8. Add the following records using the Form:
(Your field data will not wrap around in the field as shown below)
10. Using the Report Wizard, create a report based on the “Student List” table, according to the following specifications:
a. Use All Fields
b. Group by: First Term Attended
c. Layout: Stepped
d. Orientation: Landscape
e. Title the report: Student Report
f. Adjust column widths in Design View as necessary
11. Create Queries :
a. Query 1: Create a query from the “Student List” table using the Simple Query Wizard. The basis of the query is as follows:
i. Your supervisor wants to see a report with the names and student numbers of the students who first attended in the Fall of 2000
ii. Select the appropriate fields and the appropriate criteria. Run this query.
b. Query 2: Create a query from the “Student List” table using the Simple Query Wizard. The basis of the query is as follows:
i. You need to mail billing statements to students who owe more than $20
ii. Select the appropriate fields and the appropriate criteria. Run this query.
12. Save your completed Access file as your first and last name in all lowercase letters. Attach your completed file to LMS.