-
Recent Posts
Recent Comments
- kc147103 on How people are using Access at work
- kc147103 on How people are using Excel at work
- Olesya Malkiyeva on Excel
- Cat Tran Nguyen (Kate Ng) on Observation of Using Access in Whole Sale Companies
- Julissa Arno on How people use Microsoft Access at work?
Archives
Categories
Meta
Author Archives: zr148419
Posts: 5 (archived below)
Comments: 1
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/