PIERRE DE FERMAT HIGH SCHOOL

SUBJECT: COMPUTING
Alexander Camajá Cycle: 2021
GRADE: 5th HIGH SCHOOL IN COMPUTER SCIENCE
THIRD BIMONTHLY
JOURNEY: MORNING DAILY Worksheet 1

Value 10 points

ACCESS
Access is a data manager that uses the concepts of
relational databases and can be managed by
means of inquiries and reports. It is adapted for
collect data from other utilities like Excel,
SharePoint, etc

Exercise 1
I generated the following database with these fields, the database will be called:
CURSACC01.

1
 PIERRE DE FERMAT HIGH SCHOOL
COMPUTING
PROFESSOR: Alexander Camajá Cycle: 2021
GRADE: 5th BACHELOR'S IN COMPUTER SCIENCE
THIRD BIMESTER
JOURNEY: MORNING DAILY

Exercise 2
Assign the CODCLIENTE field as the Primary Key and create the following table that will be called
ARTICLES. Composed of the following fields and assign as the Primary Key the field
CODARTIC:

Exercise 3
Create the following tables called ORDERS and the other ZONES. Composed of the
following fields:

Assign the NUMPEDIDO field as the primary key.

Assign the ZONA field as the primary key.

2
 PIERRE DE FERMAT HIGH SCHOOL
COMPUTING
PROFESSOR: Alexander Camajá Cycle: 2021
GRADE: 5th BACHELOR IN COMPUTER SCIENCE
THIRD BIMESTER Worksheet 2
JOURNEY: MORNING DAILY
Value 5 points
Gain practical experience in the use of data sheets
Exercises 1, 2, and 3
1) Open the ARTICLES table, and fill in 6 or 7 records.
a. • For the prices indicate various quantities between 100 and 500 (this will be useful for
some of the subsequent exercises).
b. • Suggestion: make up the data, but use consecutive numbers for the
CODARTIC field, to facilitate data entry later
ORDERS. 2)

2) Open the ZONES table and fill in 4 records. • Suggestion: North, South, East, and
West

3) Open the CLIENTS table and fill in at least 10 records.

a. • It is not necessary to fill out all fields, but it must necessarily
fill in CODCLIENTE, NOMBRECLI, CODPOSTAL, POBLACION, DISCOUNT and
ZONAVENTAS, as we will use this data later.
b. • In the ZONAVENTAS field, use only data that you have inserted in the
field ZONE of the table ZONES.
c. • Several clients must be from Barcelona and Madrid.
d. • Suggestion: invent the data, but use consecutive numbers for the
field CODCLIENTE, to make data entry easier later on
ORDERS. Note how the properties of fields that we have defined,
determine the behavior of Access when entering postal codes (mask)
and discounts (validation rule); also note what happens when you try
omit ZONAVENTAS in any record (required). Note how the names of
the fields differ from those of the columns in those fields for which they
has defined the title property.

3
 Pierre de Fermat High School
COMPUTING
PROFESSOR: Alexander Camajá 2021
GRADE: 5th YEAR OF COMPUTER SCIENCE
THIRD BIMESTER Worksheet 3
JOURNEY: MORNING DAILY
Value 5 points
There are three types of table relationships in Access.
A one-to-many relationship. Let's use a database of
order tracking that includes a Customers table and an Orders table
A many-to-many relationship.
A one-to-one relationship.

Exercise 1
Carry out the following example of relationships in Access.

One to one: a relationship in which ONE record from a table is related to ONE unique record from
another table.Example:

In this example, a record from the Students table is related to a single record from the
Parents table.

4
 PIERRE DE FERMAT HIGH SCHOOL
COMPUTING
Professor: Alexander Camajá Cycle: 2021
GRADE: 5th YEAR OF COMPUTER SCIENCE
THIRD BI-MESTER
JOURNEY: MORNING DAILY

Exercise 2
One to many: a relationship between two tables in which ONE record from one of them is
related to SEVERAL records from the other.
Example:

In this example
a record from the Customers table is related to several records from the Orders table.
Many to many: a relationship in which ONE record of a table is related to MANY
records of the other and vice versa (it would be like the previous relationship, but read in both
sentdos)

5
 PIERRE DE FERMAT HIGH SCHOOL
COMPUTING
Alexander Camajá 2021
GRADE: 5th HIGH SCHOOL IN COMPUTATION
THIRD BIMESTER
JOURNEY: MORNING DAILY

Exercise 3
Many to many: a relationship in which ONE record of a table is related to MANY
records of the other and vice versa (it would be like the previous relationship, but read in both ways.
sentdos)
Example:

In this example, each record in the Products table is related to several records of the
table Orders and, in addition, each record in the Orders table is related to several records
from the Products table.

6
 PIERRE DE FERMAT HIGH SCHOOL
COMPUTING
PROFESSOR: Alexander Camajá Cycle: 2021
GRADE: 5th BACHELOR IN COMPUTER SCIENCE
THIRD BIMESTER
JOURNEY: MORNING DAILY Worksheet 4

Value 5
RELATING IN DATABASES
Exercise 1
Generate the following database and apply the corresponding relationships to each one.
Exercise 2
Enter 5 data per table

7
 PIERRE DE FERMAT HIGH SCHOOL
SUBJECT: COMPUTING
Alexander Camajá Cycle: 2021
FIFTH YEAR: BACHELOR IN COMPUTER SCIENCE
THIRD BIMESTER
JOURNEY: MORNING DAILY
Worksheet 5

Value 15 points
FORMS IN ACCESS
An Access form is a database object that you can use to create an interface for
User for a database application. You can use dependent forms for control.
access to data.

Exercises

8
 PIERRE DE FERMAT HIGH SCHOOL
COMPUTING
PROFESSOR: Alexander Camajá Cycle: 2021
GRADE: 5th HIGH SCHOOL IN COMPUTER SCIENCE
THIRD BIMESTER
JOURNEY: MORNING DAILY Worksheet 6

FINAL EXERCISE Value 15 points

1. Create three databases in Excel, one for work data, one for personal data and
another one of academic data

Each database must contain 10 data

3. Export the databases to Access

4. Make a query with the most important data from each database.
5. Prepare a report with the created query
6. Create a main form with personal data and two sub-forms with the
work and academic
7. Create a macro that allows filtering the data by position
8. Create another macro that displays a message according to what the person earns.
as total salary.

>= 10000 --- High

>= 5000 --- Medium
< 5000 --- Low

9. Create a login macro that with the user 'Exam' shows a menu with buttons that
allow to open the tables, form and report

Save the file at the beginning as... Exam Access II and its name