:Base abdata.HLP
1 Database
2 Getting started
3 What is a Database
4 What is a database?=What_is_a_database
4 What is a table?=What_is_a_table
4 What is a relation?=What_is_a_relation
4 What is a query component?=What_is_a_query_component
4 What is a query?=What_is_a_query
4 What is a table view?=What_is_a_table_view
3 Starting Database
4 Starting Database=Starting_Database
4 Opening a database=Opening_a_database
4 Database Manager=Database_Manager
4 Closing a database=Closing_a_database
4 Query components=Query_components
4 Opening a table=Opening_a_table
4 Moving around a table=Moving_around_a_table
2 Creating databases and tables
3 Creating a new database=Creating_a_new_database
3 Designing a new table=Designing_a_new_table
3 Fields
4 Planning field details=Planning_field_details
4 Field names=Field_names
4 Field data types
5 Data types=Data_types
5 Character
6 Character=Character
6 Character field size=Character_field_size
6 Masks in database fields=Masks_in_database_fields
5 Numeric
6 Number formats in database=Number_formats_in_database
6 Numeric=Numeric
6 Number format=Number_format
6 Currency format=Currency_format
6 Percentage format=Percentage_format
6 Fraction format=Fraction_format
6 Scientific format=Scientific_format
6 Width properties in numeric fields=Width_properties_in_numeric_fields
5 Date and time
6 Date/Time data type=Date_and_time
6 Date/Time format=Date_Time_format
5 Memo
6 Memo=Memo
5 Incremental
6 Incremental=Incremental
5 Logical
6 Logical=Logical
6 Boolean calculated field: example=Boolean_calculated_field
5 Enumerated
6 Enumerated=Enumerated
6 Adding enumerated field types=Adding_enumerated_field_types
5 Picture and OLE
6 Picture=Picture
6 OLE=OLE_field_type
5 Calculated
6 Calculated field type=Calculated
6 Using the calculated data type in a table=Using_the_calculated_data_type_in_a_table
6 Using the calculated data type in a relation=Using_the_calculated_data_type_in_a_relation
4 General field properties
5 Captions=Captions
5 Validation of data=Validation_of_data
5 Validation rule=Validation_rule
5 Validation text=Validation_text
5 Required property=Required_property
5 Allow zero-length property=Allow_Zero_Length_Property
5 Initial value=Initial_value
4 Creating fields
5 Creating fields in a database=Creating_fields_in_a_database
5 Creating fields in a database using Table Wizard=Creating_fields_in_a_database_using_Table_Wizard
3 Indexes
4 Indexes and primary keys=Indexes_and_primary_keys
4 Primary key=Primary_key
4 Unique indexes=Unique_indexes
4 Non-unique indexes=Non_unique_indexes
4 Creating indexes and primary keys=Creating_indexes_and_primary_keys
4 Checking indexes and primary keys=Checking_indexes_and_primary_keys
4 Editing and setting indexes and primary keys=Editing_and_setting_indexes_and_primary_keys
4 Multiple-field indexes=Multiple_field_indexes
3 Saving the new table
4 Saving a new table=Saving_a_new_table
2 Using tables
3 Opening a table using database manager=Opening_a_table_using_database_manager
3 Grid view=Grid_view
3 Table record indicators=Table_record_indicators
3 Working with records
4 Modifying records=Modifying_records
4 Adding records=Adding_records
4 Duplicating records=Duplicating_records
4 Entering data and editing records=Entering_data_and_editing_records
4 Finding records=Finding_records
4 Deleting records=Deleting_records
4 Deleting the contents of fields in a database table=Deleting_the_contents_of_fields_in_a_database_table
4 Copying records=Copying_records
3 Managing tables
4 Managing your tables=Managing_your_tables
4 Redesigning a table=Redesigning_a_table
3 Formatting the table grid
4 Formatting columns in a database table=Formatting_columns_in_a_database_table
4 Formatting fonts in a table=Formatting_fonts_in_a_table
4 Formatting a table for color=Formatting_a_table_for_color
4 Formatting borders in a table=Formatting_borders_in_a_table
4 Alignment in database fields=Alignment_in_database_fields
4 Formatting database fields=Formatting_database_fields
4 Changing the grid style=Changing_the_grid_style
4 Changing the column width=Changing_the_column_width
3 Table calculations
4 Performing calculations in tables=Performing_calculations_in_tables
4 Performing calculations in a filtered table=Performing_calculations_in_a_filtered_table
2 Filters, Sort Orders and Column Views
3 Column Views
4 Rearranging columns using the mouse=Rearranging_columns_using_the_mouse
4 Rearranging columns using a columns selection=Rearranging_columns_using_a_columns_selection
4 Hiding and showing columns in a database table=Hiding_and_showing_columns_in_a_database_table
4 Hiding and showing columns using a columns selection=Hiding_and_showing_columns_using_a_columns_selection
3 Sort Orders
4 Sorting a table=Sorting_a_table
4 Sorting on a single field=Sorting_on_a_single_field
4 Sorting using a sort order=Sorting_using_a_sort_order
3 Filters
4 Filtering a table=Filtering_a_table
4 Filtering on a single field=Filtering_on_a_single_field
4 Filtering using a named filter=Filtering_using_a_named_filter
4 Filter example=Filter_example
2 Queries
3 Queries=Queries
3 Creating and applying a query=Creating_and_applying_a_query
3 Creating a query while working in a table=Creating_a_query_while_working_in_a_table
3 Editing a query=Editing_a_query
3 Editing query components=Editing_query_components
2 Relations
3 Joining tables=Joining_tables
3 Creating a relation=Creating_a_relation
3 Relating tables using forms=Relating_tables_using_forms
2 Forms
3 Form view=Form_view
3 Opening an auto form=Opening_an_auto_form
3 Design mode=Design_mode
3 Opening an existing form=Opening_an_existing_form
3 Using a form
4 Using browse mode in a form=Using_browse_mode_in_a_form
4 Moving around in a form=Moving_around_in_a_form
4 Browsing through the database table=Browsing_through_the_database_table
4 Editing records=Editing_records
4 Hiding fields from the form=Hiding_fields_from_the_form
4 Showing hidden fields in the form=Showing_hidden_fields_in_the_form
3 Creating forms
4 Creating a new form=Creating_a_new_form
4 Creating a form from scratch=Creating_a_form_from_scratch
4 Inserting fields
5 Inserting fields into a form=Inserting_fields_into_a_form
5 Inserting database fields into a form=Inserting_database_fields_into_a_form
5 Inserting a database field=Inserting_a_database_field
5 Inserting a lookup field=Inserting_a_lookup_field
5 Inserting formula fields into a form or report=Inserting_formula_fields_into_a_form_or_report
5 Inserting a lookup summary field into a form or report=Inserting_a_lookup_summary_field_into_a_form_or_report
5 Using lookup summary fields in forms or reports: example=Using_lookup_summary_fields_in_forms_or_reports_example
4 Inserting table grids
5 Inserting a table grid into a form=Inserting_a_table_grid_into_a_form
5 Inserting a table grid into a form: example=Inserting_a_table_grid_into_a_form_example
4 Page numbers, dates, pictures
5 Inserting a page number into a form or report=Inserting_a_page_number_into_a_form_or_report
5 Inserting the date and time into a form or report=Inserting_the_date_and_time_into_a_form_or_report
5 Inserting a picture into a form or report=Inserting_a_picture_into_a_form_or_report
5 Inserting an object into a form=Inserting_an_object_into_a_form
3 Editing existing fields
4 Editing fields in forms and reports=Editing_fields_in_forms_and_reports
3 Multi-page forms
4 Multi-page forms=Multi_page_forms
2 Reports
3 Reporting=Reporting
3 Opening an auto report=Opening_an_auto_report
3 Detail of an auto report=Detail_of_an_auto_report
3 Opening an existing report=Opening_an_existing_report
3 Creating new reports
4 Creating new reports=Creating_new_reports
4 Types of report=Types_of_report
4 Type of report: vertical fields=Type_of_report_vertical_fields
4 Type of report: horizontal fields=Type_of_report_horizontal_fields
4 Labels in reports=Labels_in_reports
4 Inserting fields in a report=Inserting_fields_in_a_report
3 Editing reports
4 Editing a report=Editing_a_report
4 Resizing the sections in a report=Resizing_the_sections_in_a_report
4 Headers and footers in a report=Headers_and_footers_in_a_report
4 Format sections in reports=Format_sections_in_reports
4 Editing field labels=Editing_field_labels
3 Sorting and grouping
4 Sorting and grouping in a report=Sorting_and_grouping_in_a_report
4 Group summary fields=Group_summary_fields
4 Layout of a grouped report=Layout_of_a_grouped_report
4 Using queries in reports=Using_queries_in_reports
3 Viewing and printing
4 Viewing a report in print preview=Viewing_a_report_in_print_preview
4 Printing a report=Printing_a_report
2 Managing Databases
3 Deleting a database=Deleting_a_database
3 Deleting a database object=Deleting_a_database_object
3 Repairing a damaged database=Repairing_a_damaged_database
2 Importing and exporting tables
3 Importing tables=Importing_tables
3 Exporting tables=Exporting_tables
3 Appending imported tables=Appending_imported_tables