Excel, Word & Access: Your Guide to Paper 1

Welcome to Excel Fundamentals for Paper 1! Let's explore the essential functions and features you'll need for your exam.Let's start with the SUM function, which adds up a range of numbers.The AVERAGE function calculates the mean of a range of values.The COUNT function counts the number of cells containing numbers in a range.Understanding cell references is crucial. Let's look at the different types.Proper cell formatting is essential for presenting data clearly.Data sorting and filtering helps organize and analyze your data effectively.Excel offers various chart types to visualize your data.Keep these exam tips in mind when working with Excel functions and features.Word processing skills are crucial for Paper 1. Let's start with paragraph formatting.Different paragraph styles help organize your document effectively.Headers and footers add professional formatting and page organization.Text manipulation tools help you make changes efficiently and track document revisions.Tables help organize information clearly. You can adjust rows, columns, and formatting.Document properties help track important metadata about your files.Let's look at how these skills transform a basic document into a professional one.Keep these tips in mind during your exam to work efficiently and accurately.Now let's move on to the next section.In Access, tables are the foundation of your database. Let's start by examining the Students table structure.Each table needs a primary key - usually an AutoNumber field that uniquely identifies each record.Let's add our Courses table, which will also have its own primary key.To connect Students and Courses, we need an Enrollment table that creates a many-to-many relationship.The Enrollment table uses foreign keys to reference both Students and Courses.These relationships allow one student to enroll in many courses, and each course can have many students.The Query Design view helps you retrieve specific data from your tables.You can use various criteria to filter your data, such as date ranges, text patterns, and numeric conditions.Forms provide a user-friendly interface for data entry. Let's create a basic student information form.Forms can include various controls like text boxes, date pickers, and dropdown lists.Reports organize your data for printing. They typically include different sections like headers, detail areas, and footers.