Worlds best microsoft office tutorials content. Find anything about microsoft office tutorials needs on this site.
Create Query Form Or Report In Access. Select Create Report Wizard. In the Tables tab on the Show Table dialog box double-click the tblEmployees table and then close the dialog box.
Open the form or report in Design view. You can make design changes like adjusting the size of the text boxes to fit the data if necessary. Access automatically generates a report based on the table or query selected.
In the property sheet on the Data tab click the Record Source property box.
Open the form or report in Design view. In the Navigation Pane click the table or query on which you want to base the report. Select Create Report Wizard. If you decide to create it by hand select TableQuery for the RowSourceType property and tblMusicType for the RowSource not the ControlSource.