|
|
|
Amazon.com
|
 |
|
|
|
|
|
|
|
Microsoft Access 2007 Tutorials for beginners |
|
|
Welcome to MS Tips and Tricks |
Welcome to MS Tips and Tricks -
You are at the right place if you need tutorials for beginners - Online Microsoft Access tutorials for beginners, covering the following categories
- Databases, Customization, Table, Forms, Queries, Reports, etc.,
|
Microsoft Access Tips and Tricks for beginners |
|
|
| |
| You can create a data base from a blank form or from a template. Also it is possible to be gone directly to Microsoft Office Online to obtain more
data on 2007 Microsoft Office system and Office Access 2007, or, to click in and to use the menu to open an existing data base. |
| |
| Options Tape |
| |
| The Options Tape replaces the previous versions Menu Bar and toolbars. Also it provides the main commands in Office Access 2007. One of the main
advantages is that it put in a single location the tasks or the entry points used to request the visualization of menus, bars of tools, task's panels or
other components of the user interface. |
| |
| 24) When a data base is opened, the Options Tape appears in the upper edge of the Office Access 2007 main window. |
| |
|
| Illustration 8: Getting started screen. Click here to view larger image. |
| |
 |
| |
| 25) The Options Tape is composed by command's tabs (Start, Create, External Data and Data Base Tools). Each one has related
commands grouped by functionality. |
| |
| 26) The commands in the Options Tape consider the active objects. For example, if a table is opened in the Datasheet view and you click
in the Form command inside the Create Tab, Office Access 2007 creates the form based on this table. |
| |
| 27) Keyboard abbreviated methods can be used. All the abbreviated methods of the previous versions of Access remain the same ones. When a tab is
selected, the available commands in that tab can be explored. |
| |
| Run a command |
| |
|
| |
| 28) Start Access. |
| |
| 29) Select a tab in the Options Tape. The follow table lists the most representative options available in each tab. They may change according to
the selected object. |
| |
| Options Tape Tab | Most common actions |
| Applies rich text format to a memo field |
| Work with records (insert, update, delete) |
| Create | Create an empty table |
| Create a table using a template |
| Create a new table in Design View |
| Create a new form based on a table or query |
| Create a pivot table or chart |
| Create a report based on a table or query |
| Create a query, macro, module or class module |
| External Data | Import or link external data |
| Get and update data through e-mail |
| Work with off-line SharePoint lists |
| Create data extraction jobs |
| Move database components towards SharePoint Site |
| Database Tools | Start Visual Basic Editor or run a macro |
| Create and view database relationships |
| Run database documentation tool |
| Move data towards SQL Server or another Access database |
| Run the linked database tool |
| Run the add-ins administrator |
| Create or edit a VBA module |
| |
| Context cards |
| |
|
| |
| Office Access 2007 uses a new user interface's element, the Contextual Commands Card that appears according to the actual task's context. |
| |
|
| Illustration 9: Press the ALT key to see the shortcut command letter. Click here to view larger image. |
| |
|
| |
|
|
| |
|
|
|
|
|
|
|
|
|
