answersLogoWhite

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

How do you add text files to a MS Access database?

There are two methods to add a text file to a MS access Database.
1) Link the text file. Go to File/Get External Data/ Link Tables. In the link file screen change the file type to Text file and then browse to the text file and select your text file. MS Access will prompt you to give the specs of the file when you are linking it. 2) Import the file to an access table. Go To File/Get external Data/ Import. In the screen change the file type at the bottom to text, and select your text file.

What is a primary sort field?

The sort order specified in thefirst field is taken as the primary sort field and the other are taken as the secondary sort fiels

If you delete query does it delete the original information in the table?

Your question is unclear. If you mean if you delete a query, then it does not affect the data in the table. Deleting any kind of query does not affect the data in any table it uses. If you mean if you run a Delete query, then yes the data in the table will be deleted. That is what Delete queries are for.

How do you make MS Access reports look professional?

What I personally do is avoid using a lot of colors and images, also avoid using a lot of font style, 2-3 font styles is all you really need, it will help create coherence to the overall look of your form and then finally use grid so that forms will look very uniform in size and controls are aligned properly.

The rest will come down to your personal taste, as to what color, style and kind of branding you like.

When and where the MS access developed?

WHEN:

In November 1992, Microsoft launched The Microsoft Access version 1.0. Then in May 1993 they launched a newer version Access1.1 which had an improved compatibility with the other products of Microsoft. Later they introduced the Access v2.0 which required MS Windows v3.1 having 4MB RAM space and 8MB space on the hard disk. As the Windows95, 98 and ME became obsolete and newer improved versions came into market, the Access database system was also modified for better workability. With the introduction of MS Office 95, MS Access95 also joined the MS Office Professional Suite along with Excel, Word and PowerPoint. With improvement in technology over the years, Microsoft Office programs were also modified and so did the MS Access. The consecutive release of modified versions includes Access 97, Access 2000, Access 2002, Access 2003 and Access 2007.

What is a leftmost column?

It is the first column in a table on the left. In a spreadsheet it would be column A. In Access it would the column for the first field. In a table in Word, it would be the first column on the left.

Is Microsoft Access reusable?

No, you have to buy a different license for every database that you want to access.

What is the most user friendly database software?

Finding database software that is user-friendly is critical to the success of any project. Some of the more popular and easy-to-learn software products are FileMaker, Intuit QuickBase, and Microsoft Access.

What is an 8 column worksheet?

A work sheet is an informal business form prepared in pencil on columnar book-keeping paper, used to organize and plan the information for the financial statements. An 8 column worksheet includes the trial balance, adjustments (new two columns) the income statement and the balance sheet. The adjustments column includes late invoices and adjusting/closing entries.

What does yes and no mean in Microsoft Access?

A Yes No field is for storing data with a Yes/No or True/False kind of answer. You could have a field like Married, yes or no.

A Yes No field is for storing data with a Yes/No or True/False kind of answer. You could have a field like Married, yes or no.

A Yes No field is for storing data with a Yes/No or True/False kind of answer. You could have a field like Married, yes or no.

A Yes No field is for storing data with a Yes/No or True/False kind of answer. You could have a field like Married, yes or no.

A Yes No field is for storing data with a Yes/No or True/False kind of answer. You could have a field like Married, yes or no.

A Yes No field is for storing data with a Yes/No or True/False kind of answer. You could have a field like Married, yes or no.

A Yes No field is for storing data with a Yes/No or True/False kind of answer. You could have a field like Married, yes or no.

A Yes No field is for storing data with a Yes/No or True/False kind of answer. You could have a field like Married, yes or no.

A Yes No field is for storing data with a Yes/No or True/False kind of answer. You could have a field like Married, yes or no.

A Yes No field is for storing data with a Yes/No or True/False kind of answer. You could have a field like Married, yes or no.

A Yes No field is for storing data with a Yes/No or True/False kind of answer. You could have a field like Married, yes or no.

When you data from Access to Excel a copy of the data is created in Excel?

You can copy data from Access and paste it directly into Excel. From a table or query, data can be selected and then copied and pasted into Excel. In that case, data changing in the original Access file will not change data in the Excel file. To do that there must be a link between the data. You can also import data from Access into Excel and from Excel into Access, again maintaining a link to the source if you want.

How do you answer customer query?

Listen and make sure you get all of the information. Details can make a difference. After you look into their request, be sure to have a follow up communication, and follow through on any commitments you made.

How do you decide when to use Excel or Access database program?

You would use Access when you want to create a database. A database is a file full of organised data. It is a structured set of records comprising a large amount of data or information, which is usually related. It can be a Manual Paper Work collection or Electronic Computer Data. A database is a collection of records organized so that data can be easily retrieved. When you want to deal with lists of data and be able to organise it and retrieve information, that is when you would use Microsoft Access or another database application.

Excel is for creating spreadsheets. Spreadsheets are used for numerical analysis and manipulation. When you have a lot of numbers and you want to do calculations on them, then it is best to use a spreadsheet. It also allows you to do things like create charts and to try different combinations of numbers to see what the effects are of having different values, like how much a company can make if they were to increase the amount of their products that they manufacture and sell.

There are things that both a spreadsheet and a database can do. You can use a spreadsheet to do some databasing operations and you can use a database to do some spreadsheet operations, but you would pick the one that is most suited to the task you want to do. If you are mostly dealing with numbers and doing lots of calculations, it is usually best to use a spreadsheet. If you are dealing with lists of data, like a list of people's names and addresses, then it is best to use a database.

How do you insert a new row in dbms?

Database rows are held in a structure called table (there are several types of tables).

Each table is comprised from columns, defined by name and data types. One has to use the Structured Query Language (SQL), in order to perform data changes, using DML (Data Manipulation Language), such as INSERT (adding), UPDATE (changing) and DELETE (removing) data.

What is the maximum number of characters a text data type can contain?

Now, depending on what you are asking it can contain a configuration of 1000-2500 words. It also depends on the file format; but if you are using a microsoft technologic computer system it may be more.

Why do you need Microsoft Access especially if you have Microsoft Excel?

Microsoft Access is a database application and Microsoft Excel is a spreadsheet application, so they are two different kinds of application. There are things that both can do, but if you want to create a proper database, then Access is better than Excel. It has far more facilities for working with databases than Excel does. Because of that, it is simpler to do lots of things in Access than in Excel. If you want to create a spreadsheet, then that is what Excel is used for, though you can do a lot of things Excel does in Access. If you already have Excel and want to create databases, then you can, but you won't be able to do the really sophisticated things that Access can do and which a really good database needs, such as queries, reports, relationships etc. If you want a really good database that can do those things, then you need Access.