Question

1. Explain the features of Microsoft Access...2. Define database and name their types...3. Differentiate between OLE and HyperLink...4.How will you sort the data within a table...5. Define: (i )Table with respect to MS Access. (2 )Primary key. (3 ) Field Property (4 )Report (5 )data

Answer 1

1 answer is :
Ideal for individual users and smaller teams.
Easier than client - server database to use.
Allows building and publishing web databases effortlessly.
Allows output reports in PDF format.
Ready templates for regular users to create and publish data.
2 answer is:
A database is an organized collection of data.
3 answer is:
OLE displays the contents of one file in another whereas hyperlinks are shortcut to locations like data files, web pages etc. that allows you to quickly jump at that location.
4 answer is :
Is there in the picture I attached.
5 answer is:
a) MS Access tables are key points in the access file,as they contain the data that is stored in the database.
b) A primary key is a special relational database table column designated to uniquely identify all table records.
c)The properties of a field describe the characteristics and behavior of data added to the field.
d)A report is an object in MS Access used to display and print your data in an organized manner.
e) Data is information processed or stored by computer.