Overview of MS-Access 2007
- 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 ...