What is Report?
How will you print a Report?
B. Explain the term Database with their type.
C. Explain the different types of features of MS Access.
D. What is primary key. Explain step by step how we can set the primary key in a table.
E. What is the difference between a file and a database?
Answers
Answer:
Print select pages from a report
Click File and then click Print. On the Print area of the File options, click the Print option to open the Print dialog box. To print only some of the data in the report, under Print Range, click Pages, and then enter a value in the From and the To boxes.
Explanation:
b. Operational database. ... Relational database. Cloud database. Object-oriented database
c. Microsoft Access Features;
Easier than a client-server database to understand and use. Import and export to other Microsoft Office and other applications. Ready templates for regular users to create and publish data. Allows building and publishing Web databases effortlessly.
d. Create a primary key to associate data between multiple tables.
In the Navigation Pane, right click a table, and select Design View.
Select the field or fields you want to use as the primary key.
Select Design > Primary Key.
e . Answer: A data file is a collection of related records stored on a storage medium such as a hard disk or optical disc. ... A database is a collection of data organized in a manner that allows access, retrieval, and use of that data.
Answer:
A) A report is a specific form of writing that is organised around concisely identifying and examining issues, events, or findings that have happened in a physical sense, such as events that have occurred within an organisation, or findings from a research investigation.
In the Navigation Pane, select the report that you want to print. Click File and then click Print. On the Print area of the File options, click the Print option to open the Print dialog box. Change the page format setup or other print options or printer selection as needed, and then click OK to print your report.
B) A database is an organized collection of structured information, or data, typically stored electronically in a computer system. A database is usually controlled by a database management system (DBMS). The data can then be easily accessed, managed, modified, updated, controlled, and organized.
C) Microsoft Access Features;
Easier than a client-server database to understand and use. Import and export to other Microsoft Office and other applications. Ready templates for regular users to create and publish data. Allows building and publishing Web databases effortlessly.
D) Create a primary key to associate data between multiple tables.
-In the Navigation Pane, right click a table, and -select Design View.
-Select the field or fields you want to use as the primary key.
-Select Design > Primary Key.
E) A File System is a collection of raw data files stored in the hard-drive, whereas a database is intended for easily organizing, storing and retrieving large amounts of data. In other words, a database holds a bundle of organized data typically in a digital form for one or more users.