Create and modify databases

create an empty desktop database using a template, build a database by importing data or objects from other sources and making database object deletions.

Manage relationships and keys

Establish and edit relationships, establish foreign keys, inspect relationships, set the primary key, and ensure referential integrity.

Navigate through a database

Navigate certain records, make changes to a navigation form, make a form the default form to open, show objects in the Navigation Pane, and switch between object views.

Protect and maintain databases

Database functions include backup, split, compact, repair, password-protected encryption, and backup data recovery.

Print and export data

Print documents and reports, save a database as a template, export items to other formats, and print records.

• Create tables
• • Make a table, import data into it, link tables from different databases, import tables from external sources, and make a table using an application component template.
•  
• Manage tables
• • Rename tables, add total rows, add table descriptions, and hide fields in tables.
•  
• Manage records in tables
• • Records can be updated, added, deleted, appended from external data, found, replaced, sorted, and filtered.

• Create and modify fields
• Create fields, add fields to tables, apply validation rules, modify field names, widths, and data types, establish default values, auto-increment fields, use input masks, and delete fields.

• • Create a query
  • • Run a query, make a crosstab query, make a query with parameters, make an action query, make a query with multiple tables, and save a query.
  •  
  • Modify a query
  • • Change the name of a query, add, remove, or conceal fields, sort data inside of queries, or format fields within of queries.
  •  
  • Create calculated fields and grouping within queries
  • Organise and summarise data, add computed fields, establish filtering criteria, group data using comparison operators, and group data using arithmetic and logical operators.

• • Create a form
  • • Make a form, construct a form containing application components from a template, preserve a form
  •  
  • Configure form controls
  • • Form controls can be added, moved, managed, labeled, modified, removed, form control properties changed, and sub-forms may be added.
  •  
  • Format a form
  • • Change the tab order and set Print options, arrange data according to form fields, apply a theme, manage form placement, add backdrops, add headers and footers, and add photos
  •  

• • • Create a report
    • • Make a report using the table or query as a basis. generate a report using a wizard or in Design View

     

    • Configure report controls
    • • Sort and group fields; change data sources; add buttons to reports; add and change labels
    •  
    • Format a report
    • • Add calculated fields, adjust report placement, format report elements, alter report orientation, add header and footer information, insert photos, and apply a theme to format a report into many columns