Page 102 - Viva ICSE Computer Studies 7 : E-book

8 Working with Tables

and Queries

Learning Outcomes
Let’s Learn About

Students will be able to • Creati ng Tables
• create, save and edit a table in Access. • Editi ng Table in Access
• Query
• insert data in a table.
• Establishing Relati onship
• build query statements.
among Tables

Activity Corner

Label the components of the given screenshot of Access 2016.

Creating Tables

Access 2016 allows you to create tables in the following two ways.
1. Using Datasheet View: This view allows you to create a table just like a spreadsheet that
you commonly use in MS Excel. Data can be entered directly into the table’s rows and
columns. Although this is a simpler method, it is not a professional approach of working
with tables in a database.

2. Using Design View: This view allows you to create a table in a professional way by fi rst
defi ning the structure of the table and then entering the data. This method is used by
programmers and professionals.

90