What is Microsoft Access database?
Microsoft Access database is a relational database management system which combines GUI (Graphical User Interface) with Microsoft Jet database engine. It can import and use data from Access, SQL, Oracle, etc.
This software is used to build application software.

How you can import data from other sources into Access database?
To import data into Access data-base
  • In the main menu, click on EXTERNAL DATA, in the Import and Link group
  • Choose the type of the file you want to import
  • To know which type of file can be import or link Access database, follow the instruction in the Get External Data wizard
What are the several file extensions in MS Access?
Following are the six file extensions in MS Access:
  • Access workgroup.mdw
  • Access database.accdb
  • Access Workgroup.mdw
  • Access blank project template.adn
  • Access project.adp
  • Protected access database.accde
What is the size limitation for an Access database?
The size limitation of Access 2.0 database is 1 gigabyte.

Which technique is used to increase the size of database?
Replication is used to increase the size of database.
What are the most important uses of MS Access?
  • MS Access is used as frontend when the backend is product of ODBC compliant.
  • MS Access is widely used for small database applications that are based on web and hosted on IIS by making use of ASP.NET pages.
  • Mainly, it is used by small firms and businesses, specific departments in large organizations and some people for developing applications on desktop for data applications.
  • It can be used as RAD while developing standalone applications and prototype.
What is a super key? How is it different from a candidate key?
A superkey is a set of attributes within a table whose values can be used to uniquely identify a tuple. On the other hand, a candidate key is a minimal set of attributes mandatory to identify a tuple.
A candidate key is also called a minimal super key.

What type of relationship can be formed between different data?
The data within the table can build three types of relationship:
One-to-one relationships: This relationship specifies that a single data in one table is linked with a single data in another table.
One-to-many relationship: This relationship specifies that a single data in a table is linked to several data in another table.
Many-to-many relationship: This relationship specifies that several data in one table is related to several other data in another table.

What are the protection features of MS Access?
MS Access protection features are used to protect some documents by locking them. If you do not want to change some document then you can lock the document containing data and its code from modifications by changing file system extension to .MDE. Only the MDE extension files can be changed. One can find specific tools in the market that can be used to decompile and unlock code but changes made to VB scripts are permanent.

How can you build a relationship between the different databases in Access?
When a relationship is established between two data, the first table for your data is referred as the primary key while the new field in another data is called a foreign key.

What are queries in MS Access?
Queries are used as a medium of manipulating the data to display in the form or report. Queries are used to insert data, update data, delete data, sort, calculate, filter, join etc.

How to create a simple query in MS Access 2013?
  • Open your database.
  • Go to -create tab.
  • Click on the query wizard icon.
  • Select a query type.
  • From the pull-down menu choose the appropriate table.
  • Select the field you want in the query results.
  • To add information from additional tables, repeat steps 5 and 6
  • Click on next.
  • Choose the type of results that you would like to produce.
  • Give your query a title.
  • Click on finish.
How can you export data in Excel format?
  • Go to the toolbar, click on the External Data tab.
  • Click Excel on the Export group.
  • It will open the export excel spreadsheet dialog box.
  • Specify the destination of the file name and format.
  • Click OK to export the data to Excel spreadsheet.
How can you create a table using Microsoft Access Object Library?
To create a table using MAOL, take a variable of type object and then initialize it with the CreateTableDef() method of the recent database object. This technique takes argument as the name of the table.

How can you create a form in MS Access 2013?
Forms are used to insert data across multiple tables. There are a lot of methods for creating forms but with Form Wizard method, you can always modify the form later using Design View.
Follow these instructions to create a form:
  • Go to main menu, click on CREATE and then choose the FORM option.
  • It will create a new form in Layout view, based on the fields in the Customer table.
  • Scroll the drop down arrow under the View icon and select Form View. By this user will see the form.
  • On the form, you will see fields like CustomerId, First Name, Last Name and Date Created etc.
  • After filling of all details in the form, you can see the newly created record with data in the table.
  • Once you completed filling the field in the form, click on the save button on the top of the ribbon.
What is the use of Pivot table?
Pivot table is used for improving the presentation of data. By using Pivot table, you can view data multi-dimensionally. A Pivot table can summarize the data by categories and display trends spread over a range of categories.

What are the several methods to enter data in MS Access 2013?
Different methods to enter data in MS Access are:
  • Datasheet View
  • Form
  • SQL View
  • Import from External Data (XML, Data Services, HTML etc.)
Would you easily automate your MS Access database through menu driven selections?
You can do it by creating a form with customized buttons that point to macros. An easier way is to use MS Access' built in function called "Switchboard Manager". This can be located in Tools/Add-Ins.

What is the use of WHERE clause in MS Access
WHERE clause is used with the SELECT statement to retrieve a value with certain criteria. For example, if you want to find the address of a particular customer, but you only remember his last name that is Kumar. So, instead of searching all the fields in the table, use WHERE clause to retrieve the address of the customer.
WHERE [LAST_NAME] = 'Kumar'
It’s not possible to link or join fields that have dissimilar data types. To link data from two different data sources, depending on values in fields that have different data types; a WHERE clause is created that uses one field as a criteria for the other field, by using LIKE keyword.

What are the advantages of MS Access over MS SQL Server?
  • With a small number of users, MS Access is easy to handle and suited for desktop use.
  • Compatibility and sharing is easy in MS Access as compare to MS SQL Server.
  • Generally, SQL server is used by developers and in a bigger organization.
  • MS Access is cheaper than MS SQL.
  • MS Access requires less database administration.
How we can do multi-join query in MS Access?
In Access, we can only join two tables, in order to join more tables, you require to group the first join together by using parentheses, as if it was a newly derived table.  After that, you can join another table to that group.
Select
*
from
( ( Table 1
LEFT JOIN Table 2…
)
LEFT JOIN Table3…
)
LEFT JOIN Table4…

How MS Access is better than MS SQL Server?
  • With a small number of users, MS Access is easy to handle and suited for desktop use
  • Easy compatibility and sharing compare to MS SQL Server
  • SQL server is, usually, used by developers and in a bigger organization
  • MS Access is cheaper than MS SQL
  • MS Access requires less database administration
What things to be taken in consideration for lookup fields?
Look up fields: Ensure that you relate tables, links, etc. if you want to show look up values and not look up ids.  For the display of lookup values, related table should be linked to the destination field.
Request to Download PDF

Post A Comment:

0 comments: