• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Part 1: Learning Access Fundamentals > Working with Access Databases and Tables

Chapter 4. Working with Access Databases and Tables

The traditional definition of a database is a collection of related data items stored in an organized manner. Access is unique among desktop database development applications for the PC because of its all-encompassing database file structure. A single Access .mdb file can contain data objects—tables, indexes, and queries—as well as application objects—forms, reports, macros, and Access Visual Basic for Applications (VBA) code modules. Thus, you can create a complete Access database application stored in a single .mdb file. Most Access developers use two .mdb files: one to contain data objects and one to hold application objects.

This chapter and Chapter 24, "Securing Multiuser Network Applications," explain why developers use two .mdb files. Regardless of the approach you choose, Access's all-encompassing .mdb file structure makes creating and distributing database applications simpler.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint