Microsoft Office Tutorials and References
In Depth Information
Updating Records
AC 141
To Start Access
The following steps, which assume Windows is running, start Access.
1 Click the Start button on the Windows taskbar to display the Start menu.
2 Point to All Programs on the Start menu to display the All Programs submenu and then
point to Microsoft Offi ce on the All Programs submenu to display the Microsoft Offi ce
submenu.
3 Click Microsoft Offi ce Access 2007 on the Microsoft Offi ce submenu to start Access and
display the Getting Started with Microsoft Offi ce Access window.
4 If the Access window is not maximized, click the Maximize button on its title bar to
maximize the window.
To Open a Database
In Chapter 1, you created your database on a USB fl ash drive using the fi le name,
JSP Recruiters. There are two ways to open the fi le containing your database. If the fi le
you created appears in the Recent Documents list, you can click it to open the fi le. If not,
you can use the More button to open the fi le. The following steps use the More button to
open the JSP Recruiters database from the USB fl ash drive.
1 With your USB fl ash drive connected to one of the computer’s USB ports, click the More
button to display the Open dialog box.
2 If necessary, click the Look in box arrow and then click UDISK 2.0 (E:) to select the USB fl ash
drive, in the Look in list as the new open location. (Your drive letter might be different.)
3 Click JSP Recruiters to select the fi le name.
4 Click the Open button to open the database.
5 If a Security Warning appears, click the Options button to display the Microsoft Offi ce
Security Options dialog box.
6 Click the Enable this content option button.
7 Click the OK button to enable the content.
Updating Records
Keeping the data in a database up-to-date requires updating records in three ways: adding
new records, changing the data in existing records, and deleting existing records.
Adding Records
In Chapter 1, you added records to a database using Datasheet view; that is, as you
added records, the records appeared on the screen in a datasheet. The data looked like a
table. When you need to add additional records, you can use the same techniques.
In Chapter 1, you used a split form to view records. The split form contained both a
form and a datasheet. You can use either portion to add records. You also can use a simple
Search JabSto ::




Custom Search