Meta-framework
Creating the entities (tables) and attributes (fields)
Adding data (records)
Relationships
Creating Relationships and adding referential integrity
Basic User Interface
Forms
Reports
Queries
Basic Query (single table)
Query based on 2 tables
Forms
Reports
To be added
Adding (concatenating) 2 fields in a query column. Very useful if you want to join a lastName and firstName and separate with a comma.
1. Create a simple query. Then in the last option go to edit the query. Add an extra field - you will need to type this into the Field property (Suggest you do this on the last column). in the form TitleOfColumn:[Field1] & ", " & [Field2] e.g. where you have 2 fields for a name (First and last) this could be
Field : | FullName: [LastName] & ", " & [FirstName]