CHAPTER 11

Overview of MS-Access 2007

CHAPTER OBJECTIVES
  • How to use MS-Access.
  • Knowing elements of MS-Access.
  • Managing data using form.
  • Displaying data using reports.
  • Designing and writing queries.
  • Creating macros.
  • Creating switchboard.
11.1 MS-ACCESS AS AN RDBMS

MS-Access is a Relational Database Management System (RDBMS) which allows us to define and manage relationships between tables using primary and foreign keys.

Using MS-Access, we can write queries, create forms to manage data, create reports, write macros to execute list of instructions in a sequence, etc. These elements are created within Access database files.

We can use various controls to design forms and reports. The queries, tables, forms and reports are imported and exported ...

Get Concepts of Database Management System now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.