Author Archives: zr148419

Posts: 5 (archived below)
Comments: 1

About zr148419

NO-CARD

Using Access

I never used Access. This is also copy from microsoft.com

Use Access when you:

May need to add more tables in the future to an originally flat or non-relational data set.For example, if you want to keep track of customer information such as first and last names, addresses, and telephone numbers, but that information may grow to include actions by customers such as orders, then consider starting your data project in Access.Have a very large amount of data (thousands of entries).For example, if you work in a large company and are required to store personnel information, then use Access.Have data that is mostly of the long text string type (not numbers or defined as numbers).Rely on multiple external databases to derive and analyze the data you need.For example, if you need to import or export data regularly from Access databases, it may make the most sense to work in Access to maximize compatibility.Need to maintain constant connectivity to a large external database such as one built with Microsoft SQL Server.Want to run complex queries.For example, if you work in a large company that takes customer orders, you might have to look up customer names stored in a SQL Server database while taking new customer orders in Access. You can maintain a connection to the SQL Server database from within the Table view in Access. When you add or look up a customer name, you are working against the SQL Server database, but the new order details you just took are stored locally in Access tables.

Zhanna Rosseychuk.

Posted in Uncategorized | Comments Off on Using Access

Blog

Please anybody explain me how to use blog? I do not know how to look and read other’s  posts, how to edit my posts to put them into correct category, how to add comments. I am not experienced  in blogging (I do not like to waste time in the blogs, facebook, etc. Now I need it just because of class asignments). Thank you for help. I am not sure I could find how to read helpful posts, but anyway, I will try.

Posted in Uncategorized | Comments Off on Blog

Excel 2013

 

 I am sorry. I do not have any experience to use or to try Excel 2013. I just copy the preview of Excel from Microsoft site to be familiar with new Excel.

Excel 2013 Preview

Enjoy new ways to explore your data more intuitively. Visualize, analyze, and display results with a single click. And when you’re ready, it’s easy to share your freshly discovered insights.

Discover

Reveal the insights hidden in your data. Easily extract what you need from imported information with Flash Fill, and perform complex analyses quickly with Recommended Pivot Table.

Recommended Pivot Table   Excel summarizes your data with previews of various pivot-table options, letting you select the option that tells your story best.

Flash Fill   Here’s the easy way to reformat and rearrange your data. Excel learns and recognizes your pattern and auto-completes the remaining data, with no formulas or macros required.

Visualize

New analysis tools help make it easy to visualize data with a click of the mouse.

Recommended Charts   Let Excel recommend the charts that best illustrate your data’s patterns. Quickly preview your chart and graph options, and then pick the option that works best.

Quick Analysis   Discover a variety of ways to represent your data visually. When you like what you see, apply formatting, sparklines, charts, and tables with a single click.

Chart Formatting Control   Fine-tune your charts quickly and easily. Change the title, layout, and other chart elements—all from a new and more interactive interface.

Share

It’s easy to work together or share with others. Send a link to co-workers, post the link to a social network, or present online.

Simplified Sharing   Your workbooks are saved online to SkyDrive or SharePoint by default.* Send everyone a link to the same file, along with their viewing and editing permissions, and be assured that everyone sees the latest version.

Post to Social Network   Share selected portions of your spreadsheets on the web by simply embedding them on your social network pages.

Present Online   Share your workbooks and collaborate with others via a Lync conversation or meeting. You can also allow others to take control of your workbook.

 I think if  application has a lot of features that means more difficult to use. But will see.
 
Zhanna Rosseychuk
Posted in Office 2013 | 4 Comments

How do I use Excel

Before I became an american student I did not know how to use a computer at all. When I started to learn  computer applications in the two year college Excel immediately became my famouse. At my previous job I used Excel a lot , for instance, to create income-expense reports, to export data from QuickBook, to keep payroll records for company, to complete nessesary paperworks for different type of audits, even I used Excel instead of Word to create a letters with tables and charts. I think this is the best application for accounting, math, and engeneering.

Zhanna Rosseychuk.

Posted in How Excel is used at Work | 1 Comment

http://blogs.baruch.cuny.edu/members/zr148419/

Here is link to my profile: https://blogs.baruch.cuny.edu/members/zr148419/

Posted in Profiles | Comments Off on http://blogs.baruch.cuny.edu/members/zr148419/