M A T H W I T H M E G A N
Grade 11
CAT PRACTICAL
,Practical – Section 5
Click on this link for the complete
PowerPoint documents:
CAT Practical - Grade 11
, Preface
✓ If the formatting in PowerPoint appears incorrect on your
computer, please use the PDF version or upgrade to the
Windows 11 version.
✓ You may adapt and change these PowerPoints as you wish
and as it suits your schoolwork.
✓ You are also welcome to share any modifications with me that I
can add to the document, with credit to you.
✓ If there is any work that is not included in the document or if
any of the work is incorrect, please send me an email.
✓ You may not sell the document, but you may refer anyone to
my website.
✓ Happy studying.
, Contents
01 Introduction to databases
02 Forms
03 Queries
04 Database Tables
05 Reports
, Term 1
01
• Structure of a database
• First encounter with Access
• Working with tables
• Creating a table
, Structure of a database
• Fields: Property Type
• Record: Group of Fields in the same row
• Table: Consists of multiple related records
Fields
This entire row
is a Record
, First encounter with Access
Basics of access-database uses
Forms Databases in access are made
User-friendly up of four objects.
interfaces for entering
and viewing data
Tables
Sets of related data
Reports Queries
Formatted summaries Data resulting from
of data suitable for questions you ask in
printing tables
,Tables Forms Queries Reports
Although data is stored in
tables, the other three objects Forms are used for entering, Queries are a way of
Reports give you the ability to
(forms, queries and reports) modifying and viewing searching and pulling data
present data.
are the ways you work with records. from one or more tables.
the data.
Forms make entering data
Each of these objects
easier because they Running a query is like asking
interacts with the records A timetable or a report card
standardise the way data is a detailed question to the
stored in the databases are examples or reports.
entered or captured in the database.
tables.
database.
They are an easy way to When you build a query in Reports are useful because
guide people into giving access, you are defining they allow you to present
correct data you need to enter specific search conditions to components of a database in
into a database. find the exact data a way that is easy to read.
When you use a form in You can customise a reports
access, the data goes into the appearance to make it look
table you want it to go into to. attractive.
Forms help keep data
consistent and organised Access offers you the ability
which is essential for an to create a report from any
accurate and powerful table or query.
database.
,Important Features
Tables Forms Queries Reports
Usually Displays only
Summarizes a
contains the certain records
Stores data group of
same data as or fields of a
information
in the table table
, Changing the appearance and contents
of a table
• You can change the appearance of the selected table
at the Text Formatting group on the Home tab
• You can update contents of the table directly by
clicking on the content block you want to edit
Grade 11
CAT PRACTICAL
,Practical – Section 5
Click on this link for the complete
PowerPoint documents:
CAT Practical - Grade 11
, Preface
✓ If the formatting in PowerPoint appears incorrect on your
computer, please use the PDF version or upgrade to the
Windows 11 version.
✓ You may adapt and change these PowerPoints as you wish
and as it suits your schoolwork.
✓ You are also welcome to share any modifications with me that I
can add to the document, with credit to you.
✓ If there is any work that is not included in the document or if
any of the work is incorrect, please send me an email.
✓ You may not sell the document, but you may refer anyone to
my website.
✓ Happy studying.
, Contents
01 Introduction to databases
02 Forms
03 Queries
04 Database Tables
05 Reports
, Term 1
01
• Structure of a database
• First encounter with Access
• Working with tables
• Creating a table
, Structure of a database
• Fields: Property Type
• Record: Group of Fields in the same row
• Table: Consists of multiple related records
Fields
This entire row
is a Record
, First encounter with Access
Basics of access-database uses
Forms Databases in access are made
User-friendly up of four objects.
interfaces for entering
and viewing data
Tables
Sets of related data
Reports Queries
Formatted summaries Data resulting from
of data suitable for questions you ask in
printing tables
,Tables Forms Queries Reports
Although data is stored in
tables, the other three objects Forms are used for entering, Queries are a way of
Reports give you the ability to
(forms, queries and reports) modifying and viewing searching and pulling data
present data.
are the ways you work with records. from one or more tables.
the data.
Forms make entering data
Each of these objects
easier because they Running a query is like asking
interacts with the records A timetable or a report card
standardise the way data is a detailed question to the
stored in the databases are examples or reports.
entered or captured in the database.
tables.
database.
They are an easy way to When you build a query in Reports are useful because
guide people into giving access, you are defining they allow you to present
correct data you need to enter specific search conditions to components of a database in
into a database. find the exact data a way that is easy to read.
When you use a form in You can customise a reports
access, the data goes into the appearance to make it look
table you want it to go into to. attractive.
Forms help keep data
consistent and organised Access offers you the ability
which is essential for an to create a report from any
accurate and powerful table or query.
database.
,Important Features
Tables Forms Queries Reports
Usually Displays only
Summarizes a
contains the certain records
Stores data group of
same data as or fields of a
information
in the table table
, Changing the appearance and contents
of a table
• You can change the appearance of the selected table
at the Text Formatting group on the Home tab
• You can update contents of the table directly by
clicking on the content block you want to edit
