0
Microsoft Access
Microsoft Access is a database management system. Part of the Microsoft Office suite, Access can be used to edit data stored in various database formats, such as SQL (multiple varieties), Oracle, Excel, XML, etc. Questions about this software and how to use it belong here.
1,050 Questions
Printout is across the width of the page in access?
This is not a question, but my best guess of what you want to know is the word landscape.
Why use Ms access to create databases and why not use Microsoft Excel?
Access is a database. Excel is a spreadsheet. Both are useful to displaying data systematically, but a database is enormously more flexible. Access is a relational database, which is even more flexible than an ordinary database and permits the data to be manipulated in many ways.
+++
It's not "instead of" but "both" - using whichever is the better for the given work.
'
It does depend on your purposes. Excel is by far the better if you need only a single table, or if you need to embed a lot of mathematical formulae in the spread-sheet - though MS has ruined what had been its nearly-good graph routines. A database table looks like a spread-sheet page, but it lacks the rapid copying functions that are valuable features in Excel.
What is the maximum capacity of Microsoft Access 2010?
There is a 2GB limit in Access 2003 per MDB file. You can use multiple MDB files, however, and link them together to get beyond this limitation.
What are some examples of validation rules?
Validation rules limit what can go into a field. You might want to only allow values that are over 500 in a field, so the validation would be:
>500
You might want dates that are before the 1st of January 2010, so that would be like this:
<#01/01/2010#
What data validation rule is cautionary?
Data validation is all about what can be entered into a spreadsheet cell or database cell, you can choose an error message aswell as restricting what values can be entered, reducing human error and improving accuracy.
What is the purpose of report in Microsoft Access?
In the normal scheme of things you would enter data, then that is looked at. A report can be sent to screen or to a printer. It can give more details than looking at the table or at a standard query, such as giving subtotals and overall totals. It enables you to group things. It can be run from part or all of the database, so it can be based on tables or queries. Its output is intended to be printed, so it gives you appropriate options, such as page numbers, page headings etc.
What is the meaning of primary key in Microsoft access?
The primary key is the designation given to the field or fields that make a record unique in a table. Often times in Access an autonumber field is used as the primary key because Access will always generate a unique number for each record. Having a primary key is not a requirement but it is highly recommended that you have a primary key in each table.
What are the advantages of an SQL database as compared to a MS Access database?
There are many differences between Oracle and Access. First, you need to know that Oracle and Access are both relational database engines. Oracle is sold by Oracle Corporation and Access is sold by Microsoft. The biggest differences between the two are the size and number of users each supports. Oracle is a scalable enterprise database engine that supports from one to many (tens to hundreds of thousands) of simultaneous users. Access on the other hand is most commonly used as a single-user database but since the release of Access 97, can be augmented with Visual Basic code and can easily support 100+ simultaneous users (Top limit of 200 users). Oracle can support very large databases (Tens of Terabytes in size or larger), while Access is designed for much smaller databases in the 1 to 2 gigabyte size range. Oracle has a wide range of support features that can be used to monitor and tune database performance - Access is much more limited in its performance tuning capabilities. Microsoft's SQL Server rdbms is a direct competitor with Oracle and has a great many more similarities with Oracle. There are numerous incompatibilities between Access/Jet SQL and Oracle SQL, including, but not limited to the following:
1. The date delimiter is "#" in Access and " ' " (single quote) in Oracle and SqlServer.
2. In CHAR Datatype, Oracle returns trailing spaces. Access does not return trailing spaces in String data type. In Oracle, use VarChar2 Datatype.
3. Jet allows use of the "Join" keyword. Oracle uses "(+)" following the joined field(s). Join is not a recognized word in Oracle.
4. IIF() is allowed in Jet but in Oracle, you must use the DECODE function. See Oracle documentation.
5. The following functions in Jet must be translated in Oracle.
Mid(fld, 2, 2) - Substr(fld, 2, 2)
Left(2) - Substr(fld, 1, 2)
Right(n) - Substr( fld, Instr(...),n)
Len() - LENGTH()
Year(Fld) = 1997 - to_char(Fld, 'yyyy') = '1997'
Month(Fld) = 6 - to_char(fld, 'mm') = '06'
Trim(Fld) - LTrim() or RTrim()
6. Generally, you need to use "to_date('01/23/1978', 'mm/dd/yyyy')" to format a date for comparison in Oracle SQL whereas in Jet Sql you could simply use "#01/23/1978#".
7. "RENAME" is a reserved word in Oracle and is therefore an illegal field or table name, but not in Jet.
8. If a memory variable is used in a SQL statement, and the variable is a string with trailing spaces, Jet will trim the value before comparing to the database field. Oracle will not! Therefore, the following will work in Jet but not Oracle, assuming the Oracle field in VARCHAR[2].
Sql = " ... where fldname = 'abc ' ...."
9. Oracle SQL will not find uppercase data in the database if the value in the SQL statement is lowercase. Assume that the LastName field contains the value 'SMITH' in the Oracle table Policy. Access will make a find on the following SQL and Oracle will not (Like character would be "*" for Access.
select * from Policy where LastName Like 'smith%'
10. Conversion of Memo (Jet) fields to Oracle can be a problem. The only data type in Oracle that is analogous to the Memo in Jet is the Long. Although it can hold up to 2gb of string data, you cannot append more than approximately 5,000 characters to the existing Long field because you exceed the length of the maximum string length in an Oracle SQL Statement.
Additionally, you cannot use such expressions, as the following, usable in Jet, in Oracle. They result in the error, "Invalid use of Long Datatype."
select distinct LONGFLD
Length(LONGFLD)
It seems impossible to use a query to determine rows where there is data in the Long field since a Long field that has '' in it is not Null.
Oracle 8 has Append and Get Chunk commands, but the documentation in the Oracle 7.2 Book does not mention these functions, nor are there any examples of how to update a Long field that exceeds 5,000+ characters.
11. Use of the following sql can be extremely slow in Oracle.
select * from table where policy in
(select policy2 from table2 where .....)
Try using the Oracle Minus operator instead. It uses indexes where the "in (select...)" does not. See the Oracle documentation for usage of the Minus.
12. It is normal, when using Jet, to fill the recordsource property of a data control at design time, even if you are going to fill it with a specific SQL sometime after Form_Load. This is done in order to use the Grid Designer when a data control is bound to a Grid or Combo, etc. However, when the form loads, all such data controls are refreshed. If you have the table name as the data control recordsource, which would be normal for designer use, and assuming that dbSQLPassThrough is being used, the entire table is returned to the client machine and refreshed into the grid, even if the grid is not visible, i.e., on a different tab. In Jet, this will not be the case if "UseExactRow" property is not set and therefore will not take an inordinate amount of time, but in Oracle it could be disastorous!
An easy way to deal with this is to set the recordsource to "" in the Form_Load event, especially if you are connected to Oracle. Later on, your code will set the recordsource to the specific SQL as required. Note that this must be done in the Form_Load because the Grid will be refreshed by the time the Activate Event is fired.
13. Be aware that, when using dbSQLPassThrough, the entire recordset, specified by the SQL, is returned to the client machine, and is therefore readonly. At this point the recordset belongs to the client, and Oracle is out of the picture. In praticality, there is no difference between a Snapshot and Dynaset in passthrough mode.
14. Use of apostrophes (') in names and abbreviations are a problem in SQL. In Access, it may be circumvented by use of the double quote (") to encapsulate string data in the SQL statement instead of the apostrophe, thus allowing the use of the (') in the string. In Oracle, you can use two single quotes ('') to denote an apostrophe. The string below is valid in Oracle Sql.
... Set Lastname = 'O''Toole',...
15. In Access, an empty string ("") is not Null. Oracle's default parameter for Null is set to '' (double single quotes or empty string). In other words, Oracle, by default, treats an empty string field as Null. Therefore, the following code which works in Access, does not work in Oracle.
...Where RTrim(Fld) <> ''.....
In Oracle, change the SQL to:
... Where Fld is not null....
Also, the following sql will not work if a field is Null.
... Where THSTATE <> 'Z'...
Even though the field is null, and therefore <> 'Z', the row containing the Null field will not be returned. In order to get the row, you must enhance the SQL as:
...where (THSTATE <> 'Z' or THSTATE is Null)...
WHATEVER YOU THINK NULL IS, IT ISN'T!
16. When using dbSQLPassThrough with DAO, the RecordsAffected Property will always return -1, and there is apparently no way to determine whether any records were affected by an action sql or not.
17. When printing an error message from ODBC, if you print Error, as in the errors object, you will print "ODBC Call Failed", which is useless. Instead, print Errors(0).Description (or both) and you will get the true error description returned from the ODBC data source.
18. If you are having trouble with a bound data control returning less than the correct number of row, i.e., returns 100 rows when it should have returned 200 or more, set the DefaultCursorType to 1 (ODBC Cursor). For some reason this is not always required, but it will solve the problem of truncated recordsets in a data control connected to Oracle.
19. Access allows an Order By clause at the end of a query that uses a Union, but if you try this in Oracle, it will not work because Oracle ignores the column names in the result set from the Union. Not to worry! You can Order By column positions from the select statement. In other words, if Policy is returning in column 3 of the result set, and you want to order by Policy, then use "Order By 3..."
Explain the different object available in Microsoft Access?
Choosing Field Names Microsoft Access gives you lots of flexibility when it comes to naming your fields. A field name can be up to 64 characters long, and can include any combination of letters, numbers, spaces, and special characters except a period (.), an exclamation point (!), an accent grave ('), and brackets ([ ]); however, the name cannot begin with a space, and cannot include control characters (ANSI values 0 through 31).
In general, you should give your fields meaningful names and should use the same name throughout for a field that occurs in more than one table. You should avoid using field names that might also match any name interval to Microsoft Access or Visual Basic. For example, all objects have a Name property, so it's a good idea to qualify a field containing a name by calling it CustomerName or ClubName. You should also avoid names that are the same as built-in functions, such as Date, Time, Now, or Space. See Microsoft Access help for a list of all built-in functions names. For character data,
You should normally select the Text data type. You can control the maximum length of a Text field by using a field property. Use the Memo data type only for long strings of text that might exceed 255 characters or that might contain formatting characters such as tabs or line endings (carriage returns). When you select the Number data type,
You should think carefully about what you enter as the Field Size property because this property choice will affect precision as well as length. (For example, integer numbers do not have decimals.) The Date/Time data type,
Useful for calendar or clock data and has the added benefits of allowing calculations in minutes, seconds, hours, days, months, or years. For example, you can find out the differences in days between two Date/Time values.
Use the Date/Time data type to store any date, time, or date and time value. Currency data type,
For storing money values. Currency has the precision of integers, but with a fixed number of decimal places. When you need to store a precise fractional number that's not money, use the Number data type and choose the Decimal field size. The AutoNumber data type,
Specifically designed for automatic generation of primary key values. Depending on the Field Size and New Values properties you choose for an AutoNumber field, you can have Access create a sequential or random long integer. You can include only one field using the AutoNumber data type. Use the Yes/No data type,
Hold Boolean (true or false) values. This data type is particularly useful for flagging accounts paid or not paid or orders filled or not filled. The OLE Object data type allows you to store complex data, such as pictures, graphs, or sounds that can be maintained by a dynamic link to another Window-based application. For example, Access can store and allow you to edit a Microsoft Word document, a Microsoft Excel spreadsheet, a Microsoft PowerPoint presentation slide, a sound file (wav), a video file (avi), or picture created using the Paint or Draw application. The Hyperlink data type lets you store a simple or complex "link" to an external file or document. This link can contain a Uniform Resource Locator (URL) that points to a location on the World Wide Web or on a local intranet. It can also contain the Universal Naming Convention (UNC) name of a file on a server on your local area network (LAN) or on your local computer drives. The link can point to a file that is in Hypertext Markup Language (HTML) or in a format that is supported by an ActiveX application on your computer. For more details refer http://msaccess.batcave.net/page04.htm
How many table views are available in MS Access?
There are two main view
Datasheet View
AND
Desing View
OTHER'S
Pivot Table View
Pivot Chart View
A shop will use a database to keep an inventory of stock on the shelves. When stock levels reaches a certain point, automatic reordering may take place. Price control should also be enabled within the database.
Does form view displays a single record at a time?
to display only the records that meet the requirements in the access data what do you do.
What is A field that uniquely identifies a particular record in a table called?
A field that uniquely identifies a particular record in a table is called a primary key. The field or fields on which records are sorted is called the sort key.
What are the object-naming rules in ms-access?
Here are the "Object Naming Rules," as provided by the Microsoft Access Help File: --------------------------------------… Guidelines for naming fields, controls, and objects Names of fields, controls, and objects in Microsoft Access: Can be up to 64 characters long. Can include any combination of letters, numbers, spaces, and special characters except a period (.), an exclamation point (!), an accent grave (`), and brackets ([ ]). Can't begin with leading spaces. Can't include control characters (ASCII values 0 through 31). Can't include a double quotation mark (") in table, view, or stored procedure names in a Microsoft Access project. Although you can include spaces in field, control, and object names, most examples in the Microsoft Access documentation show field and control names without spaces because spaces in names can produce naming conflicts in Visual Basic for Applications in some circumstances. When you name a field, control, or object, it's a good idea to make sure the name doesn't duplicate the name of a property or other element used by Microsoft Access; otherwise, your database can produce unexpected behavior in some circumstances. For example, if you refer to the value of a field called Name in a table NameInfo using the syntax NameInfo.Name, Microsoft Access displays the value of the table's Name property rather than the value of the Name field. Another way to avoid unexpected results is to always use the ! operator instead of the . (dot) operator to refer to the value of a field, control, or object. For example, the following identifier explicitly refers to the value of the Name field rather than the Name property: [NameInfo]![Name] --------------------------------------…
How can you create table using datasheet view?
When you open Access, Select NEW. The New tab provides several ways that you can create a new database including "TABLE View" which then looks like a datasheet
What does the mean in Microsoft Access?
The * symbol is a universal wildcard symbol. In the Access Query By Example Design Pane, the * represents all fields in the table or query.
Direct access.
AS
It is a query that returns the data in a tabular form, similar to a pivot table in a spreadsheet. There are headings across the top and down the side. A typical example would be counting how many staff in each department are male and female. You could have the headings of the departments down the side and the headings for male and female across the top. Then there would be a total for each gender in each department.
What impact did the first computer have on society?
Personal computers have really changed the way we communicate with one another. Just look at these social media websites like Facebook, for example, where one can message another without leaving the comfort of their own home and instantly too. Personal computers simplify everything in our lives. Typing documents, finding calculations, watching movies, playing games. All of it is done on a personal computer.
How do you Access MS Access from C?
The following example creates an OracleConnection and sets some of its properties in the connection string. * ** Syntax based on .NET Framework version 1.1 ** #using #using #using using namespace System; using namespace System::Data; using namespace System::Data::OracleClient; __gc class COracleConnection
{ public:
void CreateOracleConnection( )
{ String* myConnString Oracle8i;Integrated Security new OracleConnection( myConnString ); myConnection->Open( ); MessageBox::Show( String::Format( S"ServerVersion: {0}\nDataSource:{1}", myConnection->ServerVersion, myConnection->DataSource ) ); myConnection->Close(); } }; // This is the entry point for this application #ifdef _UNICODE int wmain( void ) #else int main( void ) #endif { COracleConnection *pCOracleConnection = new COracleConnection(); pCOracleConnection->CreateOracleConnection( ); return 0; } You will use Oracle's API. Its called OCI for Oracle Call Interface -- use Google for details about its usage. You can also use OTL, which is the Oracle Template Library. Its much easier to use than OCI. Additionally, you can use embedded sql and precompile this code into pure C using the Oracle Pro*C/C++ precompiler. Sample code exists in ORACLE_HOME/precomp/demo/proc and ORACLE_HOME/rdbms/demo. As Oracle is the largest database company in the world with the largest market share of enterprise s/w, you can bet there is code all over the internet to do what you want to do. Check the forums at otn.oracle.com, google (or other search engine), or asktom.oracle.com. Answer You can also use library such as OCILIB (wraper for OCI) and Libsqlora. The other solution is use UnixODBC for unix programming environtment. Visit www.alldatabaseprogramming.blogspot.com or www.gtkinaction.blogspot.com for further information.
Which data type stores only one of two values?
In Java, such a data type is called boolean. In other programming languages it may be known by different names, including variations of "boolean" such as "bool", and "logical".
What is access management system?
Access Management is concerned with the management of people's rights of access to information, and as such has common purpose not only with Information Security Management, but also with Availability Management, giving practical effect to the policies and requirements of both processes. Its goal is to ensure that the confidentiality, integrity and availability of information are effectively managed across the organization. Data and information must not only be protected against unauthorized access and the possibility of it being stolen or changed. It must also be readily available to those who are authorized to access it.
A key part of Access Management is the management of people's rights to access information and services. People who have the right, in terms of business policy and need, to access information should have that right implemented through access controls. These rights must be consistent with relevant legislation such as data protection legislation, and must be kept under review and changed or revoked when a person's status changes within the organization, or when a material risk is identified.
Difference between design view and wizard?
In design view you have to do all the work to create something yourself, like design view for tables or forms or queries or reports. This is good if you know what you are doing and are experienced. A wizard will quickly create a basic item. It is fast, but it does not necessarily give you all you need. Some users will use the wizard to create the basic structure and then use design view to add in the specific things they need to do what they want. The wizards are good for forms and reports, but you are more likely to use design view for tables and queries.
