Tasks Database
Return to the full Database list of activities
Here's Mr. Miles' "TASK LIST" MS Access Database learning activities (videos with descriptions below)
- TASKS Database (Beginner)
- Tasks Part 1 - Create New Database
This video shows how to create a new database and create a table. It also shows that we create a primary key and can look up some values for a table in another table. - Tasks Part 2 - Access Lookup Table
This video shows that by using a lookup we create a relationship between two tables. The relationship is one to many because one field in one table appears many times in the other table.
We force referential integrity which means that if the data is changed in the one table then it will get changed in the other table. Also if the record is deleted in one table it will automatically be deleted in another. - Tasks Part 3 - Access Table Properties
In this video we set the properties of a field to “required”. This means that the user must enter something in that field. - Tasks Part 4 - Add Field to Table
Here we add data to tables and also add another field to the tasks table. As we build a database we gradually add more fields and tables. By adding data we get reminded of other fields that we would like. - Tasks Part 5 - Creating Query
We see that all of the tables are connected so we can make a query relating to more than one table. In this video we use the filter tools which are shown in the menu plus start by making one query. - Tasks Part 6 - Access Query Sort
This video shows another query and includes using the sort function so that similar records are shown together. We can sort on one or more fields. - Tasks Part 7 - Access Main Menu
We make another query and then make a main menu using a form so that we can run the queries at the touch of the button. - Tasks Part 8 - Criteria in Query
Here we see that we can enter a word in criteria on a query to filter the results with just those records. We add the new queries to our main menu. - Tasks Part 9 - Main Menu Buttons
This video is the continuation of video 8 where we started to add more buttons to our main menu. - Tasks Part 10 - Properties of Database
If we are building this database for someone else to use such as an employee then we can set the properties of the database to make a main menu show when the database is open. We can also set a property to hide the navigation bar on the left. In this video we are also introduced to the form wizard. - Tasks Part 11 - Report Wizard
We continue with forms in this video and also create reports using the report wizard.
- Tasks Part 1 - Create New Database