First, data processing (sort, filtering, lookup)
a) Freezing fields, sort on multiple fields
b) Cancel the order, freeze (menu "format" à "to cancel the freezing on all fields"), or directly close the table (not saved) to open
c) Find, replace
d) Filter (filter by selecting content (can contain logical relationships)) à Add a camouflage query advanced filter: "Record" à "Filter" à "Advanced Filter / Sort" Save Filter: "Save As Inquire"
Second, link, import and export table
a) Access can link other Access database or other RDBMS table files (link other data sources)
b) Link table: "File" à "Get External Data" à "Link table" Select "ODBC" in the file type to configure the ODBC and link dialog box
c) Import tables to import Excel, Outlook, text files (a certain format), and so on. . .
Export data: You can copy a piece of data in the table to Word, export into text files, RTF formats.
