Sentence view Universal Dependencies - English - LinES Language English Project LinES Corpus Part dev
Text: Transcription Written form - Colors
showing 1 - 100 of 1032 • next
When a user connects to the SQL Server database through a Microsoft Access project , the connection is enabled through a Windows NT user account .
s-1
en_lines-ud-dev-doc1-3177
When a user connects to the SQL Server database through a Microsoft Access project, the connection is enabled through a Windows NT user account.
SQL Server verifies that the account name and password were validated when the user logged on to the system and grants access to the database , without requiring a separate logon name or password .
s-2
en_lines-ud-dev-doc1-3178
SQL Server verifies that the account name and password were validated when the user logged on to the system and grants access to the database, without requiring a separate logon name or password.
With the default installation of the Microsoft SQL Server 2000 Desktop Engine with integrated security , the user must be a member of the administrator group for the machine on which the Access project resides .
s-3
en_lines-ud-dev-doc1-3179
With the default installation of the Microsoft SQL Server 2000 Desktop Engine with integrated security, the user must be a member of the administrator group for the machine on which the Access project resides.
This makes it difficult to allow other users to gain access to the Access project .
s-4
en_lines-ud-dev-doc1-3180
This makes it difficult to allow other users to gain access to the Access project.
There is currently no simple way for the system administrator to create new logon accounts to the locally installed SQL Server database except by using SQL Tools or Transact-SQL ( TSQL ) commands .
s-5
en_lines-ud-dev-doc1-3181
There is currently no simple way for the system administrator to create new logon accounts to the locally installed SQL Server database except by using SQL Tools or Transact-SQL (TSQL) commands.
See the http://officeupdate.microsoft.com/ , Microsoft Developer Network Web site for more information on TSQL .
s-6
en_lines-ud-dev-doc1-3182
See the http:
officeupdate.microsoft.com/, Microsoft Developer Network Web site for more information on TSQL.
You can change the security mode for accessing the SQL Server database on a computer running Windows NT .
s-7
en_lines-ud-dev-doc1-3183
You can change the security mode for accessing the SQL Server database on a computer running Windows NT.
By setting properties from the View menu , you can enable mixed mode security .
s-8
en_lines-ud-dev-doc1-3184
By setting properties from the View menu, you can enable mixed mode security.
Using the default SA account , users can access the SQL Server database through the Access project without any additional security requirements .
s-9
en_lines-ud-dev-doc1-3185
Using the default SA account, users can access the SQL Server database through the Access project without any additional security requirements.
The administrator of the SQL Server can also add additional security by changing the default SA account password .
s-10
en_lines-ud-dev-doc1-3186
The administrator of the SQL Server can also add additional security by changing the default SA account password.
In order for the Enable system administrator ( SA ) user name check box to be enabled , the following must be true .
s-11
en_lines-ud-dev-doc1-3187
In order for the Enable system administrator (SA) user name check box to be enabled, the following must be true.
The Access project must be connected to a SQL Server 7.0 ( or later ) database or a Microsoft SQL Server 2000 Desktop Engine .
s-12
en_lines-ud-dev-doc1-3188
The Access project must be connected to a SQL Server 7.0 (or later) database or a Microsoft SQL Server 2000 Desktop Engine.
The SQL Server database must be running on a Windows NT platform .
s-13
en_lines-ud-dev-doc1-3189
The SQL Server database must be running on a Windows NT platform.
The SQL Server must be running on the same computer as the Access project .
s-14
en_lines-ud-dev-doc1-3190
The SQL Server must be running on the same computer as the Access project.
The current Windows NT user must be an Administrator for the computer .
s-15
en_lines-ud-dev-doc1-3191
The current Windows NT user must be an Administrator for the computer.
The current SQL Server user must be a member of the System Administrator role .
s-16
en_lines-ud-dev-doc1-3192
The current SQL Server user must be a member of the System Administrator role.
After changing the security mode , it is strongly recommended that the SA password be changed by using the Set Login Password command ( on the Tools menu , point to Security ) .
s-17
en_lines-ud-dev-doc1-3193
After changing the security mode, it is strongly recommended that the SA password be changed by using the Set Login Password command (on the Tools menu, point to Security).
Some of the hyperlinks in this topic go to the Web .
s-18
en_lines-ud-dev-doc1-3194
Some of the hyperlinks in this topic go to the Web.
About XML data and Access
s-19
en_lines-ud-dev-doc1-3195
About XML data and Access
Extensible Markup Language ( XML ) is the standard language for describing and delivering data on the Web , just as Hypertext Markup Language ( HTML ) is the standard language for creating and displaying Web pages .
s-20
en_lines-ud-dev-doc1-3196
Extensible Markup Language (XML) is the standard language for describing and delivering data on the Web, just as Hypertext Markup Language (HTML) is the standard language for creating and displaying Web pages.
Microsoft Access provides ways to both import and export XML data as well as transform the data to and from other formats using XML related files .
s-21
en_lines-ud-dev-doc1-3197
Microsoft Access provides ways to both import and export XML data as well as transform the data to and from other formats using XML related files.
About XML
s-22
en_lines-ud-dev-doc1-3198
About XML
Moving information across the Internet and between software applications has always been difficult due to differences in data formats and proprietary structures .
s-23
en_lines-ud-dev-doc1-3199
Moving information across the Internet and between software applications has always been difficult due to differences in data formats and proprietary structures.
HTML , while well suited for providing text and image display information for Web browsers , is limited in its ability to define data and data structures .
s-24
en_lines-ud-dev-doc1-3200
HTML, while well suited for providing text and image display information for Web browsers, is limited in its ability to define data and data structures.
HTML describes how a Web page should look , whereas XML defines the data and describes how the data should be structured .
s-25
en_lines-ud-dev-doc1-3201
HTML describes how a Web page should look, whereas XML defines the data and describes how the data should be structured.
XML is a data interchange format in that it allows you to exchange data between dissimilar systems or applications .
s-26
en_lines-ud-dev-doc1-3202
XML is a data interchange format in that it allows you to exchange data between dissimilar systems or applications.
XML separates the data from the presentation so that the same XML data can be presented in multiple ways by using different presentation files .
s-27
en_lines-ud-dev-doc1-3203
XML separates the data from the presentation so that the same XML data can be presented in multiple ways by using different presentation files.
XML is a standards-based protocol that is governed by the World Wide Web Consortium ( W3C ) .
s-28
en_lines-ud-dev-doc1-3204
XML is a standards-based protocol that is governed by the World Wide Web Consortium (W3C).
The XML protocol is a set of rules , guidelines , and conventions for designing data formats and structures , in a way that produces files that are easy to generate and easily read by different computers and applications .
s-29
en_lines-ud-dev-doc1-3205
The XML protocol is a set of rules, guidelines, and conventions for designing data formats and structures, in a way that produces files that are easy to generate and easily read by different computers and applications.
In addition , XML defined structures are unambiguous ; that is , they are self-describing and platform-independent .
s-30
en_lines-ud-dev-doc1-3206
In addition, XML defined structures are unambiguous; that is, they are self-describing and platform-independent.
Like HTML , XML makes use of tags and attributes , but while HTML specifies what each tag and attribute means ( and thus how the data between them will look in a browser ) , XML uses the tags only to delimit pieces of data , and leaves the interpretation of the data completely to the application that reads it .
s-31
en_lines-ud-dev-doc1-3207
Like HTML, XML makes use of tags and attributes, but while HTML specifies what each tag and attribute means (and thus how the data between them will look in a browser), XML uses the tags only to delimit pieces of data, and leaves the interpretation of the data completely to the application that reads it.
Additional information about XML can be found on the web site .
s-32
en_lines-ud-dev-doc1-3208
Additional information about XML can be found on the web site.
About importing XML data
s-33
en_lines-ud-dev-doc1-3209
About importing XML data
Access provides choices for using data from many external sources .
s-34
en_lines-ud-dev-doc1-3210
Access provides choices for using data from many external sources.
XML makes it easier to transform the data from almost any external application for use by Access .
s-35
en_lines-ud-dev-doc1-3211
XML makes it easier to transform the data from almost any external application for use by Access.
You can :
s-36
en_lines-ud-dev-doc1-3212
You can:
Use an Extensible Stylesheet Language Transformation ( XSLT ) file to transform the data into an Access data format .
s-37
en_lines-ud-dev-doc1-3213
Use an Extensible Stylesheet Language Transformation (XSLT) file to transform the data into an Access data format.
You can use the Import command ( point to Get External Data on the File menu ) to import XML data files into Access .
s-38
en_lines-ud-dev-doc1-3214
You can use the Import command (point to Get External Data on the File menu) to import XML data files into Access.
This command displays the Import dialog box so that you can select an XML document as well as a schema , which describes the structure of the data .
s-39
en_lines-ud-dev-doc1-3215
This command displays the Import dialog box so that you can select an XML document as well as a schema, which describes the structure of the data.
You can only import a single document at a time into Access .
s-40
en_lines-ud-dev-doc1-3216
You can only import a single document at a time into Access.
The data must be in a format that Access recognizes , either in a native format or through the use of a schema .
s-41
en_lines-ud-dev-doc1-3217
The data must be in a format that Access recognizes, either in a native format or through the use of a schema.
Note that when importing XML data , you can not choose a subset of the XML document ; the entire file has to be imported .
s-42
en_lines-ud-dev-doc1-3218
Note that when importing XML data, you can not choose a subset of the XML document; the entire file has to be imported.
You can transform the native XML data into a specific Access format by choosing from the options in the Import XML dialog box .
s-43
en_lines-ud-dev-doc1-3219
You can transform the native XML data into a specific Access format by choosing from the options in the Import XML dialog box.
You can also specify whether to overwrite any existing tables or append to existing data .
s-44
en_lines-ud-dev-doc1-3220
You can also specify whether to overwrite any existing tables or append to existing data.
What are XML schemas
s-45
en_lines-ud-dev-doc1-3221
What are XML schemas
You use XML schemas to describe the structure of data in a common format that customers , other Web browsers , and any number of XML-enabled software programs can recognize .
s-46
en_lines-ud-dev-doc1-3222
You use XML schemas to describe the structure of data in a common format that customers, other Web browsers, and any number of XML-enabled software programs can recognize.
Specifically , schemas define the rules of an XML data document , including element names and data types , which elements can appear in combination , and which attributes are available for each element .
s-47
en_lines-ud-dev-doc1-3223
Specifically, schemas define the rules of an XML data document, including element names and data types, which elements can appear in combination, and which attributes are available for each element.
Schemas provide a model for an XML data document which defines the arrangement of tags and text within all documents referencing the schema .
s-48
en_lines-ud-dev-doc1-3224
Schemas provide a model for an XML data document which defines the arrangement of tags and text within all documents referencing the schema.
Access supports the XML Schema standard ( XSD ) .
s-49
en_lines-ud-dev-doc1-3225
Access supports the XML Schema standard (XSD).
XSD is a proposed World Wide Web Consortium ( W3C ) standard designed as a basic infrastructure for describing the type and structure of XML documents .
s-50
en_lines-ud-dev-doc1-3226
XSD is a proposed World Wide Web Consortium (W3C) standard designed as a basic infrastructure for describing the type and structure of XML documents.
By using a schema , you can ensure that any XML document that is used to import data into Access or export from Access to another format contains specific data and conforms to a defined structure .
s-51
en_lines-ud-dev-doc1-3227
By using a schema, you can ensure that any XML document that is used to import data into Access or export from Access to another format contains specific data and conforms to a defined structure.
You can also provide the schema to other businesses and applications so that they know how they should structure any data they provide to you and they , in turn , can provide their schema to you .
s-52
en_lines-ud-dev-doc1-3228
You can also provide the schema to other businesses and applications so that they know how they should structure any data they provide to you and they, in turn, can provide their schema to you.
Displaying XML data
s-53
en_lines-ud-dev-doc1-3229
Displaying XML data
XML syntax ( the tags and their placement in a document ) defines and describes the data in an XML document but doesn't indicate how the data should be displayed .
s-54
en_lines-ud-dev-doc1-3230
XML syntax (the tags and their placement in a document) defines and describes the data in an XML document but doesn't indicate how the data should be displayed.
In earlier applications and in some current uses , Cascading Style Sheets ( CSS ) were used to tell the browser how to display the XML data .
s-55
en_lines-ud-dev-doc1-3231
In earlier applications and in some current uses, Cascading Style Sheets (CSS) were used to tell the browser how to display the XML data.
However , a CSS isn't always a good choice because they are written in a specialized language which means that the developer has to use another language in order to write , modify , or understand the structure of the style sheet .
s-56
en_lines-ud-dev-doc1-3232
However, a CSS isn't always a good choice because they are written in a specialized language which means that the developer has to use another language in order to write, modify, or understand the structure of the style sheet.
A CSS merely allows you to specify the formatting of each XML element without much control over the output .
s-57
en_lines-ud-dev-doc1-3233
A CSS merely allows you to specify the formatting of each XML element without much control over the output.
On the other hand , an Extensible Stylesheet Language ( XSL ) style sheet is considerably more flexible than a CSS file .
s-58
en_lines-ud-dev-doc1-3234
On the other hand, an Extensible Stylesheet Language (XSL) style sheet is considerably more flexible than a CSS file.
It allows you to precisely select the data that will be displayed , to specify the order or arrangement of the data , and to modify or add information .
s-59
en_lines-ud-dev-doc1-3235
It allows you to precisely select the data that will be displayed, to specify the order or arrangement of the data, and to modify or add information.
You can apply a filter to a row or column field to show the top or bottom n items based on a total .
s-60
en_lines-ud-dev-doc1-3236
You can apply a filter to a row or column field to show the top or bottom n items based on a total.
For example , you can filter for the top or bottom 25 % of salespeople based on the number of orders handled .
s-61
en_lines-ud-dev-doc1-3237
For example, you can filter for the top or bottom 25 % of salespeople based on the number of orders handled.
Combining multiple filters
s-62
en_lines-ud-dev-doc1-3238
Combining multiple filters
Filters are additive .
s-63
en_lines-ud-dev-doc1-3239
Filters are additive.
Each filter you apply is added to the ones you already have in effect .
s-64
en_lines-ud-dev-doc1-3240
Each filter you apply is added to the ones you already have in effect.
However , when you apply a filter by selection , the conditional filter already applied on the field is removed before the filter by selection is applied .
s-65
en_lines-ud-dev-doc1-3241
However, when you apply a filter by selection, the conditional filter already applied on the field is removed before the filter by selection is applied.
Conditional filters are independent of each other .
s-66
en_lines-ud-dev-doc1-3242
Conditional filters are independent of each other.
The result of one conditional filter does not affect the result of another .
s-67
en_lines-ud-dev-doc1-3243
The result of one conditional filter does not affect the result of another.
An autofilter is always applied before a conditional filter , regardless of the order in which you applied them .
s-68
en_lines-ud-dev-doc1-3244
An autofilter is always applied before a conditional filter, regardless of the order in which you applied them.
For example , if you set a conditional filter to show the top two cities based on sales , followed by an autofilter on the ShippedCity field to include only five cities , the PivotTable view will show the top two of the five cities you selected .
s-69
en_lines-ud-dev-doc1-3245
For example, if you set a conditional filter to show the top two cities based on sales, followed by an autofilter on the ShippedCity field to include only five cities, the PivotTable view will show the top two of the five cities you selected.
Removing and reapplying a filter
s-70
en_lines-ud-dev-doc1-3246
Removing and reapplying a filter
However , the filter settings are retained , so that when you turn autofiltering back on , the data that was previously displayed or hidden is again displayed or hidden .
s-71
en_lines-ud-dev-doc1-3247
However, the filter settings are retained, so that when you turn autofiltering back on, the data that was previously displayed or hidden is again displayed or hidden.
Filter settings are retained when you move fields to change the layout .
s-72
en_lines-ud-dev-doc1-3248
Filter settings are retained when you move fields to change the layout.
Also , if you remove a field and later add the field back to the layout , the same items are again hidden .
s-73
en_lines-ud-dev-doc1-3249
Also, if you remove a field and later add the field back to the layout, the same items are again hidden.
If you don't want to retain your filter selections , make sure the AutoFilter button is not selected before you start selecting items to filter .
s-74
en_lines-ud-dev-doc1-3250
If you don't want to retain your filter selections, make sure the AutoFilter button is not selected before you start selecting items to filter.
If the button is not selected , selecting new items to filter automatically turns filtering on and removes your former filter settings .
s-75
en_lines-ud-dev-doc1-3251
If the button is not selected, selecting new items to filter automatically turns filtering on and removes your former filter settings.
Identifying filters that are currently in effect
s-76
en_lines-ud-dev-doc1-3252
Identifying filters that are currently in effect
When items in a field are hidden by autofiltering or filter by selection , the drop-down arrow Field arrow in the field label is blue .
s-77
en_lines-ud-dev-doc1-3253
When items in a field are hidden by autofiltering or filter by selection, the drop-down arrow Field arrow in the field label is blue.
Click the blue arrow to see the filter that is in effect .
s-78
en_lines-ud-dev-doc1-3254
Click the blue arrow to see the filter that is in effect.
When items in a field are hidden by conditional filtering , a funnel appears to the left of the drop-down arrow Field arrow .
s-79
en_lines-ud-dev-doc1-3255
When items in a field are hidden by conditional filtering, a funnel appears to the left of the drop-down arrow Field arrow.
You can get more information about the current filter in the Properties dialog box .
s-80
en_lines-ud-dev-doc1-3256
You can get more information about the current filter in the Properties dialog box.
Effects of filtering on calculations
s-81
en_lines-ud-dev-doc1-3257
Effects of filtering on calculations
Totals can include only the displayed data , or both visible and hidden data .
s-82
en_lines-ud-dev-doc1-3258
Totals can include only the displayed data, or both visible and hidden data.
About customizing a control
s-83
en_lines-ud-dev-doc1-3259
About customizing a control
In Design view of a form , report , or data access page , you can format a control in the following ways :
s-84
en_lines-ud-dev-doc1-3260
In Design view of a form, report, or data access page, you can format a control in the following ways:
Size .
s-85
en_lines-ud-dev-doc1-3261
Size.
You can resize a control by using the sizing handles , or you can resize a control to the height or width of another control .
s-86
en_lines-ud-dev-doc1-3262
You can resize a control by using the sizing handles, or you can resize a control to the height or width of another control.
When you are in Design view of a form or report , you can use the ruler to help you resize controls .
s-87
en_lines-ud-dev-doc1-3263
When you are in Design view of a form or report, you can use the ruler to help you resize controls.
The width of the ruler's unit of measure is based on the regional settings in Microsoft Windows Control Panel .
s-88
en_lines-ud-dev-doc1-3264
The width of the ruler's unit of measure is based on the regional settings in Microsoft Windows Control Panel.
Color , transparency , and special effects .
s-89
en_lines-ud-dev-doc1-3265
Color, transparency, and special effects.
You can change the color of a control or make it transparent .
s-90
en_lines-ud-dev-doc1-3266
You can change the color of a control or make it transparent.
You can also emphasize the appearance of a control by using special effects .
s-91
en_lines-ud-dev-doc1-3267
You can also emphasize the appearance of a control by using special effects.
For example , you can specify that a control is raised , sunken , or etched .
s-92
en_lines-ud-dev-doc1-3268
For example, you can specify that a control is raised, sunken, or etched.
On a form or report , you can also specify that a control is shadowed or chiseled .
s-93
en_lines-ud-dev-doc1-3269
On a form or report, you can also specify that a control is shadowed or chiseled.
Borders .
s-94
en_lines-ud-dev-doc1-3270
Borders.
You can set the color and width of borders of controls .
s-95
en_lines-ud-dev-doc1-3271
You can set the color and width of borders of controls.
Also , you can set the line style of borders . For example , you can specify that a border consists of dashes or dots .
s-96
en_lines-ud-dev-doc1-3272
Also, you can set the line style of borders. For example, you can specify that a border consists of dashes or dots.
Appearance of text .
s-97
en_lines-ud-dev-doc1-3273
Appearance of text.
You can specify the font and font size for text in a control .
s-98
en_lines-ud-dev-doc1-3274
You can specify the font and font size for text in a control.
Also , you can make the text in a control bold , italic , or underlined .
s-99
en_lines-ud-dev-doc1-3275
Also, you can make the text in a control bold, italic, or underlined.
Position .
s-100
en_lines-ud-dev-doc1-3276
Position.
Edit as list • Text view • Dependency trees