1) Explain how you can import data from other sources into Access database?
To import data into Access data-base
2) Explain what is the size limitation for an Access database?
The Access 2.0 database has the size limitation of 1 gigabyte.
3) Between different data’s what are the types of relationship can be formed?
The table contains your data can build three types of relationship
4) Explain how you can build a relationship between the different databases in Access?
When you establish a relationship 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.
5) Name some of the file extension for MS Access?
Some of the file extension for MS Access are
6) Explain what do you mean by queries?
Queries are the medium of manipulating the data to display in the form or report. Queries can join tables, update data, delete data, sort, calculate, filter, etc.
7) Explain what joins are and how you can open the database in Access?
Joins determines the relationship between tables in Access by stating the details of the relationship between two tables. You can create joins on the database tools tab or by opening a query in design view.
8) Mention how you can create a simple query in Access 2013?
9) Explain how you can export data in Excel format?
10) Explain how you can create a table using MAOL (Microsoft Access Object Library)?
To create a table using MAOL, you have to pronounce 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.
11) Explain how you can create a form in Microsoft Access 2013?
Forms allow to insert data across multiple tables. There are different methods for creating forms but with Form Wizard method, you can always modify the form later using Design View. To create a form
12) In MS Access 2013 what are the different ways you can enter data?
Different methods you can enter data in MS Access are
13) Explain the use of WHERE clause in MS Access SQL?
WHERE [LASTNAME] = ‘Harrison’
14) Explain 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.
( ( Table 1
LEFT JOIN Table 2…
LEFT JOIN Table3…
LEFT JOIN Table4…
15) Explain how MS Access is better than MS SQL Server?
16) 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.