Repeated Question No -10 Pg:105
Repeated Question No -16
Formulas – Pg 78
Functions – Pg 99
Year 2018 Q – 13 – Pg no: 86
Year 2018 Q 15
In Microsoft Access, a foreign key is a field (or a collection of fields)
in one table that uniquely identifies a row in another table. The
primary purpose of a foreign key is to ensure referential integrity
within your database by creating a link between two tables. This
relationship helps to maintain consistent and accurate data.
Year 2018 Q 16
In Microsoft Access, a one-to-many relationship is a type of
relationship between two tables where a single record in the first
table (the "one" side) can relate to one or more records in the
second table (the "many" side). This relationship is commonly used
to represent hierarchical data structures such as customers and
orders, where one customer can place many orders.
Year 2018 Q 22
An electronic spreadsheet is a digital tool used for organizing,
analyzing, and storing data in a tabular format.
Advantages
1. Automation of Calculations
2. Data Organization
3. Data Analysis
4. Data management
5. Time efficiency
6. Collaboration
Year 2018 Q 30
Select Data
Insert a chart - Insert tab => Line chart = > Line with markers
Chart with multiple lines appear, add titles and lables
Add breakeven point where total revenue becomes 0 This is the point
where the profit/loss line crosses the x-axis (Profit/Loss = 0)
Highlight this point by data marker or annotation
Year 2018 Q 31 – Pg 189
Year 2019 Q 21 – Pg 244
Year 2019 Q 25
a. Pg 209
b. See above
c. Pg 205
A relational database is a type of database that stores and provides access to data points that are
related to one another. These databases are structured to recognize relationships among stored
items of information. They use a structured query language (SQL) for accessing and managing
the data.
d. A relational database is a type of database that stores and provides access to data points
that are related to one another. These databases are structured to recognize relationships
among stored items of information. They use a structured query language (SQL) for
accessing and managing the data.
Year 2019 Q 27 – Pg 239
Year 2021 Q 13 – Pg 129
Year 2021(2) Q 27 – Pg 219
Year 2021(2) Q 26
In a relational database, various types of relationships can be
a. One – to -One Relationship
b. One – to – Many Relationship
c. Many – to – Many Relationship
d. Self – referencing relationship
Year 2021(2) – Q 21
Several approaches and techniques to handle and potentially
increase the size of a database
a. Splitting the database
b. Archiving Data
c. Compact and Repair
d. Data Normalization
e. Efficient Indexing
f. Using linked tables
g. Managing Data types and Field Sizes
Year 2021(2) – Q 22
From the external data tab, Click
1. Linking Tables from Another Access Database
2. Linking to Excel Worksheets
3. Linking to SQL Server or Other ODBC Data Sources
4. Linking to SharePoint Lists
5. Linking to Text Files (CSV, TXT)
Year 2021(2) Q 25 – Disadvantages of File Processing
System
1. Data redundancy and inconsistency
2. Limited data sharing
3. Data integrity issues
4. Complexity of data management
5. Scalability issues
6. Lack of security features
7. Poor data backup and recovery
8. Lack of integrity checks
9. Difficulty in maintaining relationships
[Link] data retrieval
Year 2021 Q 11
From page 61 – Auto fill enn kidappille, ath pole merge and center, copying and
moving, paste, find and replace angane headings poyekkunath kandille athokke
aann answer
Year 2021 Q 12
Using Close button
Using file menu => Click close
Using Keyboard => Alt + f4
Using the taskbar => Press ctrl + shift + Esc to open task bar and find Ms Excel
and end task
Year 2022 (2) Q 8
One-to-One Relationship
Definition: A one-to-one relationship occurs when a single record in Table A is
associated with exactly one record in Table B, and vice versa.
Example: A table of employees and a table of employee badges. Each employee has
exactly one badge, and each badge is assigned to only one employee.
Year 2022 (2) Q 13 – Pg 103 – FV function
Year 2022 (2) Q 18
Referential integrity is a property of relational databases that ensures relationships
between tables remain consistent. It involves maintaining the correctness and
validity of data by enforcing rules on how data in one table relates to data in
another table.
Year 2022 (2) Q 19
Many-to-Many (M:N)
In a many-to-many relationship, multiple records in Table A can be associated with
multiple records in Table B. This relationship is managed using a junction table
that holds foreign keys from both related tables.
Example:
• A Student table and a Course table where students can enroll in
multiple courses and each course can have multiple students enrolled. The junction
table Enrollment links students and courses.
Year 2022 (2) Q 27 already covered
Year 2022 (2) Q 31 – Pg 201
Year 2023 Q15 – Pg 147
Year 2023 Q14 – Pg 69
Year 2023 Q13 – Pg 78
Year 2023 Q28 – Pg 191