Affiliates

Amazon.com


Popular Microsoft Access Books

Building Microsoft Access Applications
Building Microsoft Access Applications
Author: John L. Viescas 

Access 2003 All-in-One Desk Reference for Dummies
Access 2003 All-in-One Desk Reference for Dummies
Author: Alan Simpson 

Access 2003 for Dummies
Access 2003 for Dummies
Author: John Kaufeld 

Office 2007 All-in-One Desk Reference For Dummies
Office 2007 All-in-One Desk Reference For Dummies
Author: Peter Weverka 

Microsoft Office Access 2003 Step by Step
Microsoft Office Access 2003 Step by Step
Author: Online Training Solutions Inc. 

Access 2007 Bible
Access 2007 Bible
Author: Michael R. Groh 

Microsoft Office Access
Microsoft Office Access
Author: Steve Lambert 

Beginning Access 2003 VBA
Beginning Access 2003 VBA
Author: Denise M. Gosnell 

Microsoft Office Access 2003
Microsoft Office Access 2003
Author: Gary B. Shelly, Thomas J. Cashman.... 
Popular MS Access Related Websites

Microsoft Corporation 


Microsoft Access 2007 Tutorials for beginners    

Welcome to MS Tips and Tricks
Welcome to MS Tips and Tricks - You are at the right place if you need tutorials for beginners - Online Microsoft Access tutorials for beginners, covering the following categories - Databases, Customization, Table, Forms, Queries, Reports, etc.,

  Microsoft Access Tips and Tricks for beginners
 
Adding records
 
18) Open the Areas table in datasheet view.
 
19) Insert a new non-duplicated value in the AreaId field.
 
20) Insert text data in the Area field.
 
Illustration 10: insert a new record.  Click here to view larger image.
 
Deleting records
 
21) Open the FileTypes table in datasheet view.
 
22) Select an entire row.
 
23) Press the DEL key.
 
Illustration 11: Press the YES button to delete the selected record.  Click here to view larger image.
 
If there are related records in other tables, the operation will fail and an error messages will be raised.
 
Deleting records
 
24) Open the Files table in datasheet view.
 
25) Select the FileName column by clicking in his title.
 
Illustration 12: Select the Filename column.  Click here to view larger image.
 
26) Press the Ascending button to sort records in ascending order by Filename field.
 
Illustration 12: Select the Filename column.
 
Illustration 14: The records will be sorted by File Name.  Click here to view larger image.
 

 
Advertisement



Advertisement



Copyright © MS Tips and Tricks
A Division of Gurijala and Company, 2006
Home - Tips and Tricks - Resources - Links - Contact - Site Map - Privacy Policy - Email Webmaster