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

Chapter 4. Working with Access Databases... > Using Access Database Files and Tabl...

Using Access Database Files and Tables

Access has its own database file structure, similar to that used by client/server RDBMSs, and uses the .mdb extension. As discussed in this chapter's introduction, Access varies from traditional PC databases in that a single file contains all the related tables, indexes, forms, and report definitions. The .mdb file even includes the programming code that you write in VBA. You don't need to be concerned with .mdb file structure because Access handles all the details of file management for you.

Records commonly are called rows, and fields often are called columns. This book uses the terms records and fields when referring to database tables, and rows and columns for sets of records returned by queries.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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