Main elements of MS Access and field properties
Access is part of the Microsoft 365 and Office suites for Windows; a free alternative is LibreOffice Base. It is started with a desktop shortcut, the Start menu or search. The ribbon tabs are: File (file operations for the database), Home, Create (create a table, query, form, report), External Data (import and export), Database Tools (linking tables and other tools). In the Navigation Pane on the left the object types are: Tables (store the data), Queries (select and calculate), Forms (enter and view), Reports (print), Macros (automate actions), Modules (program code). The “Pages” (web pages) of the old versions of Access no longer exist. The field types are: Short Text (up to 255 characters; the old name is Text), Long Text (long text; the old name is Memo), Number (Byte 0…255, Integer –32 768…32 767, Long Integer about ±2.1 billion, Single and Double – for fractions), Date/Time (years 100…9999), Currency (up to 15 digits in the whole part and 4 in the fraction), AutoNumber, Yes/No, OLE Object, Hyperlink and Attachment (attach a file). The database file has the extension .accdb.
| Navigation Pane object | Job |
|---|---|
| Tables | store the data |
| Queries | select and calculate |
| Forms | enter and view |
| Reports | |
| Macros | automate actions |
| Modules | program code |
When a paper sign-up slip for a club becomes a computer form, each box is told what goes into it: a word, a number, a date or yes/no. Then the form does not accept nonsense such as “class: ABC” or “31 February”.
Form designers, mobile app developers and data-entry staff choose the right field type to prevent wrong entries.
Draw a paper slip for a lost-property box: what was found, where, on which date and whether it was returned; write next to each box the kind of data that goes in it.
| Field | Type |
|---|---|
| StudentID | AutoNumber |
| FullName | Short Text |
| BirthDate | Date/Time |
| Score (0…100) | Number (Byte) |
| Fee | Currency |
| Active | Yes/No |
| Notes | Long Text |
| Photo | Attachment |
| Site | Hyperlink |
“Find the field type”: cards name pieces of data (date of birth, surname, payment amount, “yes/no”, a photo); students point out the matching field type.