CSS2: May 2023

STEPS IN CREATING FORMS FROM TABLE

AFTER CREATING THE RELATIONSHIP, AT THE RIBBON

CLICK " CREATE".

LOOK FOR " FORM" OR CLICK YOUR PREFERED FORM.

IF YOU WANNA EDIT, " RIGHT CLICK" THEN " DESIGN VIEW"

TO EDIT YOUR FORM.

YOU CAN ADD COLOR, AND CUSTOMIZED YOUR FORM IN THE

DESIGN VIEW.

RIGHT CLICK THEN " SAVE"

AFTER SAVING OR FILLING UP THE INFORMATIONS, THIS WILL

BE THE RESULT WHEN YOU GO TO YOUR FIELD.

NOW YOU ARE ALL DONE.

HOW TO LINK RELATIONSHIPS

IN THE RIBBON, LOOK FOR THE RELATIONSHIP BUTTON

ADD THE TABLE YOU HAVE CREATE.

RIGHT CLICK THE "PK" AND CONNECT TO "FK" OF THE OTHER

TABLE TO CREATE THE RELATIONSHIPS.

THE ACCESS WILL SHOW WHAT RELATIONSHIP YOU HOW TO

EDIT RELATIONSHIPS. THEN CLICK " CREATE".

LASTLY, YOU WILL SEE THAT THE TABLES HAVE NOW A

RELATIONSHIP AND IS CONNECTED TO EACH OTHER.

STEPS IN CREATING TABLE IN MS ACCESS

COLLECT THE ENTITY AND ATTRIBUTES NEEDED.

GO TO MS ACCESS.

THEN IT WILL DIRECT YOU TO THE TABLES

THEN RIGHT CLICK AND CLICK THE DESIGN VIEW

TO FILL THE DATA.

CHANGE THE NAME OF THE TABLE TO "DB_" AND THE NAME OF THE TABLE YOU WANT TO CREATE.

AFTER FILLING UP DATAS, RIGHT CLICK AND SAVE

TO CREATE ANOTHER TABLE.

IF YOU WANNA CREATE ANOTHER TABLE JUST

DO THE STEPS AGAIN.

CSS2