Microsoft Access in Office 2003 is the Relation Data Base Page of Microsoft Office. In this, data are collected in the form of arrays.
You can see this data on the screen. Can be sort in any order. And can print. To fill the data, you can be prepare print forms on the screen as well as paper.
You can get information on the basis of give Query from the fill data. Reports, charts, etc. Can also be prepared for various uses based on the data. You can create multiple tables in the same database. And you can organize them in such a way.
That they can be brought together by selecting information from multiple tables when needed. And the desired report can be extracted from them.
Microsoft Access Control in Microsoft Access in Office 2003
Apart from these, many facilities are available in Microsoft Access in Office 2003. Which you will study. The database is very useful in our daily life.
Whether it is a person or businessman, for example, use the address diary to see a friend’s address or Phone No. In which the names of all the addresses are written in the form of a letter garland.
The diary of addresses is a database only. With the help of Microsoft Access in Office 2003, you can easily create a database in a computer. And use them. A lot of work of a trading company can be done easily by the database.
For example customers and suppliers are inform of transactions, inventory of goods and stock maintenance expenses, bills account etc. From this section, we are tell about the methods of constructing and using the database.
Working in Microsoft Access in Office 2003
You do not need any special sponsorship to install Microsoft Access in Office 2003. When you are install version of Microsoft Office in your computer. While choosing a component there? You must choose Microsoft Access in Office 2003.
As a default setting, Microsoft Access in Office 2003 is always selecte. With this, the installation of the office as well. As the installation of the Microsoft Access in Office 2003 will be done in your computer.
Data Type in Microsoft Access in Office 2003
When Microsoft Access in Office 2003 data type file and table is create? This software allows you to use many types of data types in this table. This data type is as follows.
1. Text Data Type :- In Microsoft Access, you define a text type to a field in a table. So in this you can use both words and numbers.
This field cannot be use for calculation. The maximum width of this field can be 255 characters.
2. Memo Data Type :- In this kind of field, you can only store large numbers of text and numbers. It’s also cannot be use for calculation. It can store 65535 characters.
3. Number Data Type :- Let’s use this field to calculate. And numbers can be writte in it. The maximum width of this field is 8 byte.
4. Date / Time :- The maximum width of this field of the table is 8 byte. The time and date can be store from 100 years to 9999.
5. Currency Data Type :- Numeric data is store in such data type. And use it in calculations. With this one can use decimal from 1 to 4 places.
Database File in Microsoft Access in Office 2003
6. Auto Number :- In a normal case, the size of such a field is 4 byte. By this, sequential or random number is use with an increment of 1 digit. This field cannot be update.
7. Yes / No :- This field is of 1 bit. And use it for logical tasks. It uses the on / off, true / false, and yes / no positions.
8. OLE Object :- In this type of field, you can store objects up to 1 gigabyte. In this, you can use worksheet in excel, store document file in Word, image file, binary data and file of sound in Microsoft Access in Office 2003 table.
9. Hyperlink :- In this Microsoft Access kind of field, we store the hyperlink address used for internet. Addresses up to 6144 characters can be write in it.
10. Creating a new data base file :- To start a new work in Microsoft Access in Office 2003. You open its file menu. The file menu will open up on the screen like this.
In this you will get new command. Click on it. As soon as you click. You can start a new task on the screen.
Apart from this, you will see that the task bar has been added on the right side of me. It first has a part called open a file. And on the second number is the new part.