Using the student data files from Pearson Higher Education that go along with the GO! Microsoft Access book. Conditional queries:   Using Is Null to find missing data:   Using sum to find total scholarship funds by department.   Using crosstabs:   Requiring a major be entered to complete the search.