Access 2007:
Application
Development
Frequently asked questions and instructor notes
All our courses assume that each student has a personal computer to use during the class. Our hands-on approach to learning requires they do. This topic gives information on how to set up the classroom to teach this course. It includes minimum requirements for the students’ personal computers, setup information for the first time you teach the class, and setup information for each time that you teach after the first time you set up the classroom.
Student computer requirements
Each student’s personal computer should have:
· A keyboard and a mouse
· A Pentium 3 (or higher) processor
· At least 512 MB RAM
· 3 GB of available hard drive space
· A CD-ROM drive
· An SVGA or higher resolution monitor set to 1024x768 resolution or higher
· Internet access, if you want to download the Student Data files from www.courseilt.com, and for downloading the latest updates from www.windowsupdate.com
First-time setup instructions
The first time you teach this course, you need to perform the following steps to set up each student computer.
1 Install Microsoft Windows XP on an NTFS partition according to the software manufacturer’s instructions. Then, install the latest critical updates and service packs from www.windowsupdate.com. (You can also use Windows Vista, but the screen shots in this course were taken using Windows XP, so students’ screens will be different.) Choose the appropriate Internet connection settings during setup.
2 Install Microsoft Office 2007 according to the software manufacturer’s instructions as follows:
a When prompted for the CD key, enter the 25-character code included with your software.
b Select the Customize option.
c On the Installation tab, click the drop-down arrow next to Microsoft Office and choose Run all from My Computer.
d Click the drop down arrow next to all the item and choose Not Available except Access, Office Shared Features, and Office Tools.
e Click Install Now.
h When the installation has completed successfully, click Close.
3 To prevent macro warnings from appearing when students open tables in Access:
a Start Access.
b Click the Office button and select Access Options.
c In
the left pane, click
d In the left pane, click Macro Settings, and then under Macro Settings, select Enable All Macros.
e Click
OK to close the
f Click OK to close Access Options.
4 Set the default database folder as follows:
a Click the Office button and select Access options.
b In the Popular category, select the Default database folder box and enter C:\Student Data.
c Click OK to close Access Options.
d Close Access.
5 If necessary, install a printer driver. If a printer was connected to the computer during the installation of Windows, there’s a driver installed for that printer. If not, you should install a standard PostScript printer driver, such as one for the HP LaserJet 5.
6 If necessary, download the Student Data files for the course. You can download the data directly to student machines, to a central location on your own network, or to a disk.
a Connect to www.courseilt.com/instructor_tools.html.
b Click the link for Microsoft Access 2007 to display a page of course listings, and then click the link for Access 2007: VBA Programming.
c Click the link for downloading the Data Files for Students, and follow the instructions that appear on your screen.
Setup instructions for every class
Every time you teach this course, you need to perform the following steps to set up each student computer.
1 If necessary, reset any Access defaults that have been changed in previous classes.
2 Delete the contents of the Student Data folder, if necessary. (If this is the first time you’re teaching the course, create a folder named Student Data at the root of the hard drive.)
3 Copy the data files to the Student Data folder. (See the download instructions in the preceding section.)
Topic B: Frequently asked questions
There are no frequently asked questions for this course at this time.
Topic C: Course notes
There are no notes for this course at this time.
Topic D: Additional information
There is no additional information for this course at this time.