The following is a design method that has been specifically modified for use with access. The method is a left-to-right method, starting with the overall system design and ultimately the form design, which contains 5 steps.
Overall system design → report design (output) → basic data design → table design → user interface design
5 Step design process. This design method is especially suitable for Access databases
These 5 design steps and the database system shown in the example in this book illustrate a lot about access and provide a solid foundation for creating database applications that include tables, queries, forms, data pages, reports, macros, and simple VBA (Visual Basic for applications) module.
The time spent on each step depends entirely on the database environment being built. For example, sometimes a user provides a sample of a report that needs to be printed in an Access database, and the data source on the report is obvious, so that the report is designed to take only a minute. In some cases, especially when the user's needs are complex, or the application-supported business processes require a lot of research, it may take a few days to complete the first step.
As you step through each step of the design process, you always need to focus on design issues on output and input. Although you can see the implementation components of the system (cars, buyers, sellers, and transactions), it is important to remember that the focus of this chapter is on how to design each step. When you look at the design of an access autoauctions system, you should be aware of its design process, not the actual system.
want to know more Database Tutorials knowledge can be landed on E mentor Network.
This article is from the "Add Language" blog, please make sure to keep this source http://yuguotianqing.blog.51cto.com/9292883/1563827
To design an Access database process step