- All this functionality is contained in the powerful features of Microsoft Access. - flow that you can ultimately reflect in the way your forms and reports are linked in your finished application. - You might also want to build custom menus for most, if not all, of the forms in the application.. - Finally, you apply the rules you will learn in the. - You can see this organization in the Customers table in the Microsoft Press Books database, as shown in Figure 3-1.. - You have to waste space in the database storing data that can easily be. - Creating additional subject tables in the Books database to ensure all fields in a table are functionally dependent on the primary key of the table.. - Now, if you've misspelled a store name, you can simply change the store name in the Stores table. - Also, instead of using the Store Name field (which might be 40 or 50 characters long) as the primary key for the Stores table, you can create a shorter Store ID field (perhaps a five-digit number) to minimize the size of the relational data you need in the Order table.. - Tables in the Microsoft Press Books sample database shown in the Relationships window.. - You can see several instances of this type of relationship in the design of the Microsoft Press Books database. - tables in a field in the "many". - You can see a similar case in the Microsoft Press Books database. - There's a similar example in the Entertainment Schedule database. - point-in-time group information in the tblContracts table.. - list of up to four database selections in the Open An Existing Database section of the dialog box. - When you start Access, you can select the Database Wizard option in the opening choices dialog box and then click OK to open the dialog box shown in Figure 4-2. - You work with all of the templates in the Database Wizard in the same way. - Selecting optional fields in the Database Wizard.. - In the next window, shown in Figure 5-4, you select one of several styles for the forms in your database. - Selecting a style for forms in the Database Wizard.. - Selecting a report style in the Database Wizard.. - In the window shown in Figure 4-6 on the next page you specify a title that will. - Naming your database in the Database Wizard.. - In the final window, you can choose to start the application immediately after the wizard finishes building it. - Database in the opening choices dialog box shown in Figure 4-1. - Select the type of spreadsheet you want to import (Excel or Lotus 1-2-3) in the Files Of Type drop-down list. - In the window that appears, you can specify whether you want to import the data to a new table or append it to an existing one. - If you choose to create a new table, you can scroll left and right to the various fields and tell the wizard which fields should be indexed in the new table.. - Click Finish in the last window to import your data. - Earlier in this lesson, in the section titled "Preparing a Spreadsheet,". - In addition, one of the rows doesn't have a value in the CEEB column. - This gives you a chance to correct the data in the table and then define the primary key yourself.. - You can correct some of the errors in the Table window in Design view. - As you saw demo in class last week, if you want to import a file that is delimited differently, you can specify different delimiters and separators in the Text Import Wizard. - Select Text Files in the Files Of Type drop-down list, and then select the folder and the name of the file you want to import. - Select ODBC Databases in the Files Of Type drop-down list. - Notice, however, that if the design of the table in the source database changes, you must relink the table to Access. - In the previous lesson, you learned about working with the data in your tables in Datasheet view. - To open a new Query window in Design view, click on the Queries tab in the Database window, and then click the New button to the right of the Query list. - then select Design View in the resulting New Query dialog box. - If you can't see the Table row in the lower part of the Query window, choose the Table Names command from the View menu.. - Each column in the grid represents one field that you'll work with in this query.. - Because you chose the Table Names command from the View menu, Access displays the table name (which is the source of the selected field) in the second row of the design grid. - The first step in building a query is to select the fields you want in the recordset. - Using the keyboard, you can tab to a column in the design grid and press Alt-down arrow to open the list of available fields. - Dragging a field to a column in the design grid.. - At the top of each field list in the upper part of the Query window (and also next to the first entry in the Field drop-down list in the design grid) is an asterisk. - This symbol is shorthand for "all fields in the table or the query.". - or a query, you don't have to define each one individually in the design grid (unless you also want to define some sorting or selection criteria for specific fields). - Tip: Another easy way to select all the fields in a table is to double-click on the title bar of the field list in the upper part of the Query window. - Then click in any of the highlighted fields and drag them to the field row in the design grid. - however, you can use the properties in the Lookup tab on the query field properties to override them.. - These attributes are inherited from the table datasheet settings that you saw in the previous chapter. - The next step is to further refine the values in the fields you want. - If you want to test for any of several values, enter the values in the Criteria row, separated by the word Or. - entertainment groups in the state of Washington and California,". - Pink And Yellow in the Criteria row for the State field. - In the next row (the first Or row), you specify OR in the State field. - You can specify a calculation on any of the fields in your table and make that calculation a new field in the recordset. - (See the examples above.) You can also create a field in a query by using arithmetic operators on fields in the underlying table to calculate a value. - Editing an expression in the Zoom window.. - Notice that total is still stored in the Orders table. - You can use a column name only from a table or query that you've specified in the FROM clause of the statement. - In many cases you can update the fields in the underlying tables when you use the JOIN syntax.. - In the ANSI SQL standard, you can also write the WHERE clause as WHERE ExtPrice >. - Each group contains identical values in the specified column(s). - (If you use relative output column numbers, the first output column is 1.) You can specify multiple columns in the ORDER BY clause. - You'll normally place the information that you want to display from the underlying table or query in the detail section in the centre of the Form window. - You'll notice that as long as this dialog box is open, you can't select any other window or menu in the application. - These controls are discussed in the next five sections.. - Access uses the relative numeric value of the control to determine the value in the underlying field. - One advantage of a combo box is that it requires space on the form for only one of the values in the underlying list.. - In some forms you see the picture in the form. - Place logo in the top part of the main switchboard form. - ¾ Bound controls are associated with a field in the data source for the form or subform. - Bound controls display and update values of the data cell in the associated field of the currently selected record. - In the Toolbars list, select the toolbar you want to reset, and click the. - Click one of the images offered, or click the Text check box and type the text you want to display in the text box. - Click and drag the PlantName field in the field list window to the upper-left corner of the form’s Detail section. - Choose File, save, and type the name frmSubplant in the Form Name text box of the Save As dialog. - Formatting in the General page of the Options dialog.. - Your choice is limited to values included in the list.. - Click the Combo Box tool in the Toolbox. - Select Plant table from the list of tables in the list. - There are two fields, Which you want display in the dropdown list.. - As mentioned in the introduction to this section, you can use calculated text boxes to display calculations based on the values of fields. - You can explore reports by examining the features of the sample reports in the Project database. - If you scroll to the bottom of the Toolbars list in the Customize dialog box, you can find an entry for the standard built-in menu bar. - If you have made changes to one of the built-in toolbars or menu bars, you can select it in the. - Click the New button in the Customize dialog box to begin defining a new toolbar.. - Select your new toolbar in the list, and click the Properties button to open the dialog box (Demonstrate in class). - In the Toolbar Properties dialog box, you can select any toolbar from the Selected Toolbar drop-down list. - Click the Commands tab in the Customize dialog box to reveal the list of available commands. - If you want to see details about a command, select it in the Commands list and click the Description button. - You can also change the button image, the label in the ScreenTip, and the button style.. - You can:. - In the Properties window, you can choose any control on the toolbar from the drop- down list at the top of the window. - After you create the additional switchboard forms that you need, you can select one in the main Switchboard Manager window and click the Edit button to begin defining actions on the form. - You'll see a window similar to the one shown in the background in Figure
Xem thử không khả dụng, vui lòng xem tại trang nguồn hoặc xem
Tóm tắt