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 the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
