Archive for the ‘Microsoft Access’ Category

Creating table in Microsoft Access 2007.

Monday, February 4th, 2008

Open Microsoft Access 2007 as usual.
Click Blank Database in New Blank Database
Choose or select folder where your file will be saved.
Click Create button.
Close Table1 by clicking cross(X) sign.
Click Create tab, next to Home tab, then choose Table Design.
Now, you can create table as usual you do.
Use Primary Key if you want to.
When you finish creating field name, click Save icon on the upper left corner.
Type table name in Save As dialog box, then click OK.
If you do right, the result table you just created will be showed up in the Navigation Pane on
the left side.
Now you can type you data in your table.

Real database application in Microsoft Access

Tuesday, August 21st, 2007

Creating reports

As you know, Microsoft Access has many objects that can be created. Not only can Microsoft Access create reports easier, but also it can be controlled to run a certain object.
Here is a file demo of the real database application by using Microsoft Access that contains the combination of form, table, report and module.
See the picture below:

- Download ——-
Click here to download.
The file is downloaded as a zip file that you will unpack on your computer. You will need Microsoft Access 2003 or 2007 on your computer.