![ms access 2010 pdf free download ms access 2010 pdf free download](https://images.sftcdn.net/images/t_app-cover-l,f_auto/p/eccf14c0-91ef-11e6-9ce9-00163ed833e7/3328789969/microsoft-access-2010-screenshot.jpg)
P a g e 14ġ5 Q38 Produce a report which: 1. Remember task 36 required you to add the following records: Make Model Size Price Skill Level Wind Use Number Stock Item Condition Airush Vapour Beginner Low Kite Surf 1 Yes Best Nemesis Beginner Medium Kite Surf 1 Yes Airush Flow Beginner High Kite Surf 1 Yes Save the data How to do it: To save the new records in the table simply press the Save button which you can find to the right of the Office Button (top left of the screen). It is vital that your data entry is EXACTLY the same as the information stated in the question or you will run into problems when you come to search the database later in the exam. P a g e 13ġ4 Checking data entry - How to do it: All this requires you to do is to read through the new records that you have entered and double check that they match those stated in task 36. Enter the 3 new records as specified in task 36. The asterix indicates that this row is where new records are input. Scroll to the bottom of the table and look for the row which is marked with an asterix (*). Double click on tblkites to view the records. P a g e 12ġ3 Q36 Insert the following three records: Make Model Size Price Skill Level Wind Use Number Stock Item Condition Airush Vapour Beginner Low Kite Surf 1 Yes Best Nemesis Beginner Medium Kite Surf 1 Yes Airush Flow Beginner High Kite Surf 1 Yes Check your data entry for errors. Your finished screenshot should look something like this: 5. Add your Name, Centre Number and Candidate Number to the Footer. Open up an empty Microsoft Word document and then click Paste. To do this, simply press PrtScn on the keyboard. The task asks you to take a screenshot of the Field Names and Data Types used within the table. P a g e 11ġ2 Taking a screenshot how to do it: 1. Save the database for later use by clicking the symbol. Use the drop-down list to select the Yes/No option. To change the Boolean field so that it displays Yes or No, click in the Stock Item field and in the General tab select the Format cell. The solution to task 35 will be detailed over the pages P a g e 3ġ1 4. Make sure that your name, Centre number and candidate number are included on this printout. Save a screen shot showing the field names and data types used. You may add another field as a primary key field if your software requires this. Page P a g e 2ģ 2010 Database Task Walkthrough Q35 Using a suitable database package, import the file N10EKS.CSV Assign the following data types to the fields: Make Model Size Price Skill Level Wind Condition Use Number Stock Item Text Text Numeric/1 decimal place Currency/2 decimal places Text Text Text Numeric/Integer Boolean/Logical Make sure that you use these field names. Exporting Data from a Query Page Importing Exported Data into a Word Document Extra Info - Summarising Data. Sorting information within a Query Task 43 and 44 details. Third Query Search Criteria Page Hiding Fields within a Query. Page Setting up Labels of the Second Query Page Adding Header and Footer information to Labels Page Task 42 details Creating the Third Query.
![ms access 2010 pdf free download ms access 2010 pdf free download](https://www.heritagechristiancollege.com/wp-content/uploads/2019/05/free-access-database-templates-of-crm-basic-ms-access-templates-of-free-access-database-templates.jpg)
Page Adding Header and Footer information to a Report. 27 Performing Calculations within Reports. First Query Search Criteria -22 Setting up a Report of the First Query. Page Creating a Calculated Field within the Query Page Changing Format of a Calculated Field. Identifying Query Tasks and Report Tasks Creating the First Query. Page Taking Screenshot Evidence Task 36 details. 1 IGCSE ICT SECTION 11 DATA MANIPULATION MICROSOFT ACCESS STEP BY STEP GUIDE Mark Nicholls ICT Lounge P a g e 1Ģ Contents Task 35 details Opening a new Database.