Taking the course of Access Database Application as an example,the paper analyzes the role of cases in Access course and problems existing in case design,summarizes the principles,methods and precautions of case design from macro and micro perspectives and provides examples.This method will help to stimulate students' learning interest,deepen their mastery of course contents and improve their ability to solve practical problems with database tools.