October 1997
Intermediate to advanced
1312 pages
38h 56m
English
Users of decision-support applications, especially managers, aren't likely to be able or want to use Access's graphical Query Design window. Instead, most users prefer to pick criteria (SELECT query WHERE clause elements) from one or more lists of available options. One primary advantage of offering users a set of choices to construct a query is the ability to prevent execution of ad hoc queries that return an excessive number of rows. Accidentally returning thousands of rows or—even worse—a Cartesian product of a million rows or more can bring a multiuser application or the entire network to its knees. Network and database administrators call such events queries from hell.
Combo boxes are the better ...
Read now
Unlock full access