Exam 77-424: Microsoft Access 2013 Interview Questions

Exam 77-424: Microsoft Access 2013 is developed for those candidates who have a basic understanding of the Access 2013 environment and have the ability or skills to complete the tasks independently. They are expected to know and demonstrate the appropriate and accurate application of the principal features of Access 2013.

1.) In MS Access, what are the various file extensions?

Ans. The six file extensions in MS Access are as follows:

Access workgroup.mdw
Access database.accdb
Access Workgroup.mdw
Access blank project template.adn
Access project.adp
Protected access database.accde

2.) What is a Microsoft Access database, and how does it work?

Ans. Microsoft Access is a relational database management system that combines a graphical user interface (GUI) and the Microsoft Jet database engine. It can import and use data from a variety of sources, including Access, SQL, Oracle, and others. This program is utilized in the development of application software.

3.) How may explicit data be linked to an Access database?

Ans. To link explicit data into an Access database, follow the steps below:

Navigate to the main menu and select EXTERNAL DATA from the Import and Link group.
Import the necessary file.
To learn about the file that can link Access databases, follow the instructions in the Get External Data wizard.

4.) What are some of the most essential MS Access applications?

Ans. MS Access can be used in a variety of ways.

When the backend is an ODBC-compliant product, MS Access is used as the frontend.
MS Access is commonly used for web-based database applications that are hosted on IIS using ASP.NET pages.
It is mostly used by small enterprises and organizations, as well as specific divisions within larger organizations and individuals, to construct desktop data applications.
It can be used as a rapid development environment (RAD) for developing standalone applications and prototypes.

5.) What is the meaning of a super key? What distinguishes it from a candidate key?

Ans. A superkey is a set of table properties whose values can be used to identify a tuple uniquely. A candidate key, on the other hand, is a set of qualities that are required to identify a tuple.

A minimal super key is another name for a candidate key.

6.) What is the maximum database size for Access?

Ans. The database size limit for Access 2.0 is 1 GB.

7.) What method is employed to expand the database’s size?

Ans. Replication is a technique for expanding the size of a database.

8.) In Access, how do you maintain a relationship across several databases?

Ans. When a relationship between two databases is established, the first table of one database is treated as a primary key, while the new field in the other database is treated as a foreign key.

9.) What are the different types of queries in MS Access?

Ans. Queries are requests that are used to conduct various actions on data, such as sorting, inserting, retrieving, updating, and deleting data.

10.) What are the different types of relationships that exist between different types of data?

Ans. Only three sorts of associations can be formed using the data in the table:

One-to-one relationship: This relationship states that only one table item can be linked to another table item.
One-to-many relationship: This relationship states that one table item can correspond to more than one table item.
This connection indicates that more than one item from one table can correspond to more than one item from another table.

11.) What security features does MS Access have?

Ans. MS Access security features are used to lock and safeguard particular documents. If you don’t want to update a document, you can protect the data and code by changing the file system extension to.MDE. The MDE extension files are the only ones that can be modified. Although there are tools available on the market to decompile and unlock code, any changes done to VB scripts are permanent.

12.) In MS Access 2013, how do you make a form?

Ans. To construct a form, follow these steps:

To construct a form, go to the table you wish to use.
Then go to the Create tab and look for the Forms group.
After clicking the Form Command, a form will be built and displayed in the Layout view.
Save the file with a specific name by clicking Save on the Quick Access toolbar.

13.) What are the benefits of using a pivot table?

Ans. A pivot table is a type of table that is used to improve the display of data. You can view data in multiple dimensions using a pivot table. A pivot table can be used to summarise data by categories and to highlight trends across many categories.

14.) In MS Access 2013, how can you make a simple query?

Ans. To generate a basic query, follow these steps:

Database that can be accessed.
Select the -create tab.
Navigate to the icon for the query wizard.
Choose a query type from the drop-down menu.
From the pull-down menu, choose the appropriate table.
Now, from the query results, select the required field.
By repeating steps 5 and 6, you can insert data from additional tables.
Continue to the next step.
Select the end effect you want to achieve.
Your inquiry should have a title.
Now press the Finish button.

15.) What is the best way to export data in Excel format?

Ans. To export data in Excel format, follow the procedures below:

Select the External Data tab from the toolbar.
Go to the Export group in Excel now.
The Excel spreadsheet dialogue box will appear on your screen after that.
It is now necessary to supply the file’s name and format as well as the destination.
Click the OK button. The information will now be exported to an Excel spreadsheet.

16.) In MS Access, what is the purpose of the WHERE clause?

Ans. The WHERE clause is used in conjunction with the SELECT statement to retrieve a value based on a set of criteria.
By employing LIKE keywords, the WHERE clause can be used to combine distinct fields of incompatible data types where one field is used as a condition for another field.

17.) What are the benefits of Microsoft Access over Microsoft SQL Server?

Ans. Some of the advantages of MS Access over MS SQL Server are as follows:

MS Access is a lot easier to work with.
Because the client may read and write directly into the raw data table, MS Access is more dependable.
When the number of users is low, MS Access is more scalable.
MS Access is less expensive and more versatile.
format d
Click the OK button. The information will now be exported to an Excel spreadsheet.

18.) In MS Access, what is the purpose of the WHERE clause?

19.) What are the benefits of Microsoft Access over Microsoft SQL Server?

Ans. Some of the advantages of MS Access over MS SQL Server are as follows:

MS Access is a lot easier to work with.
Because the client may read and write directly into the raw data table, MS Access is more dependable.
When the number of users is low, MS Access is more scalable.
MS Access is less expensive and more versatile.
format d
Click the OK button. The information will now be exported to an Excel spreadsheet.

20.) Do you think you could easily automate your MS Access database with menu-driven selections?

Ans. Create a form with customised buttons that point to macros to accomplish this. Using MS Access’ built-in function “Switchboard Manager” is a simpler option. This can be found in the Tools/Add-Ins folder.

21.) What is the significance of MS Access?

MS Access has simple import and export options.
MS Access is used by business professionals.
MS Access is used by programmers. The database is used by the programmers.
MS Access is used by the majority of businesses to arrange their data.
In schools and universities, Microsoft Access is used to keep track of student and teacher information.
MS Access is a low-cost programme.
MS Access is designed to work in conjunction with other Microsoft Office products.
MS Access provides a Jet Database Format that combines the application and data into a single file.
MS Access has a number of features, including scalability and legacy data.

22.) Name What Are The Different Types Of Database Management Systems?

Database for Networks.
Database with a hierarchical structure.
A relational database
Database that is object-oriented.

23.) Is It Possible To Make A Simple Query In MS Access 2013? If so, how would you go about doing it?

Select the Create tab from the drop-down menu.
A new Query window appears when you select Query wizard from the Query group.
Select Simple Query Wizard from the drop-down menu and click OK.
Choose the table you wish to use for your Query from the drop-down menu. Take, for example, the Employee table.
To proceed, select the fields you wish to work with in the Query and click next.
Give your Query a name and click Finish.

24.) What may the Alter Table Statement in MS Access change?

Use “ADD COLUMNS” to add a new field to a table.
ALTER TABLE Customers ADD COLUMN Email TEXT, for example (25)
We’re trying to add a new field to the customer table named email.
Use “ALTER COLUMN” to modify the data type of an existing field.
ALTER TABLE Customers ALTER COLUMN ZipCode TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TE (10)
We’re changing the zipcode field in the customer table from numeric to text.
Use “DROP COLUMN” to remove a field.
Use “DROP CONSTRAINT” to remove a multiple-field index.

25.) In MS Access, what are joins?

Ans. In MS Access, joins are used to establish relationships between tables.

There are four joins in total.

Inner Joins
Joins on the outside.
Cross Joins
Joins that are unequal.

26.) How is MS Access superior to MS SQL Server?

Ans. MS Access is simple to use and suitable for desktop use with a small number of users.
When compared to MS SQL Server, it has a lot of compatibility and sharing features.
SQL server is typically used by developers, while MS Access is less expensive than SQL server in larger organisations.
MS Access necessitates less database management.

27.) What should be considered when designing lookup fields?

Ans. If you wish to show lookup values rather than lookup ids, make sure you relate tables, links, and so on. A relevant table should be linked to the destination field in order to display lookup values.

28.) What Do You Mean By Managing Data Tasks?

Ans. Import text wizard and export text wizard functionalities can be used to handle data. You can save the operation for later use in this section. After editing the specification name, you can make changes to the text box by clicking it. By clicking and altering the modifications in the text box, the path can also be altered. Changes to the file name description can be done by typing something in the text box and then pressing enter to save the changes to the path, specification name.

29.) What are some of the applications of the append query?

Ans. The following are some examples of how to utilise an add query.
Rather than manually updating a table, add data to an existing table to save time.
It is possible to append files based on certain criteria.
If your destination file lacks columns and rows, you can add specific columns and rows while disregarding the rest.
When dealing with big database updates, Append can save time and effort.

30.) What Steps Did This Message Could Not Delete From The Specified Tables Require?

Ans. When the unique property is set to no, the remove query causes this error.
The steps to solving the problem are as follows.

If the delete query does not open, press F4 to force it to open.
You can get more options by clicking the query properties button beneath the query designer.
You must locate the unique records property and set it to yes in that option. The query property sheet has these choices.

31.) What is the difference between using the Report Tool and the Report Wizard to create a report tool?

Ans. The report tool makes a report quickly because it does not require a lot of information from you. It shows the complete field, but it might not be the refined data source you want. The Report Wizard allows you to generate a table by allowing you to choose what should and should not appear in the table. The tables’ relationships, grouping, and ordering can all be specified.

32.) What is the purpose of the security features in Ms Access?

Ans. If a programmer does not want to make modifications to the document, he can lock the data and code of the document by changing the file system extension to.MDE. Only the file with the extension MDE can be modified. Although there are tools available to unlock and decompile the code, some changes to VBA or VB scripts are irreversible.

33.) What Is The Best Way To Import A Sharepoint List?

Ans. When you import a sharepoint list into an Access database, you have a lot of possibilities. After creating a copy in the Access database, you can choose which lists you want to transfer. You can also choose to copy the full list or only a specific file. In addition, the import procedure produces a table in Access that copies all of the requested fields and entries.

34.) What if both the source and the destination have the same name?

Ans. Any existing tables or objects are not overwritten or modified by the MS Access import operation. If the source and destination files are the identical, it ensures that the source file’s name is appended with numbers. A table with the name info, for example, will be renamed to infol.

35.) What are the objects in the Microsoft Access database table MsysObjects?

Ans. The MsysObjects table in Microsoft Access contains the following objects.

Connect
Database
DateCreate
DateUpdate
Flags
ForeignName
Id
Lv
LvExtra
LvModule
LvProp
Name
Owner
ParentId
RmtInfoLong
RmtInfoShort
Type