In class on 2/9/2011 I’ll be demonstrating how to create a Microsoft Access database that meets the requirements of Assignment #2. Last year I made videos of the process that are (mostly) appropriate this year.
Because most of you will have Office-2010 your version of Access is newer than the one I used to make the videos. Almost all the steps are the same, but a few of the menu items have changed slightly, and one wizard has changed as well. Nonetheless it pretty much the same.
NOTE: I was able to view these videos in IE, Opera and Chrome, but my copy of Firefox refused to shows them for unknown reasons.
Tables - Video 1 - 9:38
Build Relationships - Video - 2 - 5:44
- Be sure to close tables first
- Enforce referential integrity
Build Queries using Wizard - Video-3 - 11:01
Build Forms using Wizard - Video-4 - 11:12
- Select Query to Start
- Create forms
- 2/8/2011 Note that Property Sheet doesn't automatically appear
- Right click to select "form properties"
- Add some data as do so
- Note that have ways to do pull-down list etc.
Build Report using Wizard - Video-5 - 7:48
- 2/8/2011 Report wizard different in 2010 Access
- No longer asked about appearance. Must do that later
No comments:
Post a Comment