- Working with Microsoft Access
/documentation/pages/Guides/Desktop/Design/Data/SQL/Working with Microsoft Access.xml
In order to read or write to Microsoft Access with AlphaDAO functions, you must have permission to read the database's System Catalog.
- Connecting to Microsoft Excel
/documentation/pages/Guides/Databases/Connecting/Connecting to Microsoft Excel.xml
Tips on working with Microsoft Excel using AlphaDAO connections
- Working with SQL
/documentation/pages/Guides/Databases/Working with SQL/index.xml
Tips on creating databases, creating SQL queries using Alpha Anywhere's Portable SQL Syntax, using the SQL command window, and more.
- Working with Workspaces
/documentation/pages/Guides/Desktop/Design/View/Workspace/Working with Databases.xml
Tables, sets, and workspaces are the primary structures for storing data in an Alpha Anywhere desktop applications.
Your workspace files keep track of all of the tables, sets, toolbars, forms, and such, used for managing information. When you open an existing workspace, Alpha Anywhere displays the objects (tables, forms, etc.) that make up the workspace in the Control Panel. With Alpha Anywhere, you work with one workspace at a time.
- Exporting Records to Microsoft Excel
/documentation/pages/Desktop/Reference/Design/View/Database/Exporting Records to Microsoft Excel.xml
When viewing a form or browse, click [x_img] or select Tools > Export to Excel to export the current selection of records to Microsoft Excel. Excel opens, displaying the exported data. Click File > Save As... to save the new spread sheet.
- Microsoft Office Functions
/documentation/pages/Ref/Api/Functions/Document Types/Office Functions/index.xml
Functions for creating and working with Microsoft Office files.
- Working with Reports
/documentation/pages/Guides/Report/Getting Started/Working with Reports.xml
Reports, Letters, and Labels are Alpha Anywhere layouts for data output. Learn how to create reports in this guide.
- Working with Pointer Arrays
/documentation/pages/Guides/Desktop/Xdialog/Working with Pointer Arrays.xml
Pointer arrays (also called "property arrays") allow you to represent "multi-columned" data in an array. For example, for a customer, you have information about the customer's name, address, phone number etc.
- Working with SQL Reports
/documentation/pages/Guides/Report/Getting Started/Working with SQL Reports.xml
There are 2 different approaches to building a SQL Report.
- Working with Records
/documentation/pages/Desktop/Tutorial/Design/View/Database/Working with Records.xml
In this lesson, you learn how to view and enter data in Alpha Anywhere, and how to create, change, save, and delete table records.