Library System Using MS Access Part 1

1

(Note: for Educational Purposes)

MS ACCESS ACTIVITY 17.1 – PRIMARY KEY & TABLE RELATIONSHIPS

A LIBRARY SYSTEM

Part 1 – Creating Two Primary Tables

Instructions:

1.       Lunch MS Access.

2.       Create a new Blank Database and save as <Your Initials>_Library System, Save the table as Students and set the StudentID field as the primary key. Refer to the table specification as found below.

FIELD NAME	DATA TYPE	FIELD PROPERTIES	Format/(Data for Lookup Wizard)
StudentID	Autonumber		“SN-“0000
FirstName	Text		>[Blue]
LastName	Text		>[Red]
City	Lookup Wizard		Calauag, Lopez, Guinayangan,…
HomePhone	Text	Input Mask	!(9999) 000-0000
YearLevel	Lookup Wizard		I, II, III, IV
Section	Text		St. Bridget to St. John Vianney
Photo	Attachment		(Collect ID photos at least 1x1 in)

3.       Create a table that will contain the information for all the books in the library. Save the table as Books.

a.       Use the fields below and set BookID as the primary key.

Field Name	Data Type
BookID	Autonumber
Title	Text
Category	Text
Available	Yes/No
Notes	Memo

b.      Change the Format of the BookID field to “BK-“0000.

c.       Create a Lookup Wizard for the Category Field. Type the following: “Computer”, “Health”, “Literature”, “Mathematics”, “Religion”, “Science”.

d.      Place a default value in the Available field so that it will return the value Yes (check mark) every time a new book is added.

e.      For now, encode at least fifteen records. You may use the sample items below.

f.        Save the changes and close the Table.

Part 2 - Creating Junction Table

4.       Create a new Table in Design View that will hold all of the completed Transactions. See specifications below:

a.       Set the Format property for DateBorrowed, DueDate, and DateReturned to Short Date

Field Name	Data Type
BorrowerID	Number
BookNumber	Number
DateBorrowed	Date/Time
DueDate	Date/Time
DateReturned	Date/Time

b.      Click DateBorrowed and add expression to the Default Value property. Type =Date() and press Enter. The expression will return the current system date as a default value.

c.       On DueDate’s Default Value property, type =Date()+7.

d.      Save the Table as Transactions.

e.      If prompted to create a primary key, choose No.

f.        Close the table and save your Database.

Part 3 – Creating Relationships

5.       Open the Relationships document tab and show the three tables. Add them all to the relationship window.

a.       Drag the StudentID field from the Students Table into the BorrowerID field in the Transaction Table to create the relationship.

b.      Click Enforce Referential Integrity and check the other two options. Click Create.

c.       To create a many-to-many relationship, Drag the BookID field from the Books table to the BookNumber field in the Transaction table.

d.      Click Enforce Referential Integrity and check the other two options. Click Create.

Note: This is an individual activity, and all Students shall present their individual output.

MS Word or Google Docs? (A Poem)

MS Word or Google Docs?

(A Poem - Dennis F. Erasmo - 8/12/14 12:00 PM)

Dennis F. Erasmo (Author)

Microsoft word is an standard

Google Suite comes in.

The two are both word processor

But Google docs is online.

You can save documents online

You can access Google Suite anywhere

You can use your mobile devices

Such as iOS devices or Android phone and tablets.

Google Suite is OS independent

With just a browser and internet

You can edit and print your documents

And submit these wherever you are on Earth.

ACTIVITY # 1 – APPLYING HTML TAGS

1.       Type the document below in Notepad.

Nature Reveals

Our Physical World, respect and explore. Where water meets land, a beautiful shore. Mountains we conquer, look down in awe. If you're an artist, make sure you draw. Nature exciting, adventurously new. Much more to see than a sky that is blue. If offers so much, open your eyes. Hope of today, with every sunrise. Nature shall feed, body and soul. Some call it home, others a hole. Memories are nurtured, when nature reveals. Sharing its pleasures, amazing it feels.

2.       Apply HTML Tags by inserting them into your document.

3.       For the document title, type:

<center><strong>Nature Reveals</strong></center>

4.       Enclose the paragraph with the opening <p> tag and the closing </p> tag.

5.       Add <em><b> and </b></em> to the words “respect and explore” like this:

<em><b> respect and explore </b></em>

Do this also in “body and soul” on the paragraph. The tags will make these words bold and slanted.

6.       Save the document as nature.html on your preferred folder.

7.       View the file on your web browser.

ACTIVITY 02 – CREATING AN HTML FILE IN NOTEPAD

1.       Launch Notepad.

2.       Type “<DOCTYPE html>” to set the document type to HTML5.

3.       In the second line, type the opening tag <html lang=“en”>. (This is to set your default language to English)

4.       Type the <head> tag in the third line.

5.       Inside the Head section, type the following tags to specify your page title:

<title>My First Web Page</title>

<meta charset=“utf-8”>

6.       Close the Head section with the </head> tag.

7.       For the Body section, type the following:

<body>

        <h1> My First Web Page </h1>

<p> This is the first simple page design <em> experience!</em></p>

<h2> This will be my sub-heading! </h2>

</body>

8.       End your document by typing the </html> closing tag.

9.       Save your document as, myfirstwebpage.html.

10.   Open the file in your browser.

Lesson 01 on HTML5 AND CSS3

WEBSITE LAYOUTING IN CSS3 WITH HTML5

Creating Divisions using HTML5 Semantics

a.  Create New Folder in Documents with your Name+Site+Project.

b.      Inside your Site Project folder, create two additional folder and name it img & css respectively.

c.       Collect at least 1 logo (science, etc), 1 photo and a background image, place it in img folder.

d.      Type the following code in Notepad and save it in your Site Project folder.

<!doctype html>

<head lang="en">

<meta charset="utf-8">

<title>Primer on Theory of Relativity</title>

   <link rel="stylesheet" href="css/style.css">

<head>

<body>

<div id="container">

    <header>

        header

    </header>

    <nav>

       nav

    </nav> 

     

    <section id="main" role="main">

        <article>

            <h1> Primer on Theory of Relativity </h1>

        </article>       

    </section>

     

    <aside>

       sidebar

    </aside>

     

    <footer>

        footer

    </footer>

</div> <!--! end of #container -->

</body>

</html>

e.      Save as index.html, do not close Notepad.

f.        Open new instance of Notepad, type the following rules:

/* =============================================================================

   Primary styles

   Author:

   ========================================================================== */

header {

  background-color:#DC6F65;

}

nav {

  background-color:#70996A;

}

section#main {

  background-color:#EBEBEB;

}

aside {

  background-color:#8CCAF0;

}

footer {

  background-color:#993398;

}

g.       Save it with a filename style.css in your css folder.

Throughout the rest of this tutorial you'll often be modifying existing rulesets in your css file, ie. style.css.

Let’s give some of these elements a starter heights so we can start to visualize the layout. Modify these sections of the CSS: and it's time to add a new line to it, and displayed with these mark! /*+*/ ←add these lines to your style.css rule.

header {

  background-color:#DC6F65;

  height:150px; /*+*/          

}

nav {

  background-color:#70996A;

  height:40px; /*+*/

}

footer {

  background-color:#993398;

  height:100px; /*+*/

}

Save your css rule!

1.      Now, go back to your index.html file, then add the following below the: <h1> Primer on Theory of Relativity </h1>

<p>

The theory of relativity, proposed by the Jewish physicist Albert Einstein (1879-1955) in the early part of the 20th century is one of the most significant advances of our time. Although the concept of relativity was not introduced by Einstein, his major contribution was the recognition that the speed of light in a vacuum is constant and an absolute physical boundary for motion.

<br> This does not have a major impact on a person's day-to-day life since we travel at a speeds much slower than light speed. For object travelling near light speed, however the theory of relativity states that objects will move slower and shorten in length from the point of view of an observer on earth.

</p>

2.      Type the following list inside your nav tag. It looks like this:

<nav>

    <ul>

        <li><a href="/">Home</a></li>

        <li><a href="/about">About Us</a>

          <li><a href="/products">Products</a>

<ul>

            <li><a href="/labsupplies">Lab Supplies</a></li>

            <li><a href="/books">Books</a></li>

     </ul>

<li><a href="/services">Services</a>

<li><a href="/contact">Contact</a>

    </ul>

</nav>

3.      Type the following list inside your aside tag. It looks like this:

<aside>

   <h2>Topics</h2>

   <ul>

       <li>Climate Change</li>

       <li>Sea Level</li>

       <li>Exploration</li>

       <li>Results</li>

       <li>Resources</li>

    </ul>

</aside>

4.  Type the following list inside your footer tag. And so it looks like this:

<footer>

    <p id="about">We're a full-observatory and action bureau with service-people globally.

    Call us, let us improve our living with deepest concern to environment!</p>

    

    <div id="footerlist">       

        <h3>Contact</h3>

          <ul>

              <li><a href="/email">Via Email</a></li>

              <li><a href="/contact_form">Web Form</a></li>

              <li><a href="/pigeon">Carrier Pigeon</a></li>

          </ul>

      </div>

      

      <p id="footercopy">All content © 2014, Yourname </p>

</footer>

This completes your document structure in HTML5, now you’re just going to style this HTML5 document by modifying the style.css rule sets. Go on, explore and discover the beauty of creating web page with style. Just a reminder, every time you create modification in your style.css file, refresh the index.html file in your browser to see the result. To start:

1.      Add this code in your style.css file to create padding, it looks like this:

section#main, aside, footer {

  padding:10px;

}

2.      Now, since we don't want our design stretching full-width across the browser, let's give the content area a width, and center it on the page. Add this below your custom styles:

div#container {

  width:960px;

  margin:auto;

  margin-top:20px;

  border:1px solid grey; /*+*/

  border:1px solid #4B4B4B;

  border-radius: 20px;

  border-top-left-radius: 20px 20px;

  overflow:hidden;

  box-shadow:0 0 15px #333;

 }

aside, footer {

  padding:10px;

}

3.      Then line up the section main and aside by assigning width and float rule by adding the rule set to your style.css.

section#main {

  background-color:#EBEBEB;

  width:710px;

  float:left;

  padding-left:25px;

  padding-right:25px;

  padding-bottom:20px;

}

aside {

  background-color:#8CCAF0;

  width:180px;

  float:right;

}

4.      The footer has been swallowed up by section-main and aside floats; to display footer, add this code to your style.css. below the line: “height:100px;”

clear:both; /*+*/

(This is your webpage's initial view)

Below is your webpage' expected output after completion of this activity.

Note: This is adapted from kdmc tutorials written by Scot Hacker.