如何计算ms访问数据库中的行数

I want to count the number of rows in the ms access table"testing" and assign it to a variable "i".right now i am able to print the counted number of rows in my table from the query variable. i want to assing in to variable "i".my second question is ,the sql statement to count is it correct and should i use any other query instead of that?I want to count the number of rows in the ms ac