Site Map

Home | Course Info |  Syllabus | Calendar | Assignments | Resources | Review | WebCT | FAQ

Last Week's Lesson | Next Week's Lesson

What We Did Last Week

In creating the Awesome Intranets workbook, you learned how to work with large worksheets that extend beyond the window and how to use the fill handle to create a series. You learned to display hidden toolbars, dock a toolbar at the bottom of the screen, and hide an active toolbar. You learned about the difference between absolute cell references and relative cell references and how to use the IF function. You also learned how to rotate text in a cell, generate a series, freeze titles, change the magnification of the worksheet, display different parts of the worksheet through panes, create a 3-D pie chart, and improve the appearance of a 3-D Pie chart. Finally, project 3 introduced you to using Excel to do what-if analysis by changing values in cells and goal seeking.

Some of you had questions on assignment 8, Laser Fast Technology Seven-Year Financial Projection. To display the years in the 3-D Column Chart, you have to format the numbers (years) to text. To change the number to text, simply type a single quotation before the digits, for example, '2006, '2007, '2008... '2012. Redo the chart using the chart wizard and you will see years displayed under the chart.

Microsoft Office 2003 Teacher and Student version does not come with Access. If you have Teacher and Student version and need Access, you can pick up a copy of Microsoft Office 2003 Professional 30-day trial CD from me. Make sure to finish all your work within 30 days before it expires.

You should have submitted all your assignments up to assignment 8. Please contact me if you don't see your grade posted a week after you submitted your assignment.

Top of the Page

What You Will Learn This Week

• Lesson 14: Access 2003: Creating a Database Using Design and Datasheet Views

In Project 1, you will learn about databases and database management systems. You will learn how to create a database and how to create the tables within a database. You will see how to define the fields in a table by specifying the characteristics of the fields. You will learn how to open a table, how to add records to it, and how to close it. You also will print the contents of a table. You will created a form to view data on the screen and also create a custom report. You will learn how to use Microsoft Access Help. Finally, you will learn how to design a database to eliminate redundancy.

Top of the Page

Lesson Objectives

After completing this lesson, you will be able to:

• Create a database using design and datasheet views.

  • Describe databases and database management systems
  • Describe the speech recognition capabilities of Access
  • Start Access
  • Describe the features of the Access desktop
  • Create a database
  • Create a table and define the fields in a table
  • Open a table
  • Add records to a table
  • Close a table
  • Close a database and quit Access
  • Open a database
  • Print the contents of a table
  • Use a form to view data
  • Create a custom report
  • Use the Access Help system to answer your questions
  • Design a database to eliminate redundancy

Top of the Page

Activities for This Week

• Test #4 (Excel 2003) - Monday, 11/7/05, 6:00 p.m.
  Room 2146, Academic Computing Center, Pensacola Campus

• Reading Assignment - Project 1 in Microsoft Access 2002 section in your textbook.

• Assignment #9, Part 1 -  Creating a Database using Design and Datasheet Views.

  You have three weeks to complete this assignment. Email your assignment to your instructor at llemley@pjc.edu as an attachment after you complete the entire assignment. Remember to type "Your Section #, Assignment 9, Your Name" in the Subject.

• MSLQ survey - You are selected to be in a research study to determine how motivation and use of learning strategies influence performance. You will be asked to complete a survey consisting of demographical information and questions correlating to motivation orientation and cognitive/metacognitive learning strategies. Here is more information concerning the survey. Please go to WebCT to answer the MSLQ survey. Remember to answer all questions and save each one of them before submitting your survey. Thank you in advance for your participation.

Troubleshooting -

Pop-up blocking software
The survey appears in a new browser window. If you have pop-up blocking software installed on your computer, the survey may not appear. To take the survey, you may have to disable the pop-up blocking software.

Top of the Page

Conclusion

At the end of this lesson, you have learned:

       To create a database using design and datasheet views.

  Assignments

• Reading Assignment - Project 1 in Microsoft Access 2003 section in your textbook.

• Email your Assignment #9 to your instructor only after you complete the entire assignment.

• Threaded Discussions - Censorship on the Internet

  What we will do next week:  Microsoft Access 2003

• Lesson 15: Querying a Database Using the Select Query Window

• Assignment #9

Top of the page

Home | Course Info |  Syllabus | Calendar | Assignments | Resources | Review | WebCT | FAQ

Home | Course Info |  Syllabus | Calendar | Assignments | Resources | Review | WebCT | FAQ

Last Week's Lesson