Access

Portfolio Artifact

Sara Vang

Pages:

1 – Title Page

2 – Creating a Database and Table Organization

3 – Form with a Sub-form

4 – Database Report Based on a Query

5 – Sorting Records

6 – Creating and Formatting a Form/Sub-form

7 – Enforcing Referential Integrity

8 – Adding and Formatting a Calculated Field in a Query

9 – Simply Creating Reports, Tables, Forms or Queries

10 – Creating a Report

11 – Creating a Table

12 – Creating a Query

13 – Changing Data Types

14 – Applying a Cell Effect

15 –Creating Queries with OR Conditions

Creating a Database

Table Organization

2

After creating the new database, make sure to save the database.

One-to-Many RelationshipA record from Table 1 can have many different matching records from Table 2. Table 2 can only have one matching record from Table 1.

One-to-One RelationshipRecords in Table 1 has only one related record in Table 2.

Many-to-Many RelationshipA record from Table 1 will have many matching records from Table 2. A record from Table 2 will have many matching records from Table 1.

**Data will not be duplicated because of the relationships that are created between the tables. Make sure all relationships are correctly made. **

Form with a Sub-form

Database Report Based on a Query3

A sub-form can be created within a form. The sub-form is

created because it displays related information to the form

that comes from a different table.

The icon highlighted in pink is the icon

needed for creating a sub-form.

4

Adding graphics make the report

more eye-catching.

Having calculated fields are helpful because it’s faster at doing the math and it saves

time. The “Annual Rent” field is a calculated field. The calculation is [Rent*12].

By sorting the information, it is easier to read and find the information. The information is sorted by the building

code (BldgCde) and then by the manager’s last name (MgrLname).

Sorting Records

5

Sorting the information will make it easier to find certain records when it is in a specific order. In this table, the records are sorted in ascending

(smallest to largest) order by the Tenant ID.

Creating and Formatting a Form/Sub-form

6

There are many different styled themes with different colored

choices.

The layout theme for this form is formatted with the Facet theme.

A sub-form is created within

the form.

Enforcing Referential Integrity

7

Checking the “Enforce Referential Integrity” box along with the

“Cascade Update Related Fields” and “Cascade Delete Related

Records” will make sure that the relationships between the tables remain consistent and updated.

In order to get the “Edit Relationship” box to show,

double click on the relationship line between the two tables that are needed.

Adding and Formatting a Calculated Field in a Query

8

In order to add a calculated field to a query, it must be in Design View. Type in the calculation and then run it

to see if it worked.

The calculated field in the query is added and

formatted with a dollar sign and two decimals.

Press “Run” after typing in

the calculation.

Simply Creating Reports, Tables, Forms or Queries

9

When creating reports, tables, forms or

queries, use the icons listed to get started.

Creating a Report

10

Use these “Controls” to add to the report

in Design View.

How the report looks like in Report View after all fields and

controls are added.

Creating a Table

11

When creating a table, determine the fields and data type.

The field name and data type are shown in the

table in Datasheet View.

Creating a Query

12

The data in the queries are retrieved

from the tables.

How the query looks once it is in Datasheet View after all fields are

entered in.

There are many options to choose from to

customize the data that will be shown.

Changing Data Types

13

In order to change data types, go to Design View. There are

different data types depending on the information needed in

the field name.

Applying a Cell Effect

14

By changing the cell’s effect, the cells stand out more and it is

easier to read. In the table, the cell effect changed to “Sunken,”

which made the cells deeper and darker.

There are different choices to choose from for a cell’s

effect.

Creating Queries with OR Conditions

15

Only Building Codes with “115” or “120” displays.

Go to Design View. Set up the “Criteria” with the

information that will be shown.