![]() ![]() Viewing the Table in Design View Click the View button arrow (Table Tools Fields tab | Views group) CY LinĬlosing the Table Click the Close button for the open table to close the table CY LinĪdding Records to a Table Right-click the table in the Navigation Pane Click the Shutter Bar Open/Close Button to close the Navigation Pane Type the desired values in each field, pressing the TAB key to move to the next field CY Lin Saving a Table Click the Save button on the Quick Access Toolbar Type the desired file name Click the OK button CY Lin Click the white space a second time to select the field Change the field size, if necessary CY Lin ![]() Modifying the Primary Key Click the Field Size text box (Table Tools Fields tab | Properties group) to select the current field size, and type the new field size Click the Name & Caption button (Table Tools Fields tab | Properties group) Click the Caption text box, and then type the desired caption Click the Description text box, and then type the desired description CY Linĭefining the Remaining Fields Click the Click to Add column heading Click the desired data type Enter the desired field name Click the white space below the field name to complete the change of the name. ![]() Modifying the Primary Key Right-click the column heading for the desired primary key field (the existing ID field) Type the new desired name for the field Click the white space immediately below the field name to complete the addition of the field Click the Data Type box arrow (Table Tools Fields tab | Formatting group) Click the desired data type CY Lin Do not press the ENTER key after typing the file name Navigate to the desired save location Click the OK button Click the Create button in the right pane of the New gallery CY Lin General Project Guidelines Identify the tables Determine the primary keys Determine the additional fields Determine relationships between the tables Determine data types for the fields Identify and remove any unwanted redundancy Determine a storage location for the database Determine additional properties for fields Determine the best method for distributing the database objects CY LinĬreating a Database With a USB flash drive connected, ensure the New tab is selected in the Backstage view and that Blank database is selected in the New gallery Click the Browse button in the right pane to display the File New Database dialog box Type the desired file namein the File New Database dialog box. Create tables in Datasheet and Design views.Describe the features of the Access window.Design a database to satisfy requirements.MicrosoftAccess 2010 Chapter 1 Databases and Database Objects: An Introduction ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |