Kamis, 08 September 2016

Re: [MS_AccessPros] question of terminology

Regarding grammar, most people use words beginning with capital letters far more than is needed. For example, in your phrase "Excel workbooks, Access Databases" there is no reason to capitalize databases. There is probably no reason to capitalize Database Administrator either since it is a generic title without a proper name. That's just an additional tidbit I have noticed over the years. Thanks, Jerry in Michigan

Just for fun, I ran the statement through the Word grammar checker with both singular and plural verbs. Neither version triggered an error message. That said, I will never trust the grammar checker at least until it no longer report that the sentence, "Place the book on the table." Is missing a verb.

I must beg to disagree with you. The number of the verb should agree with the primary object (or in this case, the primary complement) which is "range". It's really no different from other "container" nouns such as "cupful" or "packet". You wouldn't say "There are a packet of peanuts on the table".

I do appreciate the editorial assistance. Not to quibble but I used the singular verb because the reference is to a (single) range. In my defense I usually am more careful about the dangling participle but the quote attributed to Churchill sometimes pops into my head as "the sort of errant pedantry up with which I will not put." That said, I agree that "you can use." is definitely more readable than my original.

I see no problem with the general statement - except the atrocious English. Noun-verb disagreement, dangling participle, etc.

Therearea wide range of possible data connections, including, but not limited to other Excel workbooks, Access Databases and Data Connection (.odc) files. You may need to contact your IT services or Database Administrator for assistance in setting up a data connection source that you canconnect touse. (or to which you can connect.)

Apologies for raising an question that is specifically related to Excel at the moment but in the grand scheme of things I think it could equally relate to Access. Although I have been working in depth in Access for the past 15+ years, my experience with the workings of large organizations is incredibly lacking. Hence my question. Is the following statement accurate or are there better ways I could phrase it:

There is a wide range of possible data connections, including, but not limited to other Excel workbook, Access Databases and Data Connection (.odc) files. You may need to contact your IT services or Database Administrator for assistance in setting up a data connection source that you can connect to.

To give you a little context, I am preparing for a workshop where data connections will be touched on and I want to be prepared for the anticipated question, "What if I can't find my connection in the browsing dialogues?"

With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.