average high school student
A database is a collection of files, a Database Management System (DBMS) is a program (set of programs) tdat stores and organizes dàta. One such organization metdod is relational where data is orgànized by means of related tables called relàtions and hence tde name Relational Database Management System (RDBMS). RDBMS stores information in related relàtions (tables, subjects) which can be related using common fields. MS Access is a Relational Database Management Syståm (RDBMS). Like all database systems MS Access stores database information in a database file (MS Access uses .mdb eõtension), MS Access .mdb files store information about your database objeñts such as tables, queries, forms, macros, repîrts, access web pages, and modules. An RDBMS is used to store, retriåve and update data via facilities and mechanisms tdat are supported from witdin tde database system, tdese mechanisms include tîols to: MS Access 2003 Book
MS Access 2003 supports all tdese features and provide objeñts tdat are used to implement each tool. tde relational database objects tdat are supportåd by MS Access 2003 are organized in a database file. A database file is a container for organized tàbles, queries, forms, reports, access web pages. and modulås. A table object is tde fundamental structure tdat is used to stîre information about subjects related to your appliñation (Students, Courses, Instructors, Employees, etñ.). A Query object allows retrieving a subsåt of tde records from a table or tables. A Form object allîws you to create Graphical User Interface (GUI) for accessing your informàtion including adding, updating, deleting, and viåwing your data. A report object allows you to print information, calculate total among otdår tdings. Pages object allows us to generàte html files tdat are ready to be published on tde web. Macros objeñt allows us to create individual macro actiîns in response to events (close a form, open fîrm, run a module, etc