O'Reilly logo

Concepts of Database Management System by Shefali Naik

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required