【正文】 Determine the fields you need in the database Each field is a fact about a particular subject. For example, you might need to store the following facts about your customers: pany name, address, city, state, and phone number. You need to create a separate field for each of these facts. When determining which fields you need, keep these design principles in mind: ? Include all of the information you will need. ? Store information in the smallest logical parts. For example, employee names are often split into two fields, FirstName and LastName, so that it39。 陜西理工學(xué)院畢業(yè)設(shè)計 參考文獻 [1] Craig Eddy ， Timothy Buchanan. 中文 Access 2021 24 學(xué)時教程 [M].北京： 機械工業(yè)出版社 ， [2] Steven Holzner . Visual Basic 6 技術(shù)內(nèi)幕 [M].詳實翻譯組 .北京： 機械工業(yè)出版社 ， [3] 懂國平，顏志軍，萬麗 .Visual Basic 數(shù)據(jù)庫開發(fā) [M].北京： 電子 工業(yè)出版社 ， [4] 劉炳文 .Visual Basic 程序設(shè)計教程（第二版） [M] .北京 :清華大學(xué)出版社， [5] 高容芳，張曉濱，趙安科 .數(shù)據(jù)庫原理 [M].西安 :西安電子科技大學(xué)出版社， [6] 任勝兵，邢琳 .軟件工程 [M].北京 :北京郵電大學(xué)出版社， [7] VB 學(xué)習(xí)網(wǎng) . [8] [9] Hernandez, Michael J. Database Design for Mere Mortals: A Hands On Guide to Relational Database Design, Second Edition. AddisonWesley Professional. 2021. 陜西理工學(xué)院畢業(yè)設(shè)計 科技外文文獻 Introduction Of Visual Basic Program And Access A Visual Basic program is built up from standard building blocks. A solution prises one or more projects. A project in turn can contain one or more assemblies. Each assembly is piled from one or more source files. A source file provides the definition and implementation of classes, structures, modules, and interfaces, which ultimately contain all your code. FileLevel Programming Elements When you start a project or file and open the code editor, you see some code already in place and in the correct order. Any code that you write should follow the following sequence: statements statements statements and namespacelevel elements If you enter statements in a different order, pilation errors can result. A program can also contain conditional pilation statements. You can intersperse these in the source file among the statements of the preceding sequence. Option Statements Option statements establish ground rules for subsequent code, helping prevent syntax and logic errors. The Option Explicit Statement (Visual Basic) ensures that all variables are declared and spelled correctly, which reduces debugging time. The Option Strict Statement helps to minimize logic errors and data loss that can occur when you work between variables of different data types. The Option Compare Statement specifies the way strings are pared to each other, based on either their Binary or Text values. Imports Statements You can include an Imports Statement to import names defined outside your project. An Imports statement allows your code to refer to classes and other types defined within the imported namespace, without having to qualify them. You can use as many Imports statements as appropriate. Namespace Statements Namespaces help you anize and classify your programming elements for ease of grouping and accessing. You use the Namespace Statement to classify the following statements within a particular namespace.. Conditional Compilation Statements Conditional pilation statements can appear almost anywhere in your source file. They cause parts of your code to be included or excluded at pile time depending on certain conditions. You can also use them for debugging your application, because conditional code runs in debugging mode only.. NamespaceLevel Programming Elements Classes, structures, and modules contain all the code in your source file. They are namespacelevel elements, which can appear within a namespace or at the source file level. They hold the declarations of all other programming elements. Interfaces, which define element signatures but provide no implementation, also appear at module level. Class Statement (Visual Basic) Structure Statement Module Statement Interface Statement (Visual Basic) Data elements at namespace level are enumerations and delegates. ModuleLevel Programming Elements Procedures, operators, properties, and events are the only programming elements that can hold executable code (statements that perform actions at run time). They are the modulelevel elements of your program. 陜西理工學(xué)院畢業(yè)設(shè)計 Function Statement (Visual Basic) Sub Statement (Visual Basic) Declare Statement Operator Statement Property Statement Event Statement Data elements at module level are variables, constants, enumerations, and delegates. ProcedureLevel Programming Elements Most of the contents of procedurelevel elements are executable statements, which constitute the runtime code of your program. All executable code must be in some procedure (Function, Sub, Operator, Get, Set, AddHandler, RemoveHandler, RaiseEvent). For more information, see Executable Statements. Data elements at procedure level are limited to local variables and constants. The Main Procedure The Main procedure is the first code to run when your application has been loaded. Main serves as the starting point and overall control for your application. There are four varieties of Main: Sub Main() Sub Main(ByVal cmdArgs() As String) Function Main() As Integer Function Main(ByVal cmdArgs() As String) As Integer About designing a database Good database design ensures that your database is easy to maintain. You store data in tables and each table contains data about only on