Skip to Main Content
Access 2002 Programming by Example
book

Access 2002 Programming by Example

by Bob Villareal
January 2002
Beginner content levelBeginner
576 pages
13h 23m
English
Que
Content preview from Access 2002 Programming by Example

Building an Access 2002 Table

The following steps lead you through building this table from scratch using different quality checks and data types:

1.
Open the Claims.mdb database from your AccessByExample folder.
2.
Under Objects, click Tables; then click New to open the New Table dialog box.
3.
Click the second option, Design View, when the next window appears, and then click OK to open table Design view.
4.
After typing ClaimNumber, tab to the Data Type column. Notice that a down arrow automatically appears. You can choose any of the data types after clicking the down arrow. In this case, accept the default.
5.
Click the Primary Key button to make it a primary key and then click on Field Size in the lower part of the window (or press ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Access 2003 Programming by Example with VBA, XML, and ASP

Access 2003 Programming by Example with VBA, XML, and ASP

Julitta Korol
Microsoft® Access® 2010 Programmer's Reference

Microsoft® Access® 2010 Programmer's Reference

Teresa Hennig, Rob Cooper, Geoffrey L. Griffith, Jerry Dennison

Publisher Resources

ISBN: 0789725940Purchase book