Database review exercise

Before we begin this year's new ideas for Access, we need to spend a few periods to become familiar once again with some basics ideas and techniques.

Use the links below in order to review the following:

1. Basic Database Concepts
• database
• field
• record
• table
• query
• report

2. Using Microsoft Access
• Creating a table - creating fields
• Adding properties to fields - field name, data type, input mask
• Adding data (records) to a table


Online Resources

1. http://tinyurl.com/jd5w - START YOUR REVIEW HERE with our BTT demo animations at the Jarvis website. They show Access 2000 rather than Access 2003, but the differences are minimal.
   
   
2. http://youtube.com/watch?v=7rSJbe2cWY4&feature=related - video tutorial: Introduction to Access fields, records, tables
   
   
3. http://youtube.com/watch?v=vuPxjdsWtyw&feature=related - video tutorial: How to create a simple table in Access
   
   
4. http://youtube.com/watch?v=sbZCrenf6wQ&feature=related -- video tutorial: Simple queries in Access
   
   
5. http://www.fgcu.edu/Support/office2000/access/ - Basic tutorial for Access 2000 with good illustrations. We used this in BTT. The differences between Access 200 and Access 2003 are small.
   
   
6. http://youtube.com/watch?v=yF87VqfwZm8&feature=related -- video tutorial: Queries in Access
   
   
7. http://youtube.com/watch?v=i72sqEBBALs&feature=related -- video tutorial": Creating reports in Access
   
   
   
8. http://office.microsoft.com/en-us/training/CR061829401033.aspx - Access 2003 tutorials from Microsoft. Complete lessons of about 30 minutes each.
   
   
9. www.dowling.edu/mydowling/tech/tutorials/Access2000Foun.ppt - Powerpoint introduction to databases in general (slides #1-8), the basic features of Access (slides #11-28) and some Access techniques (slides #35-53, 79-87, 120-125). To get a headstart on some of what is new this year, you might look at relationships (slides #65-71)
   
   
10. http://www.teacherclick.com/access2003/index.htm - Access 2003 tutorial.
    
    
11. http://apex.vtc.com/access-2003.php - Another Access 2003 tutorial.
    
    
12. http://www.ischool.utexas.edu/technology/tutorials/office/access03/index.php - Yet another Access 2003 tutorial.
    
    
13. http://www.dur.ac.uk/resources/its/info/guides/41Access2003.pdf - For reference or really serious study, here is a 76-page tutorial in .pdf format.
    
    
14. www.officetutorials.com/Access%202003%20tut.DOC - a 40-page Access 2003 tutorial in Word .doc format.