How Can I Get Table Design Reports Out of Access?
Data can be stored in databases by creating tables. Those tables consist of columns and rows, referred to as fields and records, respectively. There are programs that can be used to manage databases, such as Microsoft Access, which can search and summarize that data using queries, forms and reports. All of these objects within an Access database can be viewed in a default Access format, or they can be viewed in a "Design" view. If you need a report on the design structure of a table, it is possible to create one with Access so that it can be viewed in another program.
Other People Are Reading
Instructions
-
-
1
Navigate to the location of your Access database file, and then double-click on the file to open it in Access.
-
2
Click the "Tables" option in the "Objects" column on the left side of the screen.
-
-
3
Double-click the table that you wish to get out of Access.
-
4
Right click at the top of the table, and then select the "Table Design" option.
-
5
Click "File" at the top of the screen. Select the "Export" option.
-
6
Click the drop-down menu next to "Save as type." Choose the format that you would like to use to export your table design data from Access. Options include an Excel file and a text file among other assorted database formats.
-
7
Select a location from the options on the left side of the "Export table" window, and then click the "Export" button.
-
1
Tips & Warnings
You can also get report data out of Access by opening your desired report and then clicking "File" and "Export" at the top of the screen. Click the "Save as type" drop-down menu, and then select the format that you would like to use get your report data out of Access.
