
Introduction to data types and field properties
A field's data type is the most important property because it determines what kind of data the field can store. This article describes the data types and other field properties available in Access, …
Manage external data ranges and their properties
You can change the properties of an external data range to control data that has been imported into a worksheet through a connection to an external data source, such as a database, a Web …
How data journeys through Excel - Microsoft Support
External data range properties control the layout and format of data. All data sources have an External Data Properties dialog box, but data sources that have associated credential and …
Connection properties - Microsoft Support
Use the Connection Properties dialog box to control various settings for connections to external data sources, and to use, reuse, or switch connection files. This dialog box is often titled Query …
Design considerations for updating data - Microsoft Support
How properties impact data entry. The following table lists the properties that have the greatest impact on data entry and explains how they affect data entry.
Field or Group Properties - Microsoft Support
The Field or Group Properties dialog box is where you can view or set the properties for a field or group in your form template's data source. You can also use this dialog box to specify any …
View or change the properties for an Office file
Click the View and edit database properties link at the top of the page. In the Properties dialog box, click the tabs to select the properties that you want to view or update. Click OK. Any …
Set and edit data types in Database Model diagrams
In the Database Properties window, under Categories, click Columns. Click the cell in the Data Type column that you want to change. Click the down arrow next to the current data type and …
Refresh an external data connection in Excel - Microsoft Support
You can refresh the data for PivotTables connected to external data, such as a database (SQL Server, Oracle, Access, or other), Analysis Services cube, data feed, as well as data from a …
Introduction to tables - Microsoft Support
In an Access database, table properties are attributes of a table that affect the appearance or behavior of the table as a whole. Table properties are set in the table's property sheet, in …