Getting Started
- Overview: Access 1A and 1B + HTML Assignment 5
- Pages: page 741 to 796;
- File Download: right click here and select
save link as...); - Security warning: There is a security warning when you try to open the downloaded file in Access. Click "No", then "Yes", and then "Open".
- Grade inquiry
After you have followed the instructions in the manual and finished all the steps, check the following questions before you raise your hand and declare you are done.
Project 1A
Here is what you should learn from Project 1A:
- Know the name of the database from Windows Explorer (or My Computer feature);
- How to open a database;
- How to control the database window inside the Access window (maximize, unmaximize);
- Know the concept of table, database, and database object;
- How to open a table in database;
- Know different views of table in Access and how to switch views;
- Understand relationsip between these concetps: table, record, and field;
- How to open a query, a form and a report.
Project 1B
Here is what you should learn from Project 1B:
- How to create a database;
- How to create a new table in the database; (understand design view and data type
- Understand the concept of primary key;
- What is the design of a table and how to modify the design of a table, including deleting and adding a field;
- How to print a table with a specific orientation;
- Skills in editing the records: switch to datasheet view; delete a record; resize columns; resize all columns; and adjust all rows to a standard height;
- How to sort records and how to unsort (return to original sorting).
HTML Assignment 5: Adding e-mail link and anchor (in-page link)
An e-mail link is a link that points to an e-mail, such that when you click on it, your e-mail client (such as Outlook, or Outlook express, or Mozilla Thunderbird) will be launched and be ready to send a message to that email address. You can try this sample e-mail link.
An anchor, which is basically an in-page link, links to some line in the current page instead of another web page. You can try this sample anchor to go to the top of the page.
We will learn how to add e-mail link and anchor to your webpage.
This Guided Tour will be covered during the class at around 6:30PM.