Features of Microsoft® Access®
Microsoft Office Access 2003 provides an effective set of tools by which you can easily start tracking, reporting and sharing information. Further, you can speedily create attractive and functional tracking applications by changing one of several predefined templates, changing an existing database or producing a new database.
The programmers and non-programmers use Microsoft Access 2003 to create their own database solutions. The tables in Microsoft Access 2003 support different types of standard field types, indices and referential integrity. You can also display and enter data in variety of forms and create reports for printing. Here are some features of Microsoft Access:
A database is records of files, in which you store data, which includes all the important objects related to the stored data. It also includes all the objects, which you describe to automatize use of your data. In other database systems, the term database is only used to point those files, in which you store data.
Table is an object, which helps you in defining and storing data. The information about a specific subject is contained in each table. Table stores different kinds of data in fields or columns. For example, you can store information about a specific instance of the subject in a row. The tables in Microsoft® Access® 2003 support different types of standard field types, indices and referential integrity. You can also display and enter data in variety of forms and create reports for printing.
With the help of Query, you can custom view data from one or more tables. You can also write SQL statements to make your queries and you can describe queries to choose, update, insert or delete data. In one or more existing tables, you can also describe queries that make new tables from data.
It is a feature of Microsoft Access, which is basically designed for data input or display of application execution. In Microsoft Access, you use forms to change the presentation of data that your application educes for queries or tables.
- The title bar has the name of the program. On the extreme right there are buttons to minimize, maximize/restore and close.
- All the Microsoft Access 2003 commands are located in the Menu Bar and are assembled in drop down menus. To insert different elements, you have to click on Insert.
- You can run all the tasks from these menus but you can run more regular things quickly from the tool bar.