Page 25 - ModularV1.1 _c8_flipbook
P. 25

Tech


                    Funda
                                   To save the changes in the database, press Ctrl + S keys or choose the Save
                                   option from the File tab.


                 Clickipedia




                   Templates are the inbuilt format of databases that focus on the specific task. These can be
                   downloaded or used instantly.


                     TYPES OF VIEWS IN MS ACCESS

                 There are two types of views in MS Access: Datasheet view and Design view. We can switch
                 between these two views by clicking on the View command under the Views group on the Home

                 tab. We can also use the Design View and Datasheet View buttons located on the right-hand side
                 of the Status bar to switch between two views.
                 Datasheet View

                 Datasheet view is the default view of the table. It shows all the fields and records as entered by
                 the user. In this view, you can edit the content of the table.






















                                                            Datasheet view

                 Design View


                 In Design view, the records are not visible. You can only see the field names along with their data
                 types. You can add or delete a field name. The Design view window is divided into two parts:

                    Field Grid Pane: It is used to define the field names and their data types.
                    Field Properties Pane: It is used to set the properties for the fields defined in the table.






                                                                                   Introduction to MS Access 2010  23
   20   21   22   23   24   25   26   27   28   29   30