In this movie, Adam will show you that, though possible, there are fewer controls on how the data is entered, and little to no explanation for the user to follow when entering data directly to a table. This reinforces the concept of why data entry tasks are more commonly performed through the aid of a Form object.
- [Voiceover] Earlier, when we added our first task…to the task management database,…we used the interface provided by the database template.…We now know that we were actually…making use of a form object…and that the data is really being stored…in a table behind the scenes.…I can tell that we are using forms…by taking a quick look at the icon up here on the tab.…And you can see that this icon matches…the icons of the different form objects…here in the navigation pane.…In fact,…our entire interaction with the database at this point…has been entirely through form objects.…We haven't seen a single table at all.…But since the data is being saved,…we know that some tables must exist in the background.…
And in fact, there are four tables in this database:…Contacts, Filters, Settings, and Tasks.…If we double-click on the Tasks table here…in the navigation pane,…it'll open up in its own tab,…and we can see the raw structure of the original data table.…Here I can see the single record…that we've entered in previously…and the names of the fields, or the attributes,…
If you need a deeper dive into the topics discussed, check out Adam's Office 365: Access 2016 Essential Training course.
- Loading a premade template database
- Exploring the interface
- Defining data types
- Creating tables
- Defining table relationships
- Editing forms
- Creating queries and reports
- Editing reports in Layout view