Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Microsoft: Access Other topics FAQ

Choosing the Correct Forum

Which Access forum should I choose for my question? Why? by tlbroadbent
Posted: 19 Mar 02 (Edited 28 Feb 03)

Recently, the names of the "Microsoft: Access" forums were changed in order to clarify the purpose or focus of each forum. The number of posts in the "General" forum exceeded the number of posts in all other Access forums every week. The "General" forum is now named "Microsoft: Access  Other topics." The Other forum will appear at the end of the list of Access forums.

I recommend carefully reviewing the purposes of the various forums and selecting the forum that focuses on your issue or question. If we all endeavor to do this we will spread questions more evenly through the forums. This will make it easier to get and provide answers.

NOTE: This annoucement was orignally posted in Thread181-231806 of the "Microsoft: Access  Other topics" forum.  Members have posted several suggestions to the thread.

The current forum names and focuses are:

Forum702 - Microsoft: Access  Forms
    Focus: Questions and discussion about creating and using forms in Access, bound and unbound forms, sub-forms, objects on forms, how to navigate forms...
Forum705 - Microsoft: Access  Modules (VBA Coding)
    Focus: Questions and discussion about writing VBA code, objects, methods, properties, statements, functions...
Forum701 - Microsoft: Access  Queries and JET SQL
    Focus: Questions and discussion about creating and running queries in Access. Suitable topics can include but are not limited to:
    SYNTAX - Proper syntax for queries and the various parts of queries such as clauses, predicates, table and column names, aliases...
    JOIN - INNER, OUTER, and CROSS JOINs, capabilities and limitations
    UNION - When to use UNION queries, when to use UNION ALL...
    FUNCTION - When and how to use built-in and user-defined functions within queries
    TOTAL or AGGREGATE queries - How and when to use aggregate functions, GROUP BY...
    CROSSTAB or PIVOT queries - Creating CROSSTAB queries
    ORDER BY clause - How to use effectively, ordering by columns not in the SELECT list, ordering by functions
    SUB-QUERIES - Appropriate use of sub-queries, problems and limitations of sub-queries, derived tables...
    PASS-THROUGH QUERIES - When and how to use, capabilities and limitations, performance issues...
    PERFORMANCE - How to optimize queries, query constructs that produce poor performance, efficient query constructs...
Note: Jet SQL is the version of SQL used in Access. It differs from ANSI SQL, T-SQL and other versions of SQL.

Forum703 - Microsoft: Access  Reports
    Focus: Questions and discussion about creating and using reports in Access, creating totals and sub-totals, grouping, binding to tables or queries...
Forum700 - Microsoft: Access  Tables and Relationships
    Focus: Questions and discussion on table design, creation, structure, relationships, data types, primary and foreign keys, indexing, linking other data sources...
Forum958 - Microsoft: Access Project (ADP)
    Focus: Questions and discussion on specifically related to creation and use of Access Project files which connect to a SQL Server back-end database.
Forum181 - Microsoft: Access Other topics
Focus: Access topics that don't seem to fit in one of the other forums. These could include but are not limited to:
Security, DB corruption and repair, Internet deployment, Access options, version differences, upgrading...Please add your comments and ideas to Thread181-231806 so we can continue to work together to improve the value of the Tek-Tips forums and keep this place rockin'.

Back to Microsoft: Access Other topics FAQ Index
Back to Microsoft: Access Other topics Forum

My Archive

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close