Database objects - queries and forms

Database objects - queries and forms

by Hayden So

​Where are we up to with the databases?

At the moment, you should be ​at the stage of data entry and nearly working on your data and creating the table and queries.

​

​Watch my walkthroughs on Google Classroom if you are still stuck on those things. But here are some important reminders.

​Queries

​Here are some important tips for your database.

​

​- Make sure that a primary key needs to link to a foreign key (of the same name) to form a relationship.

​- You need to have relationships between at least 2 tables.

​- When writing your query, you can use the design view of the database.

​You can use totals and other arithmetic to calculate some important facts about the data in your table.

• We will be using the queries we've created in order to create the relevant reports. These can also be designed​

​Do now

​- After my demonstration or watching my introduction to forms and reports on Google Classroom, make sure to answer the following quiz questions. Hopefully this will help you with your own project.

Multiple Choice

Which of these is NOT an object in a Microsoft Access database?

• Table

• Field

• Report

• Query

• Form

Multiple Choice

Which of the following is NOT a relationship in a database?

• One-one

• One-Many

• many-many

• many-none

Open Ended

Why would you prefer to have your user write in a form rather than using datasheet view in Microsoft Access?

Fill in the Blanks

Open Ended

List the steps you would take in order to complete a query with a total

Open Ended

List the steps you need to create a report based on the query

Multiple Choice

What is NOT a view for a report

• Print

• Design

• Code

• Layout

Poll

How confident are you now with creating your form or report on Microsoft Access?

• Not confident - I need to revise the video on the classroom

• Quietly confident - I still need practice but I've got the basics

• Confident - I've already started but this video helped me

• Very Confident - That was very clear

Open Ended

List the next steps you will take for your project. Think about the different objects in the database as well as your Trello board.