Access Objects

Access Objects

To view or hide the objects on the Navigation pane:

   You click the double down-arrows   to view objects. 

    The double down-arrows change to double up-arrows

    

    You click the double up-arrows  to hide objects.

    

    The double up-arrows change to double Down-arrows

    icon tells you the object type:

Objects

Tables	In Access, data is stored in tables. A table is a set of columns and rows, with each column referred to as a field. Each value in a field represents a single type of data. Each row of a table is referred to as a record.
Queries	You use queries to retrieve specific data from your database and to answer questions about your data. For example, you can use a query to find the names of the employees in your database who live in a particular state.
Forms	Forms give you the ability to choose the format and arrangement of fields. You can use a form to enter, edit, and display data.
Reports	Reports organize or summarize your data so you can print it or view it onscreen. You often use reports when you want to analyze your data or present your data to others.
Macros	Macros give you the ability to automate tasks. You can use a macro to add functionality to a form, report, or control.
Modules	Like macros, modules give you the ability to automate tasks and add functionality to a form, report, or control. Macros are created by choosing from a list of macro actions, whereas modules are written in Visual Basic for Applications.

•       You double-click an object to open the object. You right-click an object to view a menu

                of options. You can use the menu to do such things as open objects, rename objects, and                 delete objects.

• Objects that are open appear on tabs. Right-click a tab to view a menu of options you can perform, such as save the object, close the object, or change the view.

Change Views

      

·   A view is a way of looking at an object. For example, in Access, data is stored in         tables.

                          Two of the possible ways you can view a table are Datasheet view and Design                                   view. You can see the data contained in a table in Datasheet view. You can see the                           design of a table in Design view. When you open an object, buttons appear in the                             lower-right corner of the Access window. You can use the View button on the Home                           tab to change views, or you can click the proper button in the lower-right corner of                             the window.

If You Enjoyed This, Take 5 Seconds To Share It

• Facebook
• Twitter
• Google+
• StumbleUpon
• Digg
• Delicious
• LinkedIn
• Reddit
• Technorati