Computerized accounting is software which used in offices to manage the complete office data at one place and allow a business owner, or finance person, to track sales, expenses, payroll, taxes, and even inventory.
Building the structure of a database. Create a new database. Create a table using the design view. Manage tables. Set table field properties. Creating relationships between tables. Modify, add, and delete table fields. Sort and filter records in table. Create a Query, Add Criteria to a Query, Compile field to multiple table, and Add a Calculated Field to a Query, Perform Calculations on a Record Grouping. Create form by using wizard, Create form by design view, Changing the Look of Forms Changing the Arrangement of Forms. Create sub forms. Creating Reports by Using a Wizard, Modifying Report Design, Previewing and Printing Reports. Create and use a switchboard, Exporting Data to an Excel Workbook, Creating Word Mail Merge Documents, Importing Data, Linking Data to an Access Table and Protect Database.
Set up print options for single and multiple worksheets, Work with multiple worksheets, Format worksheets to suit needs, Add graphic elements to a chart, Create and work with charts, Enter formulas and work with formulas and functions, Use advanced features such as Goal Seek and the Analysis Identify, Identify the ways to use a scenario, Use macros to automate complex and repetitive tasks, Create custom functions, Send workbooks through e-mail, Use auditing features and incorporate comments in Excel, Create and work with Pivot Charts, Create and work with PivotTables, Use data outlining and consolidating features, Use sorting and filtering features, Identify elements of a list, Identify database functions, Use the nested IF function, Use advanced functions and Assignments.