background preloader

Microsoft Access

Facebook Twitter

BannerAccess - Reporting from SCT's Banner using MS Access. Oracle 11g Instant ClientWe installed the Oracle 11g Instant Client on one PC and copied that install to additional PCs.

BannerAccess - Reporting from SCT's Banner using MS Access.

This saved a lot of installation time and reduced errors. If you have the Oracle 9i Client installed on the PC, it must be removed using the Oracle Universal Installer before installing either 10g or 11g. This Oracle 11g Instant Client install for ODBC is the most successful Oracle Client setup instructions that we have ever passed on to our technical support team for installing new machines. The instructions including screen shots is just over two pages. (Works fine with Oracle ODAC 12c too, but you will need to run the full Universal Installer to get just what you need.) MS Access 2007By default, the Enhanced Security on MS Office 2007 wants you to OK the running of your MS Access DB each time you start it. Setting up the MS Access db as trusted is done in Office 2007 under the "Office Button", Now, you can add the location.

**Profile Reports--It Can Be Done! DBA Stuff. Access ODBC link to Oracle - UtterAccess Forums. How to Split an Access Database. In a follow up to our previous article about the Top 10 Reason to Split an Access Database, this post will give you the quick and easy way to get started with the process.

How to Split an Access Database

Splitting an Access database is essential when sharing a database via internal network our cloud hosting. If you have ever received errors when multiple users are editing your Access database, it is likely that you are not operating with what is called a split-database. When splitting a database, you reorganize it into two separate files. The front-end database contains all the objects such as queries, forms, and reports while the back-end database contains all of the data tables. Reset page number of total pages in group. Reports: Printing First and Last Page Numbers for Report Groups. Often times it is necessary to print page numbers for groups of records, and not just the overall pages for a report.

Reports: Printing First and Last Page Numbers for Report Groups

Access has no built in way to do this, and some workarounds can be very cumbersome. Here's a simple code sample that does the job well, using arrays to handle the group page numbers; an often overlooked method of handling multidimensional data. Open any report in design view and open its Code-Behind-Reports module. How to: Create and customize a web app in Access. To understand whether the schema and views meet your needs, you should examine them.

How to: Create and customize a web app in Access

The tables created by selecting the Issues schema are displayed in the Tile Pane. The Issues, Customer, and Employees tables are the main focus of the app. The Issues table stores information about each issue. Each issue is opened by and assigned to an employee on behalf of a customer. Extracting URLs from Hyperlinks. By Allen Wyatt (last updated April 29, 2014) Please Note: This article is written for users of the following Microsoft Excel versions: 97, 2000, 2002, and 2003.

Extracting URLs from Hyperlinks

If you are using a later version (Excel 2007 or later), this tip may not work for you. For a version of this tip written specifically for later versions of Excel, click here: Extracting URLs from Hyperlinks. Mezga has a series of cells that contain hyperlinks. These hyperlinks consist of words such as "click here" or "more information. " Without using macros, you can do this: Right-click a hyperlink. Figure 1. Select and copy (Ctrl+C) the entire URL from the Address field of the dialog box.Press Esc to close the Edit Hyperlink dialog box.Paste the URL into any cell desired. DSUM() function –The Art of Writing a Criteria : 1.

As you learn more in MS Access, you will find that DSUM() function or for that matter any other domain aggregate functions such as DAvg(), DCount() etc. have interesting applications in data analysis.

DSUM() function –The Art of Writing a Criteria : 1

Now, these functions are very easy to understand in terms of what they do but the only confusing part is the criteria part of the function. I have seen many people including myself getting a bit uncomfortable and making silly mistakes while constructing the criteria in this function. In this post, you will learn what exactly does DSUM() function do and more importantly how to construct the criteria properly. So, lets begin…… DSUM() function as the name suggests is a function which helps you to sum the field (i.e. a column) specified in a particular table based on a certain criteria, if required. The function is as follows : As can be seen from above, there are two ways in which you can write a DSUM() function: Lets look at each of the two ways of working with DSUM() function.

Text Number Date. Microsoft Access database tutorial. So, you want to know how to use MS Access to create a powerful business database.

Microsoft Access database tutorial

The first question is: What is Microsoft Access? MSAccess is a Database Management System. It handles data management tasks the same way as MS Word handles document management and MS Excel handles statistics ... A database is a collection of objects that allow you to store data, organize it and retrieve it in any way you want.