FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -Microsoft Access is a well-known database management system produced by Microsoft and is part of the Microsoft 365 office suite. Microsoft Access combines Microsoft’s relational Jet Database Engine with software development tools and a graphic user interface (GUI).

Detailed explanation-2: -The different ways of creating a database is by using a New tab in the Backstage view. The blank database is created using the to go option. The other way of creating a database is by using the several templates that are installed by default in Access.

Detailed explanation-3: -Way 1: Create Access database with templates. Way 2: Create a blank Access database with “Blank database” or “Blank Web database” command. Way 3: Import existing data into Microsoft Access and save as Access database.

Detailed explanation-4: -SQL is a computer language for working with sets of facts and the relationships between them. Relational database programs, such as Microsoft Office Access, use SQL to work with data. Unlike many computer languages, SQL is not difficult to read and understand, even for a novice.