To Get total number of records from all table and Export data  into excel in Axapta 2012 you can apply below tips.   Go to AOT(CTR+D)->Tool->Number of Records   to bring in excel select all  records then press Control +T key   You can get exact steps from below video clips.        To Reindex and synchronize table from Microsoft Dynamics Axapta You can apply below tips     System administration -Periodic-Database -SQL Administration     To get exact step see below clips.           You can subscribe to get more updates.   
Microsoft Dynamics Ax,AIF,Axapta, Enterprise portal,,Microsoft , United State,U.S., SharePoint , BI Tools, Performance Tuning, SSRS,Business Logic,Ax ERP Errors and solution,Dynamics 365 Errors Solution,Business software .