Information about toolbar & ribbons

• The standard ribbon appears in the Access window when open a database.

Ribbon

• Quick Access toolbar: The Quick Access toolbar contains the three command buttons (Save, Undo, and Redo). People use these commands more frequently.

• Navigation Pane: This navigation pane shows the objects that part of your database and it lets you manipulate them. Access database have primary components, called objects, each of which has a different purpose. All of the components can be accessed and managed from the Navigation Pane.

 The list of objects as follows:

1. Tables: Tables are use for to store raw data.
2. Queries:  Queries extract information from tables.
3. Forms: Form is user friendly layout can use to enter, edit, or display data from a table or query.
4. Reports: Reports are used in Access to display the results of a table or query in a professional manner.
5. Pages: Publishes data to a intranet for creating/editing WWW pages.
6. Macros: Macros is list of commands to perform particular functions or task automatically.
7. Modules: Modules are contains programs written in Visual Basic code.

• Ribbons Bar: In the database window, the Ribbon includes four tabs (although other tabs appear when you perform specific tasks).

 

• Home: This tab shows seven groups (Views, Clipboard, Font, Rich Text, Records, Sort & Filter, and Find). It allows change the current view, adjust the font or paragraph styles, manage records, and sort or filter data.

• Create: Create tab shows four groups (Tables, Forms, Reports, and Other). It allows add new tables, forms, queries, and reports to your database.

• External Data: External Data tab shows four groups (Import, Export, Collect Data, and SharePoint Lists). It allows import, export and collect data to/from other sources. Also allows integrating with Microsoft Share-Point Server.

• Database Tools: Database Tools tab shows five groups (Macro, Show/Hide, Analyze, Move Data, and Database Tools. It allows create macros, manage relationships between tables, and create security permissions.