|
Sql is a good way to store your data. Ms access is a relational data base, in which sql can be used to store and retrieve data. The good thing about relationship is that when you delete a row of data in a table, related data in other table can be deleted automatically. Structured query language SQL: This is how to create a table and a
new access database:  Create a new data base in ms access and click on create a table.
Choose design view.
Then add the fields of your new table. Set id as primary key.
Your table has been created.
Now add some data to your table. Sql can be used to add data, retrieve and search data from a sql database. You can get more sql info from http://www.sqlcourse.com Here is a sql query to show all data fields and rows of our table. mySql="Select * from mytable;" If you want to show only the row where name is Jhon then: mySql="Select * from mytable where name='Jhon';" To search any part of a field. mySql="Select * from mytable where address like '%South%'; " |
