Working with Databases in Access: A Comprehensive Guide

Topic 8: Exporting Data from Access

Exportable File Formats

• SharePoint
• Word files
• Excel documents
• Other Access databases
• Text files

Linked Tables and Data Updates

Changes made to the original Excel data will not be reflected in the linked Access table.

Dividing a Database

An Access database can be split into two files:

• Server File: Contains the tables.
• Client File: Contains forms, reports, and other created objects.

Topic 9: Working with Forms in Access

Simple Forms

Access can automatically generate simple forms from active tables, displaying records in an organized layout and allowing for new data entry.

Form Tools

Form tools simplify the creation of forms by allowing you to select the desired data fields.

Split Forms

Split forms offer two views:

• Form View
• Datasheet View

This dual view combines the benefits of both form types.

Subforms

A subform is a form inserted within another form (the main form).

Topic 10: Creating Reports in Access

Complex Reports

Complex reports offer extensive customization options to tailor the report to specific data and usage requirements.

Report Wizard

The report wizard simplifies report creation by guiding you through field selection.

It allows the inclusion of multiple fields from tables or queries.

Data Sorting in Reports

Report data can be sorted in ascending or descending order.

Topic 11: Creating and Modifying Graphics in Access

Dynamic Graphics

Dynamic graphics are interactive visualizations that summarize data and totals. They allow users to explore different data combinations.

Dynamic vs. Normal Graphics

Dynamic graphics are interactive, allowing users to manipulate data views, while normal graphics are static.

Creating Dynamic Graphics

To create a dynamic graphic:

1. Select or open the data source.
2. Drag the desired fields into the graphic's field list.

Locating Dynamic Graphics

Dynamic graphic options are available in the Type tab of the Properties dialog box. This tab lists basic graphic types and displays subtype icons.