Microsoft Access is the database program which is incorporated with Microsoft’s Office suite. It is not as intuitive and user-friendly as the other Office programs, but Access offers a wide range of powerful features for creating databases and extracting data from them. Learning some basic steps will easily help you to begin to make databases, tables, reports, forms and queries and so on. Once you become familiar with the program, you can anytime start learning the advanced techniques, such as creating mail merges and other techniques.
Software developers and data architects can use Microsoft Access to develop application software and non-programmer “power users” can use it to build simple applications. It simply supports some object-oriented techniques but at the same time falls short of being a fully object-oriented development tool. It is mainly targeted for the information worker market, and is the natural progression for managing data when the need for a relational database arises or after reaching the limits of Microsoft Excel. Microsoft Access is basically used by programmers and non-programmers to create their own database solutions. Microsoft Access tables support a variety of standard field types, indices, and referential integrity. It also includes a very intuitive query interface, forms to display and enter data, and reports for printing
With Microsoft access you can use a Make-Table action query to create a new table from all or part of the data in one or many tables. For example, if you want to use records from various tables to create a new table that will be exported to a different database. These instructions apply only to MS Access 97.these steps are simple and really very easy to follow. The steps are as follows:
First you need to Open the database window by using the F11 key, and then click on the Query tab.
Now click on the new icon, then on the Design View. After this click OK
Now you need to create a query with the tables or queries you want to use to create the new table. Next step is to Select Make Table from the Query menu.
You need to Use the Table Name box to name the table that you want to create in Microsoft access.
Now you have to Use the Current Database or Another Database to indicate where you are willing to put the new table. And then click on the icon OK
After performing all the above steps drag the fields that you want to use from the field list into the design grid.
You have to Type your criteria (for instance all dates after 1/1/11) in the Criteria cell.
You can Preview the new table by switching to Datasheet view. And then Return to Design view and create the new table by clicking Run on the toolbar.