General Structure
In the Relational Database Management System (RDMS), data is stored through the use of rows and columns. These rows and columns form a table – every value in the table is related. Tables are, at times, also related to one another – which makes it easy to run a query across many tables at once.
Leading Commercial Relational Database Vendors
Gartner one of the leading Information Technology analyst firms reports that Oracle was the leading commercial RDMS vendor in 2011, with a global market share of 48.8% (as cited in Mullins, 2011). This is more than all the next five on the list combined. IBM came in second with a market share of 20.2%, and Microsoft a distant third with a market share of 17.0% (Accion Labs, 2016).
Delegate your assignment to our experts and they will do the rest.
Microsoft Access
Microsoft Access is a system used in database management. It incorporates the use of relational type database management into a graphical user interface. It is typically included in the Microsoft Office Suite, though not all MS Office packages include MS Access.
Types of Object that can be Created using MS Access
There are six types of object that can be created using an MS Access database. Principle among them tables. Tables store data regarding a specific entity. They are comprised of records which are in turn made up of fields. A query offers a unique view of data on one or multiple tables. Forms facilitate a convenient method of data input and display. Reports summarize, calculate, format, and print selected data sets. Macros automate the performance of repetitive tasks. Modules contain custom procedures that have a greater ability to automate specific instances than macros.
Steps Involved in Importing Excel Worksheets into an MS Access DB
Click on the “External Data” tab. When the Excel button (EXTERNAL DATA tab | Import & Link group) is clicked the Get External Data – Excel Spreadsheet dialog box is displayed. Click the “Browse” button. Navigate to and click the desired Excel file. Once the file is opened, follow the simple instructions on the import wizard and choose where the data should be imported and the name of the new table (where applicable).
Steps in Backing up an MS Access Database
Open the database. On the “File” dropdown menu, open the backstage view and select “Save As.” With “Save Database As” already selected in the area marked File Types, click ‘Back Up Database’ found in the “Save Database As” region, and then click the Save As button. Select the desired location and filename. Click “Save.”
References
Accion Labs. (2016). Embracing open source databases . [online] Available at: https://www.accionlabs.com/articles/2018/4/18/embracing-open-source-databases [Accessed 4 Mar. 2019].
Mullins, C. (2011). The database report July 2011 . [online] The Data Administration Newsletter. Available at: http://tdan.com/the-database-report-july-2011/15299 [Accessed 4 Mar. 2019].