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,…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're 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…
If you need a deeper dive into the topics discussed, check out Adam's 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