Scribd Logo
Upload

Welcome to Scribd!

  • 21 views

    Create Calculated Fields in Access 2010

    Uploaded by

    Alage Teka
    This document discusses how to create calculated fields in an Access 2010 table. It explains that calculated fields allow you to calculate values based on other fields in real time. It provides steps to create a sample student marks table with course mark fields and a total marks field. It demonstrates setting the total field as a calculated field and entering a formula to add up the course mark fields. The calculated field will then automatically total the marks as records are added.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd

    Create Calculated Fields in Access 2010

    Uploaded by

    Alage Teka
    21 views5 pages
    This document discusses how to create calculated fields in an Access 2010 table. It explains that calculated fields allow you to calculate values based on other fields in real time. It provides steps to create a sample student marks table with course mark fields and a total marks field. It demonstrates setting the total field as a calculated field and entering a formula to add up the course mark fields. The calculated field will then automatically total the marks as records are added.

    Original Title

    Create Calculated Fields In Access 2010

    Copyright

    © © All Rights Reserved

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document discusses how to create calculated fields in an Access 2010 table. It explains that calculated fields allow you to calculate values based on other fields in real time. It provides steps to create a sample student marks table with course mark fields and a total marks field. It demonstrates setting the total field as a calculated field and entering a formula to add up the course mark fields. The calculated field will then automatically total the marks as records are added.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    21 views5 pages

    Create Calculated Fields in Access 2010

    Uploaded by

    Alage Teka
    This document discusses how to create calculated fields in an Access 2010 table. It explains that calculated fields allow you to calculate values based on other fields in real time. It provides steps to create a sample student marks table with course mark fields and a total marks field. It demonstrates setting the total field as a calculated field and entering a formula to add up the course mark fields. The calculated field will then automatically total the marks as records are added.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    of 5

    Create Calculated Fields In Access 2010

    MS Office

    8 Comm ents

    Advertisement
    In Access 2010, you can manipulate data fields in many ways by applying constraints, changing data types,
    creating relationships and so on, but creating Calculated fields would be of great use, as you can easily
    calculate field values based on other field’s data in real time. In this post we will guide you through the
    procedure of creating a Calculated field, which will take values from other fields to evaluate result.

    To start out with creating calculated fields, launch Access 2010, navigate to Create tab and click Table.

    We will be making a simple Marks table, carrying marks of students in different courses and Total field,
    containing total marks. For this right-click Table1, and click Design View.
    Enter an appropriate name of table name and click OK.

    Start entering field names, i.e, name of courses and under Data Type, click drop-down button to select Number
    as data type.
    Change data types of each course field to Number, except of ID (which is unique identifier) and Total field.
    Under Total data type list options, select Calculated.
    It will bring-up Expression Builder dialog. For illustration we will be adding all the marks secured in different
    fields in Total field. For this start entering all the field names enclosed in square brackets, separated by plus
    sign. Click OK to continue.

    Now close the marks field and save the changes made. From navigation pane, double click the table to open it
    in datasheet view. Start entering marks obtained and you will see that the on filing out one complete record,
    Total field will add up marks obtained in corresponding record.

    You can also check out previously reviewed guides on How to export Access 2010 table to XML Data
    file & How to Export database Table to Plain Text in Access 2010.
    Advertisement
     Create Calculated Field in Pivot Table [Excel 2010]
     Insert “Quick Fields” In Access 2010 Database Table
     Create Hyperlink Field In Access 2010

    Previous Post
    ←Make Database Application Form In Access 2010

    Assign Password Data Type To A Specific Field In Access 2010→


     How To Scan & Digitize Your Old Photographs With Your Phone
    Digital cameras, when they fist appeared on shelves, were expensive. It took a while for them...
     How To Use QR Codes For Twitter Accounts
    Twitter has rolled out QR codes because, why not? Facebook’s Messenger app has them. The...
    READERS ACTIVITY
     PEOPLE
     RECENT
     POPULAR
    Most Discussed
     10 Useful App Shortcuts From Google Apps Available In Android 7

    1 comment · 4 days ago


     How To Remotely Sign Out Of Skype

    1 comment · 1 week ago


     Turning Off Siri Access From Home Button Turns It Off Completely In iOS 10.2

    3 comments · 2 weeks ago


     How To Listen To Podcasts And Watch YouTube Videos In VLC

    1 comment · 4 days ago


     How To Send GIFs And Convert Short Videos To GIFs In Whatsapp

    2 comments · 5 days ago

    You might also like