Use of Data Type in MS-ACCESS:- Data type Description TEXT Store alpha numeric data (30 words) NUMBER Store numeric data. DATE & TIME Store date and time format. CURRENCY Store currency values. AUTO NUMBER Automatically generate serial format. MEMO data that exceeds 255 character. YES/NO logical values. OLE use of different application program. HYPERLINK Links to other file on a system. Query:- We use query in two views, change and analyses data in different ways. We can also use them as a source of records for forms, report etc. Queries provide two questions use data base like we can formulate simple queries that look for record in a single table. Create a Query by Design view:- Click on the Queries tab. Out of the two option design double click create query design view. Then display a dialogue box. Click the add button and click the close button. Click on table tab then select the table.
Use of Data Type in MS-ACCESS:- Data type Description TEXT Store alpha numeric data (30 words) NUMBER Store numeric data. DATE & TIME Store date and time format. CURRENCY Store currency values. AUTO NUMBER Automatically generate serial format. MEMO data that exceeds 255 character. YES/NO logical values. OLE use of different application program. HYPERLINK Links to other file on a system. Query:- We use query in two views, change and analyses data in different ways. We can also use them as a source of records for forms, report etc. Queries provide two questions use data base like we can formulate simple queries that look for record in a single table. Create a Query by Design view:- Click on the Queries tab. Out of the two option design double click create query design view. Then display a dialogue box. Click the add button and click the close button. Click on table tab then select the table.
Basic%20Computer%20Knowledge_1412691917.docx